Looking for duplicate entries in a table
Hi All,Is there a builtin function to look for duplicate entries in a table? I'm sure I had found a Lookup Table to do this but can no longer find it.Thanks in advance for you help
Forum Posts
Resolved! Triggering another recipe
Hi, I have the following workflow:User triggers recipe from workbot in slack by typing "create data"Slack workbot sends link to google sheet for user to fill outOnce that google sheet is filled out, I need another recipe to be triggered, using the da...
Filtering a search to 10 customers using condition formula
I have a recipe where I am pulling invoices from the past 2 years. I want to add a condition where it will only pull records for 10 customers. I have not been very successful in setting up a formula using customer ID's. I have attached a copy of the ...
Feature Request: We need a rating feature in Workato Community Recipe Section
There are tons of junk 2, 3 step recipes in the community that are useless for building anything substantial. I wish there were a way to rate the community recipes or moderate them and remove them if they are worthless.
SQL collection query - issue with timezones
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...
Resolved! SQL Server - New/Updated row based on view
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...
Resolved! Uploading Attachment to Quickbooks
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...
Resolved! Salesforce Certified Administrator
What resources or study material would you recommend for someone preparing for the Salesforce Certified Administrator certification?
INTERNAL SERVER ERROR on retrieving large number of records from a third party API
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...
Resolved! Merging / upserting items in a list
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...
