How to map a JSON

Anonymous — Tue, 12 Mar 2019 13:19:36 GMT

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

Re: How to map a JSON

Anonymous — Wed, 13 Mar 2019 19:59:26 GMT

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 🙂

topic How to map a JSON in Talend Studio

How to map a JSON

Re: How to map a JSON