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.
Discussion posts and replies are publicly visible
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
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:
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.
Hi Peter,
Thankyou for your response. The expression rule for recordDataSource looks like this-
not sure if I need to do any additional configuration for the paging to work. Please not that my integration rule!IntegrationObject() is not having any addition parameter for pagination of batchsize. Could you please help me with any code snippet to resolve this issue. Thanks in Advance