What are some of the best practices for NetSuite integration around Saved Searches?
First, let's look at an easy way to find the Saved Search internal ID (numeric) ID.
Just look for the ID which is at the end of the NetSuite Saved Search URL in your browser when you run it to see a Saved Search you are dealing with today.
Be sure the Saved Search is set to "Public" in NetSuite so it can be seen by the API.
Based on the screenshot above, when you select "Specific NetSuite Saved Searches" under Records to Sync, then when you specify the ID, TYPE, the record(s) under the Saved Search ID will be synced to that new/existing specified Marketing Automation List Name.
Selecting a Saved Search to test out or to use in your integration will allow your integration to review all your NetSuite records with valid email addresses and then narrow down to just the Saved Search(es) which will allow better segmentation in your target software.
Using NetSuite criterion to narrow down NetSuite records in a Saved Search for use in your integration:
When building your Saved Search for use in an integration note that sometimes what runs in NetSuite will not work with their API. The last modified date criteria addition does not work for "Use Expressions" with OR logic. It will produce an incorrect Saved Search result.
Using Saved Searches in your SyncApps integration can automate records flow to Mailchimp, Constnat Contact, ActiveCampaign, Klaviyo, and more to efficiently bring across the records you need to effectively market to on a regular basis.
Let's get a bit into the weeds here so your NetSuite Saved Search will follow best practices for integration.
Please put one more outermost parentheses in this use case below:
(Inactive = false AND .. AND ..) OR Name/ID = ... OR Name/ID = ...
(( Inactive = false AND .. AND .. ) OR Name/ID = ... OR Name/ID = ...)
If Saved Search criteria "Use Expressions" is checked then criteria MUST be wrapped with parenthesis "(" and ")"
SyncApps will need to add one more last modified criteria.
If wrapper parenthesis is not added then the NetSuite Saved Search could produce an incorrect result especially if criteria contain OR logic.
Name = "A" OR Name = "B" must be changed to (Name = "A" OR Name = "B")
- Netsuite Summary Saved Searches are not supported in SyncApps because they are not supported in NetSuite's API.
- Formula fields cannot be retrieved using NetSuite's Saved Search API.
Need some help?
Check out the options below on how you can contact our support team and find the answers you need to help you with your SyncApps integrations.
Help Center & Email is 24/7 to email@example.com | Live Chat & Phone is scheduled
Check out these Help Desk articles for answers to frequently asked questions.
Check out our subscriber's story here on how SyncApps helped them save hundreds of hours per year!