topic Re: how to ? : json array as well if single entry in Talend Studio

how to ? : json array as well if single entry

iztoogood — Thu, 11 Oct 2018 11:49:04 GMT

Hello,

I'm trying to build a json with an array element,

when the field has multiple element : the json element is ok, it's an array as wanted...

but if the fied has a single entry... the element is turned as string and i would like it to stay a array with a single entry.

My exampel job look like that :

its résult is :

.-------+-----------------.
|       show source       |
|=------+----------------=|
|Father |Child            |
|=------+----------------=|
|Pierre |Kevin,Jordy,Dylan|
|Paul   |Lorie,Alizé      |
|Jacques|Lana             |
'-------+-----------------'

.-------+-----.
|Child as row |
|=------+----=|
|Father |Child|
|=------+----=|
|Pierre |Kevin|
|Pierre |Jordy|
|Pierre |Dylan|
|Paul   |Lorie|
|Paul   |Alizé|
|Jacques|Lana |
'-------+-----'
.-----------------------------------------------------.
|                  children in array                  |
|=---------------------------------------------------=|
|json                                                 |
|=---------------------------------------------------=|
|{"Father":"Pierre","Child":["Kevin","Jordy","Dylan"]}|
|{"Father":"Paul","Child":["Lorie","Alizé"]}          |
|{"Father":"Jacques","Child":"Lana"}                  |
'-----------------------------------------------------'

.---------------------------------------------------------------------------------------------------------------------------------------.
|                                                                result                                                                 |
|=-------------------------------------------------------------------------------------------------------------------------------------=|
|json                                                                                                                                   |
|=-------------------------------------------------------------------------------------------------------------------------------------=|
|[{"Father":"Pierre","Child":["Kevin","Jordy","Dylan"]},{"Father":"Paul","Child":["Lorie","Alizé"]},{"Father":"Jacques","Child":"Lana"}]|
'---------------------------------------------------------------------------------------------------------------------------------------'

the json out is :

[
	{
		"Father": "Pierre",
		"Child": [
			"Kevin",
			"Jordy",
			"Dylan"
		]
	},
	{
		"Father": "Paul",
		"Child": [
			"Lorie",
			"Alizé"
		]
	},
	{
		"Father": "Jacques",
		"Child": "Lana"
	}
]

Lana is my problem ... i would like it to look like ["Lana"]

here is how i'have set the TWriteJSONFlied:

Re: how to ? : json array as well if single entry

iamabhishek — Thu, 11 Oct 2018 12:08:43 GMT

Under Child add Attribute - say give the name as class and assign a static value of array.

Something like this -

Re: how to ? : json array as well if single entry

iztoogood — Thu, 11 Oct 2018 13:01:29 GMT

Hi,

Thanks for your help... starting with your advice, i've found how to deal with it !!!

it gives exactly what i need :

.-----------------------------------------------------.
|                  children in array                  |
|=---------------------------------------------------=|
|json                                                 |
|=---------------------------------------------------=|
|{"Father":"Pierre","Child":["Kevin","Jordy","Dylan"]}|
|{"Father":"Paul","Child":["Lorie","Alizé"]}          |
|{"Father":"Jacques","Child":["Lana"]}                |
'-----------------------------------------------------'

[
	{
		"Father": "Pierre",
		"Child": [
			"Kevin",
			"Jordy",
			"Dylan"
		]
	},
	{
		"Father": "Paul",
		"Child": [
			"Lorie",
			"Alizé"
		]
	},
	{
		"Father": "Jacques",
		"Child": [
			"Lana"
		]
	}
]

Re: how to ? : json array as well if single entry

iamabhishek — Thu, 11 Oct 2018 13:04:37 GMT

Glad it could help.

Please mark the topic as resolved so that it will help our Talend community members.