topic Restructuration of my JSON template in Talend Studio

Restructuration of my JSON template

Anonymous — Thu, 09 Nov 2017 17:03:42 GMT

Hi everybody,

I show you my problem :

- I would like to have this json template filled in with values :

and right now, I have this :

In fact, I would like to make a transformation of my JSON template.

My job is :

My tFileInputJSON_3 is :

My row11 is :

My tWriteJSONField_2 is :

My row12 is :

My tFileOutputJSON_1 is :

Actually all the content is in this label "summary" :

"summary": "{\"fields\":{\"project\":{\"key\":\"TRL\"},\"Summary\":[\"Product\",\"Pouvoir générer des par défaut. \\n\"],\"description\":[\"bak\",\"boom\"],\"issuetype\":{\"name\":[\"Task\"]},\"reporter\":{\"name\":[[\"562\"],[\"562dd\"]]},\"assignee\":{\"name\":[]},\"labels\":[\"Module\",\"Correos\"]}}",

I would like to dispatch the contents across these labels :

But these are at null. Why ? Could you give me some clues to resolve It ?

Thanks,

Alex

Re: Restructuration of my JSON template

Anonymous — Wed, 15 Nov 2017 08:39:43 GMT

Hello,

What does your input json file look like?

Best regards

Sabrina

Re: Restructuration of my JSON template

Anonymous — Tue, 21 Nov 2017 09:48:31 GMT

Hi Talend community,

Finally, I succeeded to resolve my problem :

My input json looks like :

with these settings :

In my tWriteJSONField_3, I have this structure :

my tJavaRow is to transform some data (labels in JSON array) and so forth ...

In conclusion I have in my tFileOutputDelimited_2 :

The file produced is :

It's better if the JSON string pass the JSONLint ...

Here It is !

Now I have an other question but I think to develop it in a other topic

Alex

Re: Restructuration of my JSON template

Anonymous — Thu, 23 Nov 2017 06:29:18 GMT

Hello,

Thanks for your feedback and sharing your solution with us. Feel free to create a new topic on forum for your another question.

Best regards

Sabrina

Re: Restructuration of my JSON template

Anonymous — Thu, 23 Nov 2017 09:37:04 GMT

Hi Sabrina,

It is already done ! ( https://community.talend.com/t5/Design-and-Development/Interrogation-about-tWriteJSONField-component/m-p/43296#M12924)

Alex