topic Re: JSON File creation using Context from Parent Job in Talend Studio

JSON File creation using Context from Parent Job

gtaware — Fri, 06 Mar 2020 10:15:11 GMT

Hi Team ,

I want to create a json file as which is shown in image Sample jSON

Can you please guide me how to achieve this ?

manodwhb — Fri, 06 Mar 2020 10:21:13 GMT

@gtaware, paas the context to child job that child job should be tFixedFlowInput>>tWriteJsonFields>>tFileOutputRow.

gtaware — Fri, 06 Mar 2020 10:50:00 GMT

Thanks Let me try that.

gtaware — Wed, 11 Mar 2020 03:42:17 GMT

Can you please create a sample Job and Post a reply here .

manodwhb — Wed, 11 Mar 2020 03:49:39 GMT

@gtaware , please share the job what you have tried?

gtaware — Wed, 11 Mar 2020 04:29:09 GMT

manodwhb — Wed, 11 Mar 2020 04:32:41 GMT

@gtaware ,OK ,the job is completed successfully right validate the json data that have you got correct as you expected?

gtaware — Wed, 11 Mar 2020 05:52:02 GMT

I have posted the Job which has been created but that is not a complete Json which I am expecting .

how to add other details which I have shown in very first image .

gtaware — Thu, 12 Mar 2020 05:09:19 GMT

Hi Team,

Can you please help me how to add sub element which contains array in tWriteJsonField component

Below is array which I want to add in my existing json file which I am creating using tWriteJsonField

"additonalDetails": {
"nvPair": [
{
"name": "fileId",
"value": "10306"
},
{
"name": "fileName",
"value": "ACCULYNK.WUDPGBP.20200129.txt"
}
]
}