topic Re: How to re structure my JSON structure ? in Talend Studio

How to re structure my JSON structure ?

Anonymous — Thu, 21 Sep 2017 14:49:55 GMT

Hi Talend community,

During my searching, I would like advice about this problem.

From this JSON file :

the json squeleton

I am searching to repeat this structure each time I have one line of content in this label :

"summary": "blah blah",

That is :

{
	"issueUpdates": [{
			"fields": {

				"project": {
					"key": " "
				},
				"summary": "",
				"description": "",
				"issuetype": {
					"name": ""
				},
				"reporter": {
					"name": ""
				},
				"assignee": {
					"name": ""
				},
				"labels": [""]
			}


		},

		{
			"fields": {
				
				"project": {
					"key": " "
				},
				"summary": "",
				"description": "",
				"issuetype": {
					"name": ""
				},
				"reporter": {
					"name": ""
				},
				"assignee": {
					"name": ""
				},
				"labels": [""]
				
				
			}
		}
	]
}

You see I would like to repeat a lot of times the structure fields and within one line of content in "summary".

For this thing I use the componant tWriteJSONField where I defined this JSON structure :

But in out, I have this JSON structure :

And I would like one structure " fields " by one " summary " content line. I am sure there is an error in my definition of JSON structure (tWriteJSONFields).

Any clues ?

Re: How to re structure my JSON structure ?

rsmits — Tue, 26 Sep 2017 13:41:47 GMT

Hi Alexandre44,

It's a lot easier to use these compoments:

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

Re: How to re structure my JSON structure ?

Anonymous — Tue, 07 Nov 2017 10:43:11 GMT

Hi,

I'm back ! Thanks for the link rsmits. I am trying tJSONDocOpen and tJSONDocOutput. Please, could anyone tell me if I am in the good direction ?

Thanks,

Re: How to re structure my JSON structure ?

rsmits — Tue, 07 Nov 2017 10:47:51 GMT

Hi Alexandre44,

I have written an howto at my Blog: http://talendhowto.com/2017/10/22/how-to-built-a-json-string-with-arrays/

I think this will help you!

Regards,

Remco

Re: How to re structure my JSON structure ?

Anonymous — Tue, 07 Nov 2017 14:02:02 GMT

Hi,

Thanks you very much Remco. I will study It.

Alexandre44