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
This is a broad question and without contextual information it's impossible to answer so I'll ask a few questions to hopefully narrow down what you're looking for.
Are you looking for a high level solution design for this problem or the literal nuts and bolts of how to generate a scheduled process model and have it retrieve data from the data base and call an API?
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.
I am looking for a high level solution to this problem.
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.