Workato | Systematic Community

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...

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...

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...

Changing Date Format in Recipe for Google Drive Folders

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...

Need Trial account for Workato

I am writing to request access to a trial account for Workato. I am eager to explore the platform's features and evaluate its suitability for our needs. Kindly let me know if there are any specific steps or information required from my end to expedit...

Resolved! How to skip null objects in a list

I'm getting null objects in my filtered list. how can I remove the null objects w/o using Pythion script?Example:[{"name" : "Nitish","Id": "010"},{},{"name" : "Nitesh","Id": "020"}]

Gmail Connection not working

Trying to do gmail connection but its not working This app is blockedThis app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access. Since now less secure app settings is disabled then how to se...

Resolved! Compare two Json arrays to find the new and updated records

Hello Team,I am new to Workato, i am trying to build a data integration to sync data from Workday to SharePoint List.I have employee data coming from Workday, which is also stored in a SharePoint list. My requirement is to set up a daily integration...