# NetSuite

NetSuite (opens new window) is a cloud business management suite that offers comprehensive software solutions for organizations, including support for ERP/Financials, CRM, and e-commerce.

# API version

The NetSuite connector uses the WSDL from the SuiteTalk 2024_1 API (opens new window). This gives you the latest access to objects introduced in past API versions and all records seen under *Schema Browser tab in the API reference documentation. A variety of new fields for objects have also been introduced.

# Connect to NetSuite on Workato

You can connect to NetSuite through token-based authentication. You must first generate an application ID, a consumer key, a consumer secret, a token ID, and a token secret.

We recommend that you reference our video channel for instructions on "How to connect to NetSuite":

See Connect to NetSuite on Workato for detailed steps on how to connect to Netsuite through token-based authentication.

# Common NetSuite fields

The NetSuite connector can retrieve your standard or custom NetSuite objects and the associated set of standard and custom fields. When you configure your trigger or action, you must first select the specific object for interaction.

See Common NetSuite fields for details.

# Triggers

Workato has the following triggers for NetSuite:

DEPRECATION OF TRIGGER CONDITIONS IN BATCH TRIGGERS

Trigger conditions are deprecated and will be removed from NetSuite SOAP batch triggers on October 23, 2025.

This change improves accuracy and consistency when filtering records. Trigger conditions only evaluate the first record in each batch. This means that even if the first record matches the condition, the batch may still include records that don't, which leads to inconsistent batch sizes. In contrast, the Search settings field filters records in NetSuite before Workato retrieves them. This ensures that each batch contains only records that meet the criteria.

This update removes trigger conditions from the following NetSuite SOAP batch triggers:

To avoid any disruptions, we recommend updating your recipes to use the Search settings field before October 23, 2025. This approach improves performance and gives you more control over data retrieval.

Complete the following steps to update your batch trigger:

1

Open the trigger configuration in your NetSuite SOAP recipe.

2

Ensure the Set trigger condition toggle is disabled.

Disable the Set trigger condition toggleDisable the Set trigger condition toggle

3

Expand the Search settings section.

4

Choose an operator for each field type to define how values should be matched.

Configure Search settings by selecting operators for each field typeConfigure Search settings by selecting operators for each field type

5

Add the fields you plan to filter from the optional fields list, set their values, and save the trigger configuration.

6

Test your recipe to confirm that batches include only matching records.

If you have questions or need help updating your recipes, reach out to your Customer Success Manager.

# Example: Filtering sales orders by status

This example shows how results can differ depending on which method you use to filter sales orders by status.

Trigger conditions check only the first record in the batch. The platform processes the entire batch if that record matches, even when other records don't.

Trigger condition for batch triggerTrigger condition evaluates only the first record

As a result, the batch may include records with different statuses:

Trigger condition job resultBatch includes records that don't meet the condition

Search settings apply the filter within NetSuite before the batch is retrieved, so only matching records are included:

Search settings job resultBatch includes only records that match the condition

# Actions

Workato has the following actions for Netsuite:

# Unsupported records

There are certain records that triggers and search actions do not support, as they cannot be queried via the NetSuite API.

Users can use the Get all standard records action to retrieve these objects not found in search actions or triggers:

  • Budget category
  • Campaign audience
  • Campaign category
  • Campaign channel
  • Campaign family
  • Campaign offer
  • Campaign search engine
  • Campaign subscription
  • Campaign vertical
  • Currency
  • Lead source
  • State
  • Support case issue
  • Support case origin
  • Support case priority
  • Support case status
  • Support case type
  • Tax account

The following records are not supported:

  • Campaign response
  • Item revision
  • Landed cost
  • Sales tax item
  • Tax group
  • Tax type
  • Currency revaluation
  • Payroll adjustment
  • Inventory worksheet


Last updated: 7/11/2025, 8:32:40 AM