NetSuite connection

Introduction

A NetSuite connection is configured using the NetSuite connector, establishing access to the NetSuite endpoint. Once a connection is established, you can configure one or more NetSuite activities associated with that connection to be used either as a source to provide data to an operation or as a target to consume data in an operation. In addition, the NetSuite connection can be used in scripts.

Create or edit a NetSuite connection

A new NetSuite connection is created using the NetSuite connector from one of these locations:

• The design component palette's Project endpoints and connectors tab (see Design component palette).
• The Global Connections page (see Create a global endpoint in Global Connections).

An existing NetSuite connection can be edited from these locations:

• The design component palette's Project endpoints and connectors tab (see Design component palette).
• The project pane's Components tab (see Component actions menu in Project pane Components tab).
• The Global Connections page (see Edit a global endpoint in Global Connections).

Configure a NetSuite connection

Configuration of a NetSuite connection includes these fields:

• Endpoint Name: Enter a name to use to identify the NetSuite connection. The name must be unique for each NetSuite connection and must not contain forward slashes (/) or colons (:). This name is also used to identify the NetSuite endpoint, which refers to both a specific connection and its activities.

• Account: Enter the NetSuite account ID associated with the NetSuite account you want to use. Accounts associated with a NetSuite sandbox environment may be indicated with a suffix such as SB1, SB2, etc.

• WSDL Download URL: Enter the account-specific URL of the NetSuite WSDL used by the NetSuite instance. Jitterbit supports the WSDL versions listed in NetSuite prerequisites. Instructions for obtaining the account-specific WSDL URL are provided in Use a NetSuite account-specific WSDL URL.

• Consumer Key and Consumer Secret: Enter the NetSuite Consumer Key and Consumer Secret values. If you used the integration record bundle provided by Jitterbit (see NetSuite prerequisites), use the following values:

  • Consumer Key: 768b136f26ea98b957e7dd2e87bad89077ca2ec484a0cb72c5a8e1b003627213
  • Consumer Secret: 0dbf3d5e3c2d2ff72ef1a8e8d564d5786da2f60006ad97a00246d7ce924c8b51

  If you created the integration record another way, follow the steps outlined in Gather values for using NetSuite TBA to obtain values to use.

• Token Key and Token Secret: Enter the NetSuite Token ID and Token Secret values obtained from NetSuite. For instructions on obtaining these values, see Gather values for using NetSuite TBA.

  Caution

  If you are using a NetSuite sandbox account, each time the sandbox is refreshed, you need to create new tokens.

• Signature Algorithm: Use the dropdown to select the signature algorithm to be used to sign the request, one of HMAC-SHA1 or HMAC-SHA256. The signature algorithm determines how the payload is encrypted.

  Note

  NetSuite has deprecated HMAC-SHA1 as a valid signature method in favor of HMAC-SHA256 as of these versions:

  • Non-Production Accounts: NetSuite version 2021.2 and later.
  • Production Accounts: NetSuite version 2023.1 and later.

  The deprecation of HMAC-SHA1 is independent of which WSDL version you specify in the configuration of the NetSuite connection.

• Call Time Out: Enter the call timeout value in seconds if you want to the timeout value to be less than the default agent setting.

  Note

  The default agent setting for timeout of NetSuite calls is 300 seconds. For private agents, this default can be changed in the [Connectorsinfo] section of the private agent configuration file.

• Retry on Recoverable Exception: This setting is functional only when using an environment associated with a private agent group whose agents are version 10.24 or later. Its behavior depends on the private agent version. When selected, this setting is used to retry a rejected request to NetSuite when either of these criteria is met:

  • Private agents 10.24 and later: NetSuite's governance limit for concurrent requests is reached and the error WS_REQUEST_BLOCKED is returned.
  • Private agents 10.36 and later: NetSuite does not return a response in the expected timeframe and a timeout exception occurs.

  To check your NetSuite account's concurrency limits, in the NetSuite UI, go to Setup > Integration > Integration Governance. For more information, see NetSuite's documentation on Concurrency Governance Limits Based on Service Tiers and SuiteCloud Plus Licenses.

  In order for this setting to take effect, the Jitterbit variable jitterbit.netsuite.async must not be set to true upstream of the operation.

  With private agents version 10.23 or earlier, on cloud agents, or if the Jitterbit asynchronous variable is enabled, this setting will be ignored.

  Select the Retry on Recoverable Exception checkbox to expand additional configuration options:

  

  • Retry Interval (Seconds): Enter the number of seconds (maximum of 5 seconds) to wait between resending a rejected request to NetSuite.

  • Max Retries: Enter the number of times (maximum of 5 retries) that a rejected request will be resent to NetSuite. If the request is still rejected after the maximum number of retries, an exception with an error message will be returned in the operation log. In addition, the private agent will log each retry in the jitterbit-agent.log log file.

    Each retry is treated as part of the same operation run, where only a single record appears in the operation log. Any operation actions configured to run downstream operations are triggered based on the end status of the operation after retrying up to the maximum number of retries.

• Test: Click to verify the connection using the provided credentials.

  Caution

  If you receive an error regarding the data center while testing the connection, you may need to use a different WSDL URL. For more information, see NetSuite data center error.

• Save Changes: Click to save and close the connection configuration.

• Discard Changes: After making changes to a new or existing configuration, click to close the configuration without saving. A message asks you to confirm that you want to discard changes.

• Delete: After opening an existing connection configuration, click to permanently delete the connection from the project and close the configuration (see Component dependencies, deletion, and removal). A message asks you to confirm that you want to delete the connection.

Next steps

After a NetSuite connection has been created, menu actions for that connection are accessible from the project pane's Components tab. See Connection actions menu for details.

After configuring a NetSuite connection, you can configure one or more NetSuite activities associated with that connection to be used either as a source to provide data to an operation or as a target to consume data in an operation, or you can use the NetSuite connection within a script.

Configure activities

NetSuite activities interact with the NetSuite connection to act as sources (providing data within an operation) or targets (receiving data within an operation).

After configuring a NetSuite connection, use the Show dropdown to filter on Endpoints, and then click the NetSuite connection block to display activities that are available to be used with a NetSuite connection:

For more information, see these activities:

• Search: Retrieves existing records from a NetSuite endpoint and is intended to be used as a source in an operation.
• Create: Creates new records in a NetSuite endpoint and is intended to be used as a target in an operation.
• Update: Updates existing records in a NetSuite endpoint and is intended to be used as a target in an operation.
• Get List: Retrieves a list of existing records based on ID from a NetSuite endpoint and is intended to be used as a target in an operation.
• Upsert: Both updates existing records and creates new records in a NetSuite endpoint and is intended to be used as a target in an operation.
• Delete: Deletes records in a NetSuite endpoint and is intended to be used as a target in an operation.

Using NetSuite connections in scripts

NetSuite connections can be referenced in a script using script functions that use a netSuiteOrg as a parameter. For more information, see Using NetSuite functions.