topic Convert JSON (REST API) to QVD in QlikView

Convert JSON (REST API) to QVD

Wed, 25 Nov 2020 16:16:04 GMT

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:

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"

}]

}]