Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert JSON (REST API) to QVD

Hi all,

I am using the REST API to retrieve data from a data source.

I cant seem to get the data from JSON back to a table. would appreciate your assistance

The original data is as follows:

json.png

The data that is returned is:

[{

"pulse": {

"url": "https://ainwejf.com/projects/57844221",

"id": 57844221,

"name": "Israel",

"updates_count": 0,

"board_id": 57843954,

"created_at": "2017-09-28T11:33:30Z",

"updated_at": "2017-09-28T11:34:50Z"

},

"board_meta": {

"position": 131072.0,

"group_id": "topics"

},

"column_values": [{

"cid": "name",

"title": "Name",

"name": "Israel"

}, {

"cid": "numbers",

"title": "ID",

"value": "1"

}, {

"cid": "text",

"title": "Name",

"value": "Eli Cohen"

}, {

"cid": "last_post",

"title": "Last Update",

"value": null

}, {

"cid": "status9",

"title": "Status",

"value": {

"index": 1,

"update_id": null

}

}, {

"cid": "due_date",

"title": "Due date",

"value": "2017-09-29"

}]

}, {

"pulse": {

"url": "https://ainwejf.com/projects/57844231",

"id": 57844231,

"name": "France",

"updates_count": 0,

"board_id": 57843954,

"created_at": "2017-09-28T11:33:40Z",

"updated_at": "2017-09-28T11:34:51Z"

},

"board_meta": {

"position": 196608.0,

"group_id": "topics"

},

"column_values": [{

"cid": "name",

"title": "Name",

"name": "France"

}, {

"cid": "numbers",

"title": "ID",

"value": "2"

}, {

"cid": "text",

"title": "Name",

"value": "Jaqueline Bou"

}, {

"cid": "last_post",

"title": "Last Update",

"value": null

}, {

"cid": "status9",

"title": "Status",

"value": {

"index": 0,

"update_id": null

}

}, {

"cid": "due_date",

"title": "Due date",

"value": "2017-09-30"

}]

}, {

"pulse": {

"url": "https://ainwejf.com/projects/57844232",

"id": 57844232,

"name": "Italy",

"updates_count": 0,

"board_id": 57843954,

"created_at": "2017-09-28T11:33:42Z",

"updated_at": "2017-09-28T11:34:53Z"

},

"board_meta": {

"position": 262144.0,

"group_id": "topics"

},

"column_values": [{

"cid": "name",

"title": "Name",

"name": "Italy"

}, {

"cid": "numbers",

"title": "ID",

"value": "3"

}, {

"cid": "text",

"title": "Name",

"value": "Mario Pivotto"

}, {

"cid": "last_post",

"title": "Last Update",

"value": null

}, {

"cid": "status9",

"title": "Status",

"value": {

"index": 2,

"update_id": null

}

}, {

"cid": "due_date",

"title": "Due date",

"value": "2017-10-05"

}]

}, {

"pulse": {

"url": "https://ainwejf.com/projects/57844233",

"id": 57844233,

"name": "USA",

"updates_count": 0,

"board_id": 57843954,

"created_at": "2017-09-28T11:33:44Z",

"updated_at": "2017-09-28T11:34:55Z"

},

"board_meta": {

"position": 327680.0,

"group_id": "topics"

},

"column_values": [{

"cid": "name",

"title": "Name",

"name": "USA"

}, {

"cid": "numbers",

"title": "ID",

"value": "4"

}, {

"cid": "text",

"title": "Name",

"value": "James Dan"

}, {

"cid": "last_post",

"title": "Last Update",

"value": null

}, {

"cid": "status9",

"title": "Status",

"value": {

"index": 7,

"update_id": null

}

}, {

"cid": "due_date",

"title": "Due date",

"value": "2017-10-03"

}]

}, {

"pulse": {

"url": "https://ainwejf.com/projects/57844235",

"id": 57844235,

"name": "Canada",

"updates_count": 0,

"board_id": 57843954,

"created_at": "2017-09-28T11:33:46Z",

"updated_at": "2017-09-28T11:34:57Z"

},

"board_meta": {

"position": 393216.0,

"group_id": "topics"

},

"column_values": [{

"cid": "name",

"title": "Name",

"name": "Canada"

}, {

"cid": "numbers",

"title": "ID",

"value": "5"

}, {

"cid": "text",

"title": "Name",

"value": "Peter Griffin"

}, {

"cid": "last_post",

"title": "Last Update",

"value": null

}, {

"cid": "status9",

"title": "Status",

"value": {

"index": 4,

"update_id": null

}

}, {

"cid": "due_date",

"title": "Due date",

"value": "2017-09-24"

}]

}]

0 Replies