how to create a json object from database columns

Anonymous — Sat, 16 Nov 2024 04:43:33 GMT

json format:

{
"attributeValue":[
{
"specName":"CUSTOMER_ID",
"specValue":"112345"
},
{
"specName":"CUSTOMER_TYPE",
"specValue":"12"
},
{
"specName":"CUSTOMER_FEATURES",
"specValue":"REPORT_GENERATION",
"specValueId":"YES"
},
]
}

specName is static value(CUSTOMER_ID,CUSTOMER_TYPE,CUSTOMER_FEATURES),

specValue,specValueId is database output column from Tmap.

how to get the above json format as output.Thanks.

Re: how to create a json object from database columns

manodwhb — Tue, 10 Sep 2019 07:26:38 GMT

@techrajesh2 ,have you checked the below link may help you.

https://help.talend.com/reader/mjoDghHoMPI0yuyZ83a13Q/BM0DTJv0n1kEjjQLAp2rkQ

topic Re: how to create a json object from database columns in Talend Studio

how to create a json object from database columns

Re: how to create a json object from database columns