Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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)" );

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

 

rithusharma
Contributor
Contributor

A complete guide is available to get Survey Details about CVS Health Survey at CVS Survey Official Page.