topic Re: Loop Rest API with nested SQL statements. in App Development

Loop Rest API with nested SQL statements.

tayariib85 — Mon, 27 Feb 2023 10:39:06 GMT

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

Re: Loop Rest API with nested SQL statements.

henrikalmen — Tue, 28 Feb 2023 08:38:22 GMT

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.

Re: Loop Rest API with nested SQL statements.

tayariib85 — Wed, 01 Mar 2023 10:49:09 GMT

Many Thanks!

Re: Loop Rest API with nested SQL statements.

marksouzacosta — Sat, 15 Jun 2024 22:07:41 GMT

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