Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
}]
}]