Json Fomat Corrections in Talend

since_1995 — Sat, 16 Nov 2024 02:47:36 GMT

the input is given through Excel and my Json generated is as below:

{"documents":{"documents":[],"blanket_document":["f0033dc0-126b-40ba-89e0-d3061bdeda4c","1948335f-7dcd-410c-8f90-fc74c9fe5236","Individual_AI_Blanket_Endorsement.pdf"],"policy_document":["f0033dc0-126b-40ba-89e0-d3061bdeda4c","1948335f-7dcd-410c-8f90-fc74c9fe5236",[]],"pl_document":["f0033dc0-126b-40ba-89e0-d3061bdeda4c","1948335f-7dcd-410c-8f90-fc74c9fe5236",[]]}} here i don't want to generated the array if there is no pdf document. Is that possible??

Actually I want it as below

{"documents":{"blanket_document":"f0033dc0-126b-40ba-89e0-d3061bdeda4c/1948335f-7dcd-410c-8f90-fc74c9fe5236/Individual_AI_Blanket_Endorsement.pdf"}}

Re: Json Fomat Corrections in Talend

marceloveras — Sat, 18 Apr 2020 21:51:16 GMT

Could u send a sample of your job?

Seems like you need :

tExtractJSONFields -> tJSONWriteFields (Rewriting your JSON object remapping it)

Best Regards

Marcelo Veras

Re: Json Fomat Corrections in Talend

since_1995 — Sat, 25 Apr 2020 05:19:15 GMT

jsarray1.PNG

topic Re: Json Fomat Corrections in Talend in Talend Studio

Json Fomat Corrections in Talend

Re: Json Fomat Corrections in Talend

Re: Json Fomat Corrections in Talend