Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
+1
person also asked this
people also asked this
Replies
27 replies
Subscribers
4 subscribers
Views
49038 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
Export to Excel
rajivr
Certified Associate Developer
over 7 years ago
My issue is:
I want to export may be one to two lakh of records in to an excel at a time. But i am not able to achieve this because the tool is not able to do so. So i had gone for batching(8000 records per batch) in exporting the same. Any alternatives on this?
Thanks in advance.
OriginalPostID-263138
Discussion posts and replies are publicly visible
0
aloks0189
Certified Lead Developer
over 7 years ago
First of all create a third party credential, and before I proceed further, I would like to know, which method are using for API like GET or POST
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Chitra Sharma
over 7 years ago
I am using POST method.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 7 years ago
Well, there is a Shared Component named as Send HTTP Request Plug-in at following URL:
forum.appian.com/.../summary
This contains a function named as httpPost() which will allow you to call a WEB-API having POST method, also try creating a Third-Party credentials from Appian Admin Console as you need to pass it while calling API for authentication/Authorization sake
This function will have several inputs such as endpoint, paramValues, headerNames, headerValues etc.. which you will be needed to pass, here endpoint is nothing but your API url
try this, let me know it any help needed
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 7 years ago
@chitrarekhas Have a look into this snapshot, i created a API which i tried to access using httpPost() which works well, you can have a bit of modification (like paramName, Values, endpoint etc..) and you can get the response out from API
Hope this will help you...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Chitra Sharma
over 7 years ago
Hi Alok, When I click on Test Connection, I am able to get the output in Web API, its working fine. I created a rule to call that web API with the syntax you provided, but I am getting some unexpected result as attached.
httpResponse.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 7 years ago
@chitrarekhas can you test the service using SOAPUI, check whether the response is coming as expected or getting the same issue.
Let me know the response which you are getting using SOAPUI
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 7 years ago
Follow this screenshot to configure SOAPUI Post Request
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Chitra Sharma
over 7 years ago
Hi Alok, Same message displayed in SOAP UI.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 7 years ago
Hi Chitra, That means there is no issue in your Expression rule which has httpPost() to call the Web-API, generally Status Code 200 indicates that everything is OK, please cross check the Web-API by clicking on Test button of API whether it's returning the body content or not, because in above attached HTML file, we are able to see that its returning empty Body response
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 7 years ago
Can you share the screenshot of Web-API, after Test Button clicked, what is it returning into it's response body, also try to use httpPost() as this attached sample
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
<
>