Redshift

[redshelf_dev]

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!

[juliana-recio]

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

[blakesha]

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.