Skip to main content
V
vikashk4975
May 26, 2023
Question

Service backed record have more than 1000 records

  • May 26, 2023
  • 5 replies
  • 1 view

When creating a service backed record having more around more than 10,000 records, there is a error.

How to resolve that error? Should I go for disable sync options and then create.

5 replies

S
sanchitg0002
May 26, 2023

It is because Appian can only return a maximum of 1000 records with each call, when there are more records than this limit then you need to sync data in batches.

Checkout the documentation for Syncing in batches.

V
vikashk4975Author
May 26, 2023

There is rule input created as well in the Integration. Where to use that ri! in the Integration.

peter.lewis
peter.lewis
Employee
May 26, 2023

Does your integration support paging or batching in some manner? If so, that batch number rule input can be passed in to identify the batch. It will start with a value of 1 and increase one by one.

Since each integration is different, you'll need to consider how your integration in particular would support a batch number.

harshitb6843
harshitb6843
May 26, 2023

Why would you return 10k rows in a single go? Even if you want to display it in a grid, then too it should be not more than 100 at a time, Appian still has a limit of 1000. 

Also, for the rule input, it should be of type PagingInfo and then you configure the paging info from the "Edit Grid" option. 

mathieud0001
mathieud0001
Brainy
May 26, 2023

The API you are calling needs to support paging to be able to configure the batching.

There are ways around this if the API doesn't support any form of paging but they are not simple.

Terms & ConditionsAccessibility statement