succ → new_str Returns the successor to str. The successor is calculated by incrementing characters starting from the rightmost alphanumeric (or the rightmost character if there are no alphanu...
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 c...
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 re...
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...
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 Sh...
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"}]
Hi All, Can anyone share the documentation url for the api/activity_logs API as I am not able to find it. Thanks in advance and appreciate your time. @shivakumara Regards, Prudvi
🔧 Workato Tip of the Day: Avoid XML Pitfalls with Reserved Keywords! Did you know? In Workato, using <command> in an XML message template might show a red mark at the bottom. 🚩 This happen...
I have a report that has data up to the end of previous calendar month. I want to email it, with the subject line saying "Report as of November 2024" I can get December 2024 with this: =today...
I've created an object variable with 2 nested string variables that you can see in the image below. When I later use an update variable step and select the "pet" variable is does not give me an optio...
