Hi All,
I am trying to get the data through rest API calls for different file ID's. But the structure of the data i.e.e the number of columns are varying. In this case How can I write a loop which goes through each file ID and selects all the columns.
Sample Code:
For i=0 to NoOfRows('elements')-1
let vele1=peek('id',i,'elements');
let vele2=peek('fileid',i,'result_fileid');
let vele3=peek('name',i,'elements');
LIB CONNECT TO 'final export (cysemi_niki)';
RestConnectorMasterTable:
SQL SELECT * FROM CSV (header on, delimiter ",", quote """") "CSV_source"
WITH CONNECTION(Url "https://cypress.co1.qualtrics.com/API/v3/surveys/$(vele1)/export-responses/$(vele2)/file");
[$(vele3)]:
LOAD *
RESIDENT RestConnectorMasterTable;
DROP TABLE RestConnectorMasterTable;
next i
However, the above code did not work since it is not accepting "*". It would be great if someone could help me with this issue.
Thanks,
Nithin.
