Automation Pro 2 Exam
Hello guys, is there anyway for me to reattempt the Automation Pro 2 Exam? Unfortuantely I failed both of the attempt :(. Is there any way to try again?
Forum Posts
Resolved! is Ruby function succ is available to use on workato and how?
succ → new_strReturns the successor to str. The successor is calculated by incrementing characters starting from the rightmost alphanumeric (or the rightmost character if there are no alphanumerics) in the string. Incrementing a digit always results ...
Resolved! WHERE Clause in SQL connector has errors and I have no idea why
Hi All,I'm trying to return records from a SQL database where the dates in the "lastcastingdate" column of the DB is more than 14 days ago. I have entered the following into the WHERE clause in the Select Row action:=LASTCASTINGDATE < today - 14.da...
Include Header block for Slack Workbot message?
Hi all,This may be a simple 'yes/no' but just posting here in case I'm missing something - I am using the Slack Workbot to send messages and manually 'build' the block kit.It looks like the 'Header' block is not available?Header on Slack is larger th...
Resolved! 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 ...
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...
Workato Copilot
Hi Workato Team,Is there any future releases/plan to include AI copilot trail feature to the users using Base plan.I would like to explore the tool to help in managing the recipes efficiently.Regards,Prudvi
Resolved! 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...
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...
