topic Create complex json in Talend Studio

Create complex json

jordan_bobo — Sat, 16 Nov 2024 00:40:08 GMT

Hello everybody,

We need to create complex structure with multiple level (5 levels and a lot of fields) for json / avro and parquet file.

I try a lot with the component without success.

Do you think it is more simple with talend data mapper ?

I have no data mapper (need a stronger licence)

Thanks a lot

Re: Create complex json

David_Beaty — Sun, 07 Feb 2021 11:58:56 GMT

Hi,

When a single data structure is too complex, I've had to construct it as a number of individual JSON objects and do things like tAggregateRow with the List(object) function and then use a tJavaRow to form the final JSON object manually.

I'm thinking about multiple/separate repeating loops of data, JSON Structures that are key/value pairs.

Thanks

David

Re: Create complex json

jordan_bobo — Sun, 07 Feb 2021 22:13:42 GMT

Hello David,

Very Interesting.

Do you have an example ?

I have structure with array on 5 level.

Re: Create complex json

root — Mon, 22 Feb 2021 15:19:18 GMT

I use https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F1438&pi=marketplace%252F1%252Fproducts%252F1438%252Fitems%252F2887

Super easy and flexible to create/ ingest any complex json obect.