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
Replies
9 replies
Subscribers
10 subscribers
Views
7447 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Unable to fetch entire data using #getdatasubsetdownloadlinkfromprocess
pradeepd761
over 7 years ago
Hi All,
As we have our environment on cloud I am using #getdatasubsetdownloadlinkfromprocess to fetch data from process model.
I am to extract data in excel sheet, however data in table is 7000 rows, but I can see only 1200 being extracted. I have used query entity with pagination(1 to -1).
So, my question is, how do I pull all data (7000 rows), in single sheet of excel sheet without making any changes in configuration file and in single instance.
OriginalPostID-256036
Discussion posts and replies are publicly visible
Top Replies
Gajapathy Ganesan
over 4 years ago
in reply to
Thenmozhi Mohanakrishnan
+1
Thanks Thenmozhi Mohanakrishnan I was also facing this issue and this solution worked!!
Parents
0
sikhivahans
over 7 years ago
@pradeepd A few questions for you as follows:
1. How many columns are you trying to retrieve?
2. What's the reason behind the failure in getting the data? Is the query entity unable to retrieve the data though you have given -1 as batchSize or is the process failing on the whole?
From the configuration perspective, I don't think there is much to do and we have to align with the constraints laid by the plugin. And re 7000 rows, I opine that these kinds of data sets must be pulled in batches rather than pulling all at once and for this, you may want to go for looping in the process. Meanwhile, I would also suggest checking if the process completes in 60 seconds and if not, start looking at alternatives.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sikhivahans
over 7 years ago
@pradeepd A few questions for you as follows:
1. How many columns are you trying to retrieve?
2. What's the reason behind the failure in getting the data? Is the query entity unable to retrieve the data though you have given -1 as batchSize or is the process failing on the whole?
From the configuration perspective, I don't think there is much to do and we have to align with the constraints laid by the plugin. And re 7000 rows, I opine that these kinds of data sets must be pulled in batches rather than pulling all at once and for this, you may want to go for looping in the process. Meanwhile, I would also suggest checking if the process completes in 60 seconds and if not, start looking at alternatives.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data