Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
when I am using qlik api to extract data of datasets as per Data sets | Qlik Developer Portal
I am getting error "404 Not Found" in Web and Postman application
Syntax as per Qlik api:
"https://your-tenant.us.qlikcloud.com/api/v1/data-sets/{data-set-id}"
Below are the scenarios and their results.
Trail 1: https://polestarllp-in.ap.qlikcloud.com/api/v1/dataset/6317438d0bbe036e62fc4de9
Response: "404 Not Found"
Trail 2: https://polestarllp-in.ap.qlikcloud.com/dataset/6317438d0bbe036e62fc4de9
Response: HTML output of that dataset page
Trail 3: https://polestarllp-in.ap.qlikcloud.com/v1/dataset/6317438d0bbe036e62fc4de9
Response: Opening Qlik but blank
Trail 4: https://polestarllp-in.ap.qlikcloud.com/data-sets/6317438d0bbe036e62fc4de9
Response: Opening Qlik but blank
Trail 5: https://polestarllp-in.ap.qlikcloud.com/api/v1/data-sets/6317438d0bbe036e62fc4de9
Response: "Exception.resourceNotFound"
My requirement is to access the data of that Dataset with Qlik API this is required for me to do automation workflow. How to access the data of Qlik dataset with Qlik api?
The id from the URL is the item id, you will need to get the details for that item using that id:
GET /v1/items/{itemId}
Once you get the item it will have the resourceid, and that is the one that can be used with
GET/v1/data-sets/{data-set-id}
Kind Regards!!
Hi @Venkadesh_Ponnu
If you place the URL directly in your browser (after you are authenticated in Qlik Cloud" what is the error you get ? I usually use Firefox for Get API methods, it should give you a more detailed error.
https://<yourtenant>/api/v1/data-sets/<data set id>
Kind Regards,
Please find the error below when I am using https://polestarllp-in.ap.qlikcloud.com/api/v1/data-sets/6317438d0bbe036e62fc4de9
Error:
0 | |
status | "404" |
code | "Exception.resourceNotFound" |
title | "Resource Not Found" |
detail | "No record of data set could be found with id 6317438d0bbe036e62fc4de9." |
traceId | "0000000000000000a82aa6f083fb7327" |
ScreenShot:
Please find screenshot when I used https://polestarllp-in.ap.qlikcloud.com/dataset/6317438d0bbe036e62fc4de9
Please let me know for more information.
The id from the URL is the item id, you will need to get the details for that item using that id:
GET /v1/items/{itemId}
Once you get the item it will have the resourceid, and that is the one that can be used with
GET/v1/data-sets/{data-set-id}
Kind Regards!!
Once a connection to a REST data source has been established, you can select data and load it into a Qlik Sense or QlikView app. You select data by selecting REST tables and fields in the data selection dialog. You can load data using either Add data or the Data load editor.
Hi @Chokiha ,Hi @NadiaB
I am getting below schema information rather than data present in the dataset. Could you please help me here?
URL used: https://tenant-in.ap.qlikcloud.com/api/v1/Data-sets/{{Item id}}
"schema": {
"dataFields": [
{
"name": "automl_row_index",
"alias": "automl_row_index",
"index": 0,
"dataType": {
"type": "INTEGER",
"properties": {
"qType": "U",
"qnDec": 0,
"qUseThou": 0
}
},
"tags": [
"$integer",
"$numeric"
],
"sensitive": false,
"primaryKey": false,
"encrypted": false,
"orphan": false,
"nullable": false
},
{
"name": "Impact_predicted",
"alias": "Impact_predicted",
"index": 1,
"dataType": {
"type": "STRING",
"properties": {
..........................................................................
...........................................................................
"name": "Impact_High",
"alias": "Impact_High",
"index": 2,
"dataType": {
"type": "DOUBLE",
"properties": {
"qType": "U",
"qnDec": 0,
"qUseThou": 0
}
},
"
"loadOptions": {},
"effectiveDate": "2022-09-06T12:56:48.340Z"
Did you call GET /v1/items/{itemId} first ?
Could you share that output ?
That is the one that will give you the "resourceid" that is the one you use in the data-sets endpoint, I tested it yesterday and works fine.
Could you share the result of the following ? (the ItemID is the one you copied from the URL when accessing to your dataset )
https://<yourtenant>/api/v1/items/<itemid>
Thank you !
Hi @NadiaB ,
Yes, I received the resource id with the help of your information, with resource id I received the above-mentioned results it looks like metadata information.
Require help to access the data.
URL 1:https://polestarllp-in.ap.qlikcloud.com/api/v1/items/{{Item id}} - gave me resource id
URL 2 : https://polestarllp-in.ap.qlikcloud.com/api/v1/Data-sets/{{resource id}} - gave me metadata information
@Chokiha
URL 2 results:
Hi @Venkadesh_Ponnu
The result obtained with the api endpoint (metadata) is consistent with the documentation you have shared, so the API works fine.
It looks you are looking to download the file itself, I found similar request marked as "no solution available", "feature request", it seems at the moment is not possible to do so.
Let me know if there are any questions.
Thank you for your information😊. please let me in any other way we can access data of dataset via api I will raise new request if required.