Get Data using API

aghabdurauf — Fri, 19 Jul 2024 18:42:20 GMT

Hello,

I am new in Qlik Sense, I need a help from the community.

I have JSON API and I want to get data by using API REST in Qlik, I never use API in Qlik.

Help me out how it is possible to get data, share any video link or a tutorial for help to achieve this.

Under is the JSON API

{
"info": {
"_postman_id": "762a635f-ab3e-4068-a79f-379c68b7fe91",
"name": "ObjectTest",
"schema": "https://schema.getpostman.com/json/collection/v2.1.0/collection.json"
},
"item": [
{
"name": "SalesEvent1",
"request": {
"auth": {
"type": "basic",
"basic": [
{
"key": "password",
"value": "*****",
"type": "string"
},
{
"key": "username",
"value": "*****",
"type": "string"
}
]
},
"method": "GET",
"header": [],
"url": {
"raw": "http://*****/DashboardAPI/api/data/SalesEvent1",
"protocol": "http",
"host": [
"*****"
],
"port": "*****",
"path": [
"DashboardAPI",
"api",
"data",
"SalesEvent1"
]
}
},
"response": []
},
{
"name": "SalesEvent2",
"request": {
"auth": {
"type": "basic",
"basic": [
{
"key": "password",
"value": "*****",
"type": "string"
},
{
"key": "username",
"value": "*****",
"type": "string"
}
]
},
"method": "GET",
"header": [],
"url": {
"raw": "http://*****/DashboardAPI/api/data/SalesEvent2",
"protocol": "http",
"host": [
"*****"
],
"port": "*****",
"path": [
"DashboardAPI",
"api",
"data",
"SalesEvent2"
]
}
},
"response": []
},
{
"name": "SalesEvent3",
"request": {
"auth": {
"type": "basic",
"basic": [
{
"key": "password",
"value": "*****",
"type": "string"
},
{
"key": "username",
"value": "*****",
"type": "string"
}
]
},
"method": "GET",
"header": [],
"url": {
"raw": "http://*****/DashboardAPI/api/data/SalesEvent3",
"protocol": "http",
"host": [
"*****"
],
"port": "*****",
"path": [
"DashboardAPI",
"api",
"data",
"SalesEvent3"
]
}
},
"response": []
}
]
}

Thanks

Re: Get Data using API

cotiso_hanganu — Sat, 20 Jul 2024 09:20:44 GMT

It looks that you have tested already the REST API in Postman. For me this is usually the hardest part.

Once you have a functional Postman test, go to Script Editor, create a new connection, select REST API (by the way, it works the same also with SOAP API) then fill in the following wizard form the connection details, similar to Postman.

After successfully testing and choosing a connection name, press SAVE.

A new connection will be defined in the right panel.

Press on select table button next under the connection, a new wizard starts, activate the checkboxes for all the data hierarchy on the left, inspect results on the right, then press insert script.

=> All the loads plus previous connect are already inserted

Reload script and it's done.

Afterwards you can decide if some of the secondary loads can be dropped

Also you can use $(variable) to create more dynamic calls.

Even expand using WITH CONNECTION (very powerful for dynamics calls l!)

topic Re: Get Data using API in Integration, Extension & APIs

Get Data using API

Re: Get Data using API