Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
georgio_hb
Contributor III
Contributor III

How to get survey details while looping over the survery id

for i=1 to 12
let vID = FieldValue('survey_id',$(i));
let vURL2 = 'https://api.surveymonkey.com/v3/surveys/$(vID)/details';

 

SurveryFullDetails:
SQL SELECT
.

.

.


FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION(Url "$(vURL2)" );

1 Reply
Marcos_rv
Creator II
Creator II

Hi, try to use the rest of qv or qs connector, the correct way would be to make the connection for each time you change the IP address, you should connect with the connector, and when the loop completes, make a disconnection.


Regards!!!