topic Re: Data transformation using Javascript Connector in Workato Pros Discussion Board

Data transformation using Javascript Connector

jani-swinnen — Tue, 23 Aug 2022 17:37:19 GMT

Hi all,

I'm currently trying to do some data transformation using the Javascript connector but I can't figure out how to corrrectly configure the output. I'm trying to format a JSON body for a HTTP request to the Slack chat.scduleMessage endpoint.

In my recipe I set a variable to a JSON string, which I need to input into the Javascript connector, I then use JSON.parse to parse this string, but when I return the JSON.stringify on the next line, it ends up as a null value... My output schema is just a string named payload and in the next step the payload datapill is an empty string.

The JSON.parse does not give me an error so I have to assume the string gets parsed, but somehow, somewhere it ends up as null.

Does anyone have any experience in this situation?

Re: Data transformation using Javascript Connector

gary1 — Wed, 08 Feb 2023 13:53:34 GMT

I just ran a quick test and was able to get JSON.parse and JSON.stringify to work without issue. It might be how your script is returning the output. I found that part a bit tricky when first working with the JS connector.

I attached some images of my setup and script so you can see how it works and hopefully replicate it.

Re: Data transformation using Javascript Connector

jani-swinnen — Wed, 24 Aug 2022 17:44:30 GMT

Thank you Gary,

I managed to figure it out with the help of your screenshots.

The problem was that I changed the syntax when trying to fix a previous bug, and in doing so I removed the curly braces surrounding the input and return values. I think that's the main reason for my function to return a null value.

Re: Data transformation using Javascript Connector

Saichand — Wed, 08 Feb 2023 05:46:35 GMT

Hello Gary,

I am Jagadeesh. I am working on the same Usecase that Jani was explaining. I wanted to refer to your setup and Script but I couldn't find the attached images. Could you please share them once again?

Thanks in Advance.

Re: Data transformation using Javascript Connector

meghan-legaspi — Wed, 08 Feb 2023 13:55:22 GMT

Hi @Saichand,

I have updated Gary's replies with the original screenshots of his solution. I have also attached them to this reply (see below).

Thank you,
Meghan

Re: Data transformation using Javascript Connector

Patel0786 — Thu, 17 Oct 2024 05:42:22 GMT

i also create a recipe for data transformation using JS snippet by workato, in this recipe i have a group of JSON object and i'm doing data transformation like converting firstName, lastName etc to - (based on requirement) using JS code.

Recipe:- https://app.workato.com/recipes/54842488?st=22358e2f16126f8b0aa51e349ae0de7633781b47a307c56fdd951d59b420d568