Extracting JSON values not having the attribute names

Question

Hi, I have a JSON input file which does not have any attribute name. Now, how do I extract values from this file?

Input Data:

{
 "A1":{
       "name":"Ad hoc",
       "projectId":0
      },
 "X2":{
       "name":"BBB",
       "projectId":101
        },
 "AB":{
       "name":"CCC",
       "projectId":102
        },
 "recordsCount":3
 }

Output must look like:

 A1, Ad hoc
 X2, BBB
 AB, CCC

Please suggest.

Answer 1

Sorry, but XPath query can’t read unnamed attributes. To make this file useful you still need to add the surrounding brackets to it and then using JsonPath. In the path, you also need to specify $.*

[
    {
 "A1":{
       "name":"Ad hoc",
       "projectId":0
      },
 "X2":{
       "name":"BBB",
       "projectId":101
        },
 "AB":{
       "name":"CCC",
       "projectId":102
        },
 "recordsCount":3
    }
]

Further, you can extract the values using a tExtractJSONFields component.

But the correct way of extracting the data would be by modifying the data with proper attribute names.