Workato | Systematic Community

Workday Recipe for Creating Customer Invoice

I am trying to create a recipe to create Customer invoices from data that will reside in Square. We are going to pull the data from Square and then create the customer invoices in Workday. Has anyone done a recipe from Square (or other similar syst...

Extract part of string?

Hi all,New to Workato.I have a requirement to extract the first 500 characters of a string, I tried to do this with a formula but for some reason it's not working:String.scan(/.{0,500})The regex seems to be correct, but the end result is empty - not ...

Resolved! Retake Exam

I hope this message finds you well. I recently attempted the Automation Pro II Exam but was unable to pass. I have been studying the material and practicing improving my understanding. I would greatly appreciate it if you could provide me with anoth...

Resolved! Automation Pro 11

Dear Workato teamI hope this message finds you well. I recently attempted the Automation Pro II Exam but was unable to pass. I have been studying the material and practicing improving my understanding. I would greatly appreciate it if you could provi...

Changing Date Format in Recipe for Google Drive Folders

Hi everyone,I have a Workato recipe that connects Salesforce with Google Drive.In the recipe, I’m creating Google Drive folders where the folder names are based on Contact names and their Date of Birth.This setup works perfectly.However, I want to ch...

Resolved! Changing Date Format in Recipe for Google Drive Folders

need help to reset automation Pro II Exam attempts

I need to reset my Automation Pro II exam, can someone help here? thanks.email jackz@canva.com

Workday / Workato Recipies

Dear Automation Pro Community,I very much want to discuss Workday data access/update to/from Workato. It appears that invoking processes within Workay - such as "Hire Employee" is easy enough, but providing the associated parameters looks to be rath...

compare collection with lookup table

: Dynamic SQL Query with Keywords from Lookup Table in WorkatoCurrent SQL Query:SELECT * FROM ( SELECT *, TRIM( COALESCE( CASE WHEN LOWER(TRIM(formula_1)) LIKE '%payments%' THEN 'Payments' ELSE '' END || CASE WHEN LOWER(TRIM(formula_1)) LIKE '%servic...

Automation Pro II Exam faild

Dear Workato teamI hope this message finds you well. I recently attempted the Automation Pro II Exam but was unable to pass. I have been studying the material and practicing to improve my understanding. I would greatly appreciate it if you could pro...