topic REST API Connector, how to fetch in loop in QlikView

REST API Connector, how to fetch in loop

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

We have a requirement, where we will be getting a URL for REST API, in the format -

http://<server name:port>/folder/paramId=0001‌

The paramId will vary for each image, and for each paramId, I want to fetch the values inside QlikView.

The return type will be in binary format, but when I try to get the output, I am getting only values like in the attachment.

I have two queries -

1. Is there is any way where we can fetch all the image id i.e. paramId data inside QlikView using single ODBC string

2. How to fetch binary data from URL using REST API Connector

I am new to REST API, so please assist.

Thanks & Regards,

Re: REST API Connector, how to fetch in loop

marksouzacosta — Sat, 15 Jun 2024 22:11:20 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