JSON input without column names

offcourse2 — Sat, 16 Nov 2024 00:54:16 GMT

I am trying to make use of a JSON input I receive from a REST API, where the data doesn't seem to have column names.

The first node is the name of the car model "code", with the name in the sub-node.

However, using this I can't list all the model nodes, as I have no name.

Any idea how to make use of this data, so I can convert it to a flat table?

{

"silver-spur": {

"pt": "Silver Spur",

"en": "Silver Spur"

"accent": {

"pt": "Accent",

"en": "Accent"

"granada": {

"pt": "Granada",

"en": "Granada"

"sintra": {

"pt": "Sintra",

"en": "Sintra"

"c-180": {

"pt": "C 180",

"en": "C 180"

"santana": {

"pt": "Santana",

"en": "Santana"

"astra-cabrio": {

"pt": "Astra Cabrio",

"en": "Astra Cabrio"

"ateca": {

"pt": "Ateca",

"en": "Ateca"

}

Re: JSON input without column names

Anonymous — Thu, 24 Dec 2020 07:17:30 GMT

What are expected output from this Json input? As there is no a fixed node that can be used as loop element, so the Json components such as tFileInputJson, tExtractJsonField can not process it, maybe you can try tExtractRegexField component using regex expression.

Regards

Shong

topic Re: JSON input without column names in Data Quality

JSON input without column names

Re: JSON input without column names