Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
As an addition to this topic, I'm excited to share my latest tutorial on integrating Asana with Qlik Cloud using REST APIs!
In this step-by-step guide, you'll learn:
- How to use Asana REST APIs with Postman
- Creating REST Data Connections in Qlik Cloud
- Extracting data from Asana and saving as Parquet files
- Enhancing connections with custom parameters and pagination
Check out the full video on YouTube:
Integrate Asana with Qlik Cloud Using REST APIs: A Step-by-Step Guide
https://youtu.be/lFwar30BNkQ?si=UZoM_x9L5amdJSnf
Regards,
Mark Costa