topic XML to JSON conversion in Workato Pros Discussion Board

XML to JSON conversion

bhavesh-patel — Wed, 10 Aug 2022 15:11:35 GMT

I am receiving API response in XML and want to convert into JSON. Can anybody guide me how can I achieve the same?

chall — Wed, 10 Aug 2022 15:27:21 GMT

Hi Bhavesh

Apply the formula .to_json against the payload. Check the syntax, but this will convert into JSON for you.

hardik_bamb — Wed, 10 Aug 2022 15:55:14 GMT

Hi Bhavesh,

Please refer below link

https://support.workato.com/en/support/discussions/topics/1000085036

Thanks

salman-khan — Wed, 10 Aug 2022 17:13:36 GMT

Hi Bhavesh

You can use to_json formula,
Please find the below recipe link this will give better understanding
https://app.workato.com/recipes/2765551?st=df8c85242b8428ee5b6f25736d6bb0132c6733e45151816de14b35d072c1f133

iwhitman — Wed, 10 Aug 2022 19:58:38 GMT

Is it possible to get the response in JSON in the first place? Many APIs support multiple formats.

For instance, you could try specifing request header, "Accept: application/json"?

Forgive me if this is obvious, and you've already tried it. I'm new to this community.

bhavesh-patel — Wed, 10 Aug 2022 20:33:26 GMT

That's true but I am using third party APIs and they support json for request but for response they are providing it in xml only.

bhavesh-patel — Wed, 10 Aug 2022 20:38:25 GMT

Your recipe is very useful. Thanks for the help