I am trying to parse telematics data, and am very new to Knime, but not new to ETL tools.
The data from my REST API Get is formatted like
{
“data”: [
{
“attributes”: [
{
“id”: “d64e2b41-f233-401c-83e6-786454343578”,
“name”: “XXX AASD”,
“stringValues”: [
“08.LF”
]
}
],
“cameraSerial”: “TRGD-VB9-S55”,
“externalIds”: {
“samsara.serial”: “GF9GFDAG13”,
“samsara.vin”: “1FTSSASDFBDR7804”
},
“gateway”: {
“serial”: “GAD-VPD-P4F”,
“model”: “VGFSNA”
},
“harshAccelerationSettingType”: “automatic”,
“id”: “28147434587833”,
“licensePlate”: “00481M1”,
“make”: “FORD”,
“model”: “E-350”,
“name”: “TRUCK”,
“notes”: “”,
“serial”: “GF9V334534C”,
“staticAssignedDriver”: {
“id”: “495143463”,
“name”: “Goeff Dunsworth”
}],
“pagination”: {
“endCursor”: “”,
“hasNextPage”: false
}
}
Using JSON to Table Knime creates a column for each data point, there is no grouping. So there is a Column
data.0.cameraSerial and then of course there is more than 1 vehicle so there will be a data.1.cameraSerial and data.2.cameraSerial columncs etc.
Not sure if my json to table is incorrect or if I should be using ungroup? but I’m unfamiliar with Ungroup as well,
thanks in advance,