Systematic Community

I am creating a Recipe Function in Workato.In one of the steps I need to pass a JSON value into a field that expects a STRING.The JSON should come from a function parameter.The issue is that I don’t know in advance what the keys of the JSON will be.I...

Hi everyone,I need to generate a random 6-digit code (OTP style) in a recipe.Is there a way to do this using a Workato formula?If not, what is the recommended/best practice way to implement it?Thanks in advance!

 Hi,I have a result from a SQL query that comes as an array of objects, like this:[ { NAME: "BON", NUMBER: 21 }, { NAME: "JON", NUMBER: 51 }]I want to convert this into a CSV file so I can send it as an email attachment. What’s the best way to do thi...

Hi,I’m working on a new project in Workato and want to create a Connection to salesforce.Currently, the Connect button appears but is greyed out / not clickable .How can I check if I have Workspace Admin permissions, or if this is restricted for anot...

I have a CSV table that contains both parent and child records.I need to identify if a row is a child based on a specific value in the Name field.The parent is also identified by a specific value in the Name field.For each child record, I need to:Fin...