Convert json array to json string

[heshkaru]

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

[Anonymous]

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

[Anonymous]

@Heshan Karunaratne​ 

What are your expected output Json string?

Regards

Shong