cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Redshift

redshelf_dev
Deputy Chef I
Deputy Chef I

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!

2 REPLIES 2

juliana-recio
Workato employee
Workato employee

Hi, @redshelf_dev!

Good day!

You can create a JSON structured data using Mapper. mapper.jpg

The schema can be defined in Tools โ†’ Common Data Model.cdm.jpg

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

blakesha
Deputy Chef II
Deputy Chef II

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.