I have the following use case:I am calling 5 different APIs to retrieve data from 5 different tables in a database. Once I receive the responses from all the tables, I need to push those records into 5 corresponding tables in a SQL Server database in...
I want to call multiple GET APIs from my recipe. In Step 6, I am currently calling one GET API, but I need to retrieve data from multiple data stores using the same step/API. Essentially, I want to pass the name of the data store (API endpoint) at ru...
I am connecting to AWS from Workato and retrieving a token. Using this token, I am trying to connect to another application.My steps are: (In a Recipe)I created a trigger to schedule for every 6 hrsIn the next action, I am trying to use the HTTP conn...
HI @shivakumara ,Thank you, I appreciate your input. Yes, I believe this is the right approach to handle it on the SQL Server side, as it should be more reliable. I will try to implement this and let you know if I run into any issues.I just wanted to...
Thank you @Bhagya_pola , These details make sense to me. I can use the data table for this case and will complete the required mapping. I will let you know if I face any issues.I appreciate your assistance.
Thank you @Bhagya_pola for this, Using a lookup table or a data table was my initial thought, but I preferred to use a variable where I could simply create a list of strings to solve my problem. Since I only need to pass the table names dynamically i...
