Run a scheduler for each row of the Master table

Question

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.

Harshit Bumb (Appyzie) · Answer

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.html To 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.

Run a scheduler for each row of the Master table

Top Replies