Dear all,im trying to create a JSON file from a mySQL Database Table. the table looks like this:ID|Street|City|Type|FirstName|LastName1|Somewherestreet|Somewherecity|Familyhead|Chris|Somebody1|Somewherestreet|Somewherecity|FamilyMember|Anna|Somebody1...
Hi,How do I change the date format from 02-Oct-23 to 02-10-2023.Is there a way to achieve this by workato formula?
I've looked through lists by workato, variables by workato, files by workato and can't find a great way to take all the CSVs created in a repeat step/loop (CSV Parser by workato) and add each of them to an email (as attachments). Any advice?
This is the first time Ive tried to use the Open AI connector and I have a paid account for the API key. I have never accessed the API any other way.When I talked with our partner representative they had the same problem
Hi, has anyone tried to or know if its possible to pull task usage across tenants as a whole? I can use RecipeOps and get some limited information but really want to be able to summarize some of this data by day/week/month and deliver to a slack ch...
Hey Pros! This Thursday, join our product team for Product Hour to learn how to secure your data, connectivity, and users while minimizing vulnerabilities. Explore how Workato’s pre-built security features and other capabilities empower you to take c...
I am looking at some suggestions from the community on any ideas you might have in regards to the following:We want to add some of the financial data from Sage 300 into our datawarehouse using Workato,We are planning on moving our Sage 300 software t...
Hey Folks,I'd need a little support for a recepie: The recepie should delete all contacts in a google adressbook (will be purge once a week).What I've achieved so far:- I can get a list of all google contacts with a custom goole Action- I can add eac...
Hi, I'm trying to send an HTTP request to an API endpoint using the Workato HTTP app "Send request via HTTP". The endpoint is expecting a field name of "First Name" (with a space) but it appears when creating the field name Workato does not allow spa...
Hi,I am trying to use an AND operator with IF ELSE in the Formula mode in Workato.Trying to do something like:IF condition1=TRUE AND Condition2=TrueValueCan someone please assist on this.Thanks
