Getting data from a REST endpoint using a loop

[spook2020202]

Hi,

I'm having trouble getting data from a rest endpoints using a loop.
What I'm doing is calling an endpoint which returns a list of football leagues:


Once it has this data, what im trying to do is loop through each item in the list, and for each one, query a different endpoint using the league_id. So using the table above, i would expect it to call the endpoints 20 times which would get all of the matches for each of the leagues.
The endpoints has some headers that need to be added to the call but the only "dynamic" part of the request is a query param. eg:

https://api-football-v1.p.rapidapi.com/v2/fixtures/league/<league_id_from_table>

EG:
https://api-football-v1.p.rapidapi.com/v2/fixtures/league/5

Is anyone able to assist or provide an example of looping through a table and making a rest call with headers?

Thanks 

[Gysbert_Wassenaar · Accepted solution]

Here's an example: https://community.qlik.com/t5/Qlik-Design-Blog/REST-connector-Using-WITH-CONNECTION/ba-p/1523257

[spook2020202]

Exactly what i needed. Thanks.