Skip to main content
gurusaig
Participating Frequently
Jun 14, 2024 11:41 AM UTC
Question

Synced Record Data Source Expression for Service Backed Record

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

Brainy
Jun 14, 2024 12:37 PM UTC
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
Participating Frequently
Jun 14, 2024 3:59 PM UTC

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

karumurua531442
Participating Frequently
Jun 14, 2024 4:03 PM UTC
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
Jun 14, 2024 12:42 PM UTC

Appian will handle the batch number. 

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