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
Appian will handle the batch number.
In the integration you need to have the batch number parameter.
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