Get rows from the transform and print to a JSON string

[Evren Yamin]

Hello,

I currently have a transform map that I used to load data in ServiceNow.  I now have a requirement get the rows of the loaded data and convert into a JSON string so I can store that into a field in ServiceNow.

This is the sample data:

number	short description	state	created
INC1089756	sample record	new	4/24/2024

I want to convert this to a JSON string that looks like this one:

{number: "INC1089756", short_description: "sample record", state: "state", created: "4/24/2024"}

And save the JSON string to a new field. Is this possible? 

Appreciate all the help.

[Community Alums]

Hi @Karunakaran 

Thanks for your input😃

Thanks and Regards 

Sarthak