Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to figure out something. I have a table which has clients. I'm trying to fill in a table called events using an API URL. I need to get the clients from the first table and then loop thru the events API URL to get info for each client in the first table. I can't figure out how to loop thru and then change the API URL for the second table depending on the client read from the first table.
Can you show us a screenshot of your job? It will be hard to identify how best to do this without knowing a little more about your job.
The easiest way to do this is to retrieve your looping data and feed it into a tFlowToIterate. This will store it in the globalMap and iterate over it for the next part of the job. You then need to connect your tFlowToIterate to a tJava (as a component to build your URL using Java String manipulation). From the tJava, connect your tRestClient component via an OnComponentOK link. Use the URL you have computed in the tRestClient.