JSON input without column names

[offcourse2]

Hi

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"

   }

}

[Anonymous]

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