Skip to main content
shrutik0007
April 21, 2022
Question

Pagination error for service backed record using integration

  • April 21, 2022
  • 4 replies
  • 0 views

I have created a service backed record having data source as integration. The record data source expression is returning around 500 records but when I try to access it through tempo record it is giving me expression evaluation error that batch size is 100 but largest colum value is 500.

Can anyone suggest me how can I set pagination for my record type to get all the data receiving from integration in order to resolve this issue.

4 replies

April 22, 2022

Hi,

you need to configure pagination in record data source expression rule. Please review Appian documentation to know how to configure Service Backed Record https://docs.appian.com/suite/help/22.1/Service-Backed_Record_Tutorial.html#configure-the-rule-inputs-for-paging,-searching,-and-filtering

shrutik0007
April 22, 2022

Hi Naresh,

I have done pagination as per the example but still getting the error. Below are the screenshots of pagination settings in expression rule and record type:

peter.lewis
Employee
April 22, 2022

I see the batch size used in your a!dataSubset() function, but are also using that same batch size to limit the data returned in your source expression? Keep in mind that the a!dataSubset() function doesn't actually limit the data - it's just a way to construct the source correctly. So likely what is happening is that your local!integrationResponse.result.body.data is returning 500 items an you need to change that to only return 100.