โ04-22-2021 06:10 PM
Hey All - in Workato's NetSuite connector, the execute saved search action doesn't have a drop down for "Custom Records". Custom Record types also don't show up rendering workato unable to execute saved searches for custom records. Has anyone found a way around this?
โ04-22-2021 07:01 PM
Hi, I'm pretty sure (95%) I have done this before, by entering the Saved Search ID first, but I am still looking through my recipes to find an example. If this is for a trigger action, perhaps you could set it to trigger based on a new/updated custom record with filter values, instead of using the saved search. I'll post an update here when I find an example of this from my system...
โ04-22-2021 07:48 PM
I wasn't able to do saved search calls on custom records so ended up using NetSuite jdbc connection to pull the query I needed.
โ04-23-2021 04:30 AM
I'm attempting to search for data with criteria that is too complex to plug into the "Search Custom Records" function. I settled for a less-than-ideal solution, which is run 3 separate "search custom records" actions, then consolidated into a list. JDBC is a good idea, I run this search every 30 minutes though. I'm not sure how JDBC works, is there any delay between the NetSuite production data and the JDBC data store @amy?