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?
I am looking for a high level solution to this problem.