Hi, I am using "Execute Process Report " smart service for

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 Reply Children
No Data