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
5 replies
Subscribers
4 subscribers
Views
2110 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Hi, I am using "Execute Process Report " smart service for
sapnas
over 8 years ago
Hi,
I am using "Execute Process Report " smart service for one of my requirements.
The requirement is - I need to fetch subset of the records say., 100 records from the portal report that has about 10000 records and persist to a database. This way I would like to repeat the process until all records/data are fetched and moved to database.
As per the configuration of the aforementioned smart service, "Max Rows" field allows us to set the batch size as 100 but the problem I see is this smart service does not have the provision to fetch the next 100 rows once the first 100 rows are processed.
When I tested this in loop I observed that every time on execution the smart service returns only first 100 rows from the portal report but does not fetch the next set and so on.
Could you please let me know if the behavior of this smart service is limited to fetching only first 100 rows if the Max Rows field is set to 100 and does not help in fetching f...
OriginalPostID-164161
OriginalPostID-164161
Discussion posts and replies are publicly visible
Parents
0
sapnas
over 8 years ago
...urther rows in a loop ?
( Note : As an alternative, I tried an approach that uses queryProcessAnalytics() but I was unable to capture the response from queryProcessAnalytics() to any predefined datatype in Appian i.e., when I tried to capture the response to a datatype called "PortalReportDataSubset" I got all blank values or rather empty dictionary. I believe this could be due to "PortalReportDataSubset" been a third party plugin and not Appian defined datatype.)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sapnas
over 8 years ago
...urther rows in a loop ?
( Note : As an alternative, I tried an approach that uses queryProcessAnalytics() but I was unable to capture the response from queryProcessAnalytics() to any predefined datatype in Appian i.e., when I tried to capture the response to a datatype called "PortalReportDataSubset" I got all blank values or rather empty dictionary. I believe this could be due to "PortalReportDataSubset" been a third party plugin and not Appian defined datatype.)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data