Skip to main content
gurusaig
June 14, 2024
Question

Synced Record Data Source Expression for Service Backed Record

  • June 14, 2024
  • 5 replies
  • 0 views

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

5 replies

June 14, 2024
1. RecordDataSource:  Convert batchNumber to underlying API requirements
2. Integration: Need to pass page parameters to API
3. Appian will execute RecordDataSource until an empty set or null is returned from API.
gurusaig
gurusaigAuthor
June 14, 2024

Thank you,
But what if the API doesn't support paging ? The integration will return only upto 1000 records is it

karumurua531442
June 14, 2024
But what if the API doesn't support paging ? The integration will return only upto 1000 records is it

Hi [mention:b4a29b8026ec457ebabd62f64a4d88c0:e9ed411860ed4f2ba0265705b8793d05] just a thought on this situation then you need to set a limit on the data they can return

jayaprakashr0001
Participating Frequently
June 14, 2024

Appian will handle the batch number. 

In the integration you need to have the batch number parameter.