topic Re: How to read Complex Json File in Talend Studio

How to read Complex Json File

Anonymous — Fri, 11 Aug 2017 09:13:57 GMT

Hi,

I have to read attached json file in Talend

{
	id: 1,
	field1: [
				{
					field2: value,
					field3: 
						{
							field4: 
							{
								field5: 
								{
									field6: 
									[
										{
											field7: value
										},
										{
											field7: value
										},
										{
											field7: value
										}
									],
									field9: 
									[
										{
											field10: value
										},
										{
											field10: value
										},
										{
											field10: value
										}
									]
								},
							}
						}
				}
			],
	field8:value
}

Please help.

Thanks

Re: How to read Complex Json File

Anonymous — Mon, 14 Aug 2017 02:55:41 GMT

Hi
Which fields do you want to read or all fields?

Regards
Shong

Re: How to read Complex Json File

root — Tue, 15 Aug 2017 13:18:36 GMT

Check out this component on Talend Exchange:

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

tJSONDoc* components 10.2 by Jan Lolling

Give it a try.