Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The scenario I have is to perform an action on a Rest API that requires a single ID to be passed in the URL. the response then returns a single Row of data with a JSON structure for a single record which i can happily parse with textractJSONFields. However, the record ID (the one I passed into the tRest Component) is not included in the JSON response. The ID I'm inputting to the tRest component is a data flow (i.e. 400 IDs). I need to join the responses with the original ID. Assuming the rows in the output are returned in the as the same order as the input I can store the inputs with a row number:ID pairs and calculate the row numbers on the output and join back to the ID with a lookup (i.e. joining based on row number in the flow). Is there a better approach to solve this problem?
Another idea I can think of is to use a tLoop and pass the ID in one row at a time via a Global variable and then use a tJavaRow to join back my ID form the Global Variable after I've parsed the JSON.
What would be the best approach?