NetSuite Connector Configuration

Version 22.0.8336


NetSuite Connector Configuration


The NetSuite connector allows you to integrate NetSuite into your data flow by pushing or pulling data from NetSuite. Follow the steps below to connect CData Arc to NetSuite.

Establish a Connection

To allow Arc to use data from NetSuite, you must first establish a connection to NetSuite. There are two ways to establish this connection:

  • Add a NetSuite connector to your flow. Then, in the settings pane, click Create next to the Connection drop-down list.
  • Open the Arc Settings page, then open the Connections tab. Click Add, select NetSuite, and click Next.

Note:

  • The login process is only required the first time the connection is created.
  • Connections to NetSuite can be re-used across multiple NetSuite connectors.

Enter Connection Settings

After opening a new connection dialogue, follow these steps:

  1. Provide the requested information:

    • Name — The static name of the connection. Set this as desired.
    • Type — This is always set to NetSuite.
    • Auth Scheme — The authentication scheme to use when connecting to NetSuite. Options are Basic and Token.
    • AccountId — The NetSuite Account Id.
    • User / Password — (Basic Auth Scheme Only) The user and password to use to log in to NetSuite.
    • OAuthClientId / OAuthClientSecret — (Token Auth Scheme Only) The OAuth Client ID and Client Secret for logging in.
    • AccessToken / AccessTokenSecret — (Token Auth Scheme Only) The Access Token and Secret for logging in.
  2. If needed, click Advanced to open the drop-down menu of advanced connection settings. These should not be needed in most cases.

  3. Click Test Connection to ensure that Arc can connect to NetSuite with the provided information. If an error occurs, check all fields and try again.

  4. Click Add Connection to finalize the connection.

  5. In the Connection drop-down list of the connector configuration pane, select the newly-created connection.

  6. Click Save Changes.

Select an Action

After establishing a connection to NetSuite, you must choose the action that the NetSuite connector will perform. The table below outlines each action and where it belongs in an Arc flow.

Action Description Position in Flow
Upsert Inserts or updates NetSuite data. By default, if a record already exists in NetSuite, an update is performed on the existing data in NetSuite using the values provided from the input. End
Lookup Retrieves a value from NetSuite and inserts that value into an already-existing Arc message in the flow.
The Lookup Query determines what value the connector will retrieve from NetSuite. It should be formatted as a SQL query against the NetSuite tables.
Middle
Select Retrieves data from NetSuite and brings it into Arc.
You can use the Filter panel to add filters to the Select. These filters function similarly to WHERE clauses in SQL.
Beginning
Execute Stored Procedures Treats data coming into the connector as input for a stored procedure, and then passes the result down the flow.
You can click the Show Sample Data button to provide sample inputs to the selected Stored Procedure and preview the results.
Middle