GET Request with JSON Parse

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,