How to map a JSON

[Anonymous]

Hi there,

I'm new to TOS and i have a JSON stream to map. I tried to use the metadata, but I cant use wildcards this way. The json looks like this :

main:{

    "1":{

       "a": ...

       "b": ...

    },

    "2":{

       "a": ....

       "b": ....

    },

    ....

}

For now, I use a succession of tExtractJson->tMap to parse "main" then "1"-"n" then "a", "b" before inserting in database.

Does someone know a good way to map this?

thx

[Anonymous]

Hi,

   Could you please provide the actual structure for verification with sample records? Please also specify the expected output for the same. Then we will check the rest of the items.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂