Create complex json

[jordan_bobo]

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

[David_Beaty]

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

[jordan_bobo]

Hello David,

Very Interesting.

Do you have an example ?

I have structure with array on 5 level.

[root]

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.