Parsing Json without specifying fields

mat007g · ‎2018-10-11

Hi,

I have a Json object which is retrieved through a REST api such as the one below

{

"id": 123 ,

"location": "Europe",

"names": {

"John" : 4 ,

"Mark" : 4,

"Luke" : 4,

"Matthew" : 7

}

I would like to loop through all the names, without specifying each name as a field, and store each pair <string,integer> as a separate row.

When using tExtractJSONFields, the names object is returned as a string and not as an Object, and thus cannot store it as a hashmap.

When using tExtractDelimetedFields, this cannot be parsed, since the whole object is one string.

Is there a way other than using Java to do this?

Thanks.

Anonymous · ‎2018-10-19

Hello,

Could you please let us know if this related topic helps?

Best regards

Sabrina