Resolved! get unique rows in lookup table column
say I have a lookup table with repeated entries in a particular columne.g. property1property1property2property3 how would I query the lookup table to return a list containing the 3 unique entries?
Forum Posts
Resolved! Size Limit for Message Templates
Is there a known size limit for Message Templates? I have not been able to find any reference to such in the documentation.
April Events Roundup from Workato 🗓️
Hey, Pros! Happy Friday and welcome back to our fan-favorite Event Roundup! Here's what we have lined up (so far) for April: Free & virtual: Embed for Success Lunch & Learn | May 2ndEmbed Office Hour w/GUIDEcx | May 7thProduct Hour (Topic TBA) | May ...
Resolved! Zoominfo Output fields are missing when mapping in NetSuite
Hi,I have an issue where I have first selected few fields to be mapped to custom field in Netsuite for the Zoominfo.The output fields are there How I can then get the field when field is missing?ThanksAli
Resolved! Connector SDK - Access webhook notification in Hybrid Trigger Poll
Hi,Is it possible to get the payload of a notification that triggered the poll lambda in a hybrid trigger?Example:# poll lambda on my hybrid trigger poll: lambda do |connection, input, closure, _eis, _eos, payload| # get data from notification to...
Resolved! Workato connector SDK method issue
Im seeing a strange issue when using methods in Workato connector SDK, if i call one method after another in the action execute Workato does not wait for the method to complete / respond before calling the next line, as can be seen in the image below...
Resolved! Bulk delete of NetSuite Custom Table
Hello all,I'd like to try and pick your brains for a solution to my question. I'll start with the business requirement:I need to pull out of NetSuite Spend by Supplier for the last 12 months including transaction count, payment count, etcI've writte...
Resolved! setting up recipe for looping through items with individual api authorizations
Workato newbie here, I'm wondering how to migrate an existing coded workflow to workato. I loop through a data structure of buildings each with their own api key, and each building has 1 or more tills, each with their own api key for a different clou...
Resolved! SFTP action - Search Term regular expression
I am using Search files or folders actions in SFTP server action. In the search term , i have used this expression : \w+_\d+.CSVI would like to check , for example : FileName_20241212.CSV ; After the filename_[IS THERE A NUMBER?].CSV For some reason,...
Creating Attachment in Quickbooks Bill
Hi Team,I am working on inserting attachments to a particular Quickbooks Bill through Workato. As I see it, there is no suitable action available in Workato for inserting attachments. So I chosen QB custom action. In the API request, I need to give...
