Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
muhammadHamza
Contributor
Contributor

How to connect to qlik sense data using REST API

i have loaded the data in qlik sense desktop. now i want to retrieve this data by query or by using rest API call.
Is there any way to achieve this.

1 Reply
felipedl
Partner - Specialist III
Partner - Specialist III

You can use the rest connector to do that.

As an example, i'm using the https://jsonplaceholder.typicode.com link that has some rest functionalities.

Using the wizard, it gives the code:

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=https://jsonplaceholder.typicode.com/posts;timeout=30;method=GET;sendExpect100Continue=True;autoDete...;";

RestConnectorMasterTable:
SQL SELECT
"userId",
"id",
"title",
"body"
FROM JSON (wrap on) "root";

[root]:
LOAD [userId],
[id],
[title],
[body]
RESIDENT RestConnectorMasterTable;


DROP TABLE RestConnectorMasterTable;

Which loads the data from :
https://jsonplaceholder.typicode.com/posts