topic Re: Using a variable in a API URL in Talend Studio

Using a variable in a API URL

Anonymous — Tue, 14 May 2019 21:07:30 GMT

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.

Re: Using a variable in a API URL

Anonymous — Wed, 15 May 2019 08:11:14 GMT

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.

Re: Using a variable in a API URL

Anonymous — Wed, 15 May 2019 14:46:32 GMT

Here's an screenshot. I'm not sure that I'm on the right track at all.

PGA festivals from API.PNG

Re: Using a variable in a API URL

Anonymous — Thu, 16 May 2019 08:06:53 GMT

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.