Resolved! Convert list of string to list of numbers
Is there a formula that can be used to convert list of String variables to a list of integers ? I/P is ["1","100","50", "4"] O/P [1,100,50,4]
Forum Posts
Workflow Apps read only field rendering value based on the user dropdown selection
Hi, I'm trying to find a solution wherein in my workflow app based on the drop down selection value in the request form there needs to be 3 to 4 fields that has to be filled in the request form. The drop down selection value is fetched from data tabl...
Oracle REF Cursor
Hi,After the July update, it was announced that there is now support REF Cursor output parameter in storage procedure.When I tried to test this I get the error : "OPA error: Error : 6550, Position : 6, Sql = BEGIN apps.NIKO_TEST_REF.get_invoices("INV...
Status update failure after task submission
I am fetching the data from the datatable and assigning tasks to users through the workflow app. Once the user submits the task, the status should change from In Progress to Done. However, in my case, the status is not updating to Done and is still s...
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...
Zip file unable to send to Target SFTP
Hi,I encountered an issue while sending a .zip file to the target SFTP. To explain the scenario in brief, I was storing the .zip file in Workato file storage, and from there, attempting to send it to the target SFTP. However, when sending directly, ...
Empty fields not returned in API endpoint response — inconsistent endpoint response schema behavior
Hi Community,I am running into a situation where the HTTP response from a Recipe HTTP Endpoint does not consistently include all the fields defined in the “Return data to caller” step. If a field is not populated at runtime, it is omitted entirely fr...
New vs. Updated record from Salesforce
We need to automate system provisioning based on record creation and update in Salesforce. Of course I'm using the Salesforce connector with new or updated record as the trigger, but here's my issue: When I work with Flows in Salesforce, I can access...
Resolved! Break the For Each based on the condition
Problem: Break the loop based on the if condition satisfied and continue to the next steps. is this can be achieved in workato.
Message Template
Hi All,Do we have an option to clone an existing Message temple using input fields.If not it would be useful to be able to add a column option so that we can modify the template and add/remove required fields without adding again the complete templat...
