topic Re: Redshift in Workato Pros Discussion Board

Redshift

redshelf_dev — Thu, 08 Aug 2024 00:13:41 GMT

Hi,

I am new to Workato and maybe this is very simple but I am trying to convert the results of a redshift sql query into json and I just can't see a way to do it. Any thoughts are appreciated.

Thank you!

Re: Redshift

juliana-recio — Thu, 22 Aug 2024 04:24:43 GMT

Hi, @redshelf_dev!

Good day!

You can create a JSON structured data using Mapper.

The schema can be defined in Tools → Common Data Model.

Please check this helpful documentation :
https://docs.workato.com/connectors/mapper.html#how-to-connect-to-the-mapper-connector-on-workato

Re: Redshift

blakesha — Mon, 02 Sep 2024 03:42:40 GMT

When you say "convert to json" I am assuming you mean calling another service?

If this is correct then as you will need to create a request schema for the endpoint you are calling you can "map" the columns from the result of the SQL query to the fields of the service request. There is no direct need to convert the redshift query results to a json message. Workato will do all that for you if you map the query results to the input fields of the service request.