I have a requirement where I have to update a particular field of all the rows of an existing table(Master Table). An API will be called with the PK of the table and the based on the response, data will be stored in the field. And this will be a scheduler which will run daily.
How can I achieve this?
Thanks in advance.
Discussion posts and replies are publicly visible
Hi there,
You can use this documentation to understand how to create a scheduler - https://docs.appian.com/suite/help/21.4/Intermediate_Event_-_Timer.htmlTo help you further, you can parse the response of the API. Get all the IDs in one integer list variable. Now use that variable to pass as a filter in the query to query the data from the table and then use the data returned, inside a forEach loop, to iterate through the list and with the help of a!update() function, you can update the respective parameter/field of the CDT.
Thank you for your response.
Do you think calling the entire ids from the table will create any memory/performance issue?
What number of IDs are we talking here?
more than 10,000
You can do it in batches. Create a batch of 500 items at a time and process that batch. Then pick the next batch. That way, you can process the entire data in 20-30 iterations.