Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
georgio_hb
New Contributor II

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
Contributor

Re: How to get survey details while looping over the survery id

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!!!