topic Re: Convert json array to json string in Talend Studio

Convert json array to json string

heshkaru — Wed, 09 Mar 2022 07:10:29 GMT

Hi I want to convert a JSON array to JSON string inside a tmap component.

[{"line_no":1,"is_revised":false,"type":"OLL","rate":null,"amount":1.0,"original_amount":null,"from_vendor":"889912","to_vendor":"889912","voucher_flag":"N","vouch_user_id":null,"voucher_month":null,"voucher_sequence":null,"voucher_type":null}]

Using StringHandling.DQUOTE() function convert to String, is there any JSON stringify functions?

Thank you

Re: Convert json array to json string

Anonymous — Wed, 09 Mar 2022 10:26:54 GMT

Hello,

Do you need to perform some transformations on the columns using tMap?

If it is a json file, you can use tFileInputJson to extract data from the file and tWriteJsonField to set loop element and group by column for your json string.

Best regards

Sabrina

Re: Convert json array to json string

Anonymous — Thu, 10 Mar 2022 09:07:43 GMT

@Heshan Karunaratne

What are your expected output Json string?

Regards

Shong