Hello Workato Pros! We’re on a mission to make our community forum the best place for you to connect, share, and grow. Your experience matters and we want to hear from you! Take our quick Community Experience Survey below (embedded right in this post...
I have an API that returns me certain items with corresponding dates.They come in this format : 2024-06-12T13:00:00.000+02:00When I turn them into a SQL collection, all is well.However I get an issue when I query the SQL collection, as it suddenly re...
Hi,I have a view in SQL that shows a schedule (production order) with its startdate and update date (the update date does not always mean that the production order has started, just that something has been updated).What I want to do is find a schedul...
Hi,I'm looking to use the Workato connector for Quickbooks to upload an image to later attach.I'm following these notes but have not been able to solve it Attach images and notes (intuit.com).I'm using a custom action with the Quickbooks connector.He...
What resources or study material would you recommend for someone preparing for the Salesforce Certified Administrator certification?
Hello team,I've been working on a project with a very large database. I need to fetch all records using an API endpoint within a custom connector SDK. This third-party API has some limitations: it only returns 1000 results per request and uses an off...
I have an API which i call on a schedule, and it returns me all status updates since the last poll.Due to API limits etc... I do this on a 15 minute interval.However, if the item gets updated more than once within this interval, I get the same item r...
I created a recipe to update pricing from Epicor/Kinetic to SFDC which seems to be working fine in pilot.BUT when I use a DMT file to upload the new pricing into Epicor/Kinetic doesn't seem to trigger my recipe as I would assume it should.does anyone...
Hi guys,I have a use case where I use regular expression to validate the input of postal code.E.g. Formula = "95000-2707".match?(/(^\d{5}$)|(^\d{5}-\d{4}$)/) for matching the US postal codes.However, this method won't work if the regular expression i...
I am setting up a recipe that takes a new/updated Zendesk ticket (in real time) and then creates the issue in Jira. I'm running into an issue with the 'Description' output for the 'New/updated ticket in Zendesk' action. The description comes back for...
Hi all,I have a custom connector with 3 selectors used to build up output fields/pills.The first one (control_type: select) selects a query, the other two (control_type: multiselect) allows selection of fields of the curently selected query and build...
