Loop Rest API with nested SQL statements.

[tayariib85]

Hello Guys,
I have this URL with multi Ids and nested SQL statement, it works, but I have two problems, I have duplicated rows and Synthetic key.  please any advice!

thanks

[henrikalmen · Accepted solution]

First (before the loop) create an empty table:

DBTable: load * inline [
dummy
];

Inside your loop, do this: concatenate(DBTable) load ...

And afterwards you can drop field dummy;

Something along those lines should probably work for you.

[tayariib85]

Many Thanks!

[marksouzacosta]

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