API Connector- multiple API connectors into one loop

[ewa1]

Hi, 
I'm trying to connect to the following API:

1) https://api.gios.gov.pl/pjp-api/rest/station/findAll -this works fine with REST connector

2) https://api.gios.gov.pl/pjp-api/rest/station/sensors/{stationId}

Example:  https://api.gios.gov.pl/pjp-api/rest/station/sensors/14 - only for chosen ID 

does not work when i typed in REST UI connector like this https://api.gios.gov.pl/pjp-api/rest/station/sensors/ or like this https://api.gios.gov.pl/pjp-api/rest/station/sensors/$(stationId)

and the second table with more detailed data, another API, that is connected to the first by key ID. It gives results just for one chosen ID from the first API data. I would like to loop this request to get all of data for all stationId. How to loop the request? How to approach this problem? Is it possible by setting correctly UI REST connector or does it need codding? Is so where to code this type of request? I have never done this before 🙂  I'm using Qlik Sense Cloud

[Damien_V]

Hello @ewa1 

You would need to use a loop statement in your script combined with the REST connector WITH CONNECTION statement.

This is explained in details here:

https://community.qlik.com/t5/Design/REST-connector-Using-WITH-CONNECTION/ba-p/1523257?advanced=fals...