Hi all!Once we create a record via Web Service, we will be creating a Connected System along with Integration, now Appian creates us a new record data expression with a single rule input -> ri!batchNumber. Now, lets say I have a web API which has more than 2,000 rows of data. Now, at first iteration the batchNumber will be 1 and in next iteration the batchNumber will be 1001 i.e
for each iteration our start index ---> 1 + ((batchNumber - 1) * batchSize) Now, do we have to handle this manually or Appian handles by itself ? i) Could anyone send me a sample working record data source expression code that handles the paging Info.ii) Do we need to handle this pagingInfo in the Integration also? A sample screenshot would be appreciated for both Integration and Expression
Discussion posts and replies are publicly visible
Thank you, But what if the API doesn't support paging ? The integration will return only upto 1000 records is it
Gurusai said:But what if the API doesn't support paging ? The integration will return only upto 1000 records is it
Hi Gurusai just a thought on this situation then you need to set a limit on the data they can return
If the pagination is configured in API, then -> we can pass the pagination as mentioned by Yogi Patel -> But if the API doesn't support pagination then we can convert the data to a datasubset like below:Things to consider for both the above cases:-> We need to make sure that whatever field that we are choosing as a Primary field, has to be unique else, the sync will fail-> Data needs to be either List of Map/ List of CDT/ List of Dictionary