Hi All ,
Need to send the data from appian to external system and set flag to yes for all the rows which has been sent successfully in Appian table to ignore these rows for next set of data to send. What is the best way to do this.
Discussion posts and replies are publicly visible
Can i know how you are filtering data
Hi harikumarm0002 ,
Can you tell how you are passing , Assuming you are using queryrecord() you can have the filters and you can pass the required data to external system
If you are calling this integration from the process model, you can simply update the rows you fetched earlier to send, set the flag, and update them back in the DB.
If you are doing it from the interface, you can use the integration rule's onSuccess parameter to call a!writeToDataStoreEntity or a!writeRecords and it should do the work.
i am using expression rule to fetch the data from DB here applying some filters( related this data UI user can edit n number of times they can able to changes that many times sending data to external system). so if i set the flags if user not change anything will avoid that cases/ requests
Hi Harshit ,
we are using GET web api call smart services are not supporting
You are sending rows using a GET API?
yes
When we talk about implementing a web API that other systems can call to query data, I recommend to not store any data locally, but to let the other system decide what to put into the response. A frequently used approach is to add paging info like start index and batch size to the call. Then you API can fetch the requested data and send it back.