Parse nested JSON to CSV

Anonymous — Wed, 01 Jul 2020 20:59:50 GMT

Hi,

I need to create the following csv starting from the json below

{
	"data": [{
			"id": 1,
			"data": {
				"Tid": 1,
				"derived.security.Coupon.notional": 10,
				"derived.security.Coupon.paymentAmount": {
					"rows": [{
							"paymentAmount": 1,
							"periodNum": 1
						}, {
							"paymentAmount": 2,
							"periodNum": 2
						}
					]
				},
				"derived.security.Coupon.paymentRate": {
					"rows": [{
							"paymentRate": 0.5,
							"periodNum": 1
						}, {
							"paymentRate": 0.25,
							"periodNum": 2
						}
					]
				},
				"derived.security.Coupon.schedule.scheduleType": "A",
				"derived.security.Coupon.schedule": {
					"rows": [{
							"accrualEndDate": "31/12/2021",
							"periodNum": 1
						}, {
							"accrualEndDate": "31/12/2022",
							"periodNum": 2
						}
					]
				},
				"security": {
					"rows": [{
							"name": "APPLE"
						}, {
							"name": "PINTEREST"
						}, {
							"name": "GOOGLE"
						}
					]
				}
			}
		}, {
			"id": 3,
			"data": {
				"Tid": 3,
				"derived.security.Coupon.notional": 40,
				"derived.security.Coupon.paymentRate": {
					"rows": [{
							"paymentRate": 2,
							"periodNum": 1
						}, {
							"paymentRate": 1.5,
							"periodNum": 2
						}
					]
				},
				"derived.security.Coupon.schedule.scheduleType": "C",
				"derived.security.Coupon.schedule": {
					"rows": [{
							"accrualEndDate": "31/03/2021",
							"periodNum": 1
						}, {
							"accrualEndDate": "31/03/2022",
							"periodNum": 2
						}
					]
				}
			}
		}, {
			"id": 4,
			"data": {
				"Tid": 4,
				"derived.security.Coupon.notional": 20,
				"derived.security.Coupon.paymentAmount": {
					"rows": [{
							"paymentAmount": 2,
							"periodNum": 1
						}, {
							"paymentAmount": 4,
							"periodNum": 2
						}
					]
				},
				"derived.security.Coupon.paymentRate": {
					"rows": [{
							"paymentRate": 2,
							"periodNum": 1
						}, {
							"paymentRate": 1.5,
							"periodNum": 2
						}
					]
				},
				"derived.security.Coupon.schedule.scheduleType": "D"
			}
		}
	]
}

Could you please help me?

Thanks,

Paolo

Re: Parse nested JSON to CSV

manodwhb — Fri, 07 Aug 2020 01:44:09 GMT

@not specified not specified , if you are using Talend Enterprise software you can leverage Talend Data Mapper would be easy to convert this.

Thanks,

Manohar

Re: Parse nested JSON to CSV

Talend_ent — Sat, 28 Nov 2020 16:41:41 GMT

can't we do with other components/approaches rather than using Talend Data Mapper?

Thanks,

Talend_ent.

Re: Parse nested JSON to CSV

root — Mon, 07 Dec 2020 18:11:08 GMT

You can try tJSONDoc component available in the Talend Extensions... its source is available https://github.com/jlolling/talendcomp_tJSONDoc

topic Re: Parse nested JSON to CSV in Talend Studio

Parse nested JSON to CSV

Re: Parse nested JSON to CSV

Re: Parse nested JSON to CSV

Re: Parse nested JSON to CSV