Redshift
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!
Forum Posts
Resolved! Wildcard string replacement ?
Hi, is there a way to replace characters using a wildcard with a blank ?There are always 6 zeroes, and random 3 digits and a period before the 6 zeroes2023-10-09 17:38:36.243000000 More text here ...
NetSuite create Estimate Recipe shows fields in Custom fields list but not as Input field
In a Create Standard NetSuite Record step, a field is selected in the Custom Fields section. It's one of 19 custom fields identified in the step. It's the only field that does not show up further down the setup details as available for input. Ther...
Resolved! Workato Pub/Sub tool
Hello,I am just starting with Workato in my company. For one project we are thinking of making Asyn calls to our workato recipe from an external system. Would I be able to use workato pub/sub tool available in tools to leverage this? Can workato even...
Resolved! Uploading attachments to servicenow
Hi,I'm trying to build a recipe that triggers on a new/updated JIRA issue and creates a Servicenow ticket, including attachments and comments. The current challenge is getting the recipe to upload to the servicenow incident. I used the recipe at: htt...
Resolved! Lookup Table add entry if doesn't exist
Is there way to add entry to lookup table only if doesn't already exist (based on a specific column value?)Came across a recipe which seems to be inefficient - it's looking a search for the value in lookup table, monitoring for error (entry not foun...
Resolved! Passing variables from a recipe into PowerShell
Hello Everyone,I was wondering if anyone has ever attempted to pass variables from a recipe into a PowerShell script. What I'm trying to accomplish is sending an email address that is gathered as the variable in the recipe to a specific PowerShell sc...
Resolved! Is there a limit to # of records in a BAQ step?
I have a BAQ report in Epcior which will list all the records of a Sales order and in certain conditions will create a SFDC opportunity and set to closed won etc.this works fine but today OM had a longer than usual Sales order with 58 line items on i...
Resolved! is there a function in Workato that can integrate Dynatrace to Looker studio?
Hi Workato Pros, i have a question in mind after seeing the Workato website which (https://www.workato.com/integrations/dynatrace~looker) this website. Is there any possibilities that we can Integrate Dynatrace to Looker Studio with Workato? if Yes, ...
Outlook connection issues to Azure gov cloud
Has anyone been able to get an outlook connection connected to the gov cloud environment? Seems like it connects but then an error comes after finishing the oauth popup. If this won't work with the gov cloud environment, does anyone have a suggestion...
