Connecting to NetSuite

While reading from and writing to a NetSuite connection, both interactive and batch modes are supported. Spectrum Technology Platform supports these NetSuite entity types:

Standard records
Custom records
Saved searches
Joins between Standard records

To connect to NetSuite:

Access the Connections page using one of these:

Spectrum Management Console:

Access Spectrum Management Console using the URL: http://server:port/management console, where server is the server name or IP address of your Spectrum Technology Platform server and port is the HTTP port used by Spectrum Technology Platform.
Note: By default, the HTTP port is 8080.

Click Resources > Connections.

Spectrum Discovery:

Access Spectrum Discovery using the URL: http://server:port/discovery, where server is the server name or IP address of your Spectrum Technology Platform server and port is the HTTP port used by Spectrum Technology Platform.
Note: By default, the HTTP port is 8080.

Click Connect.
Click the Add connection button .
In the Connection Name box, enter a name for the connection. The name can be anything you choose.

Note: Once you save a connection you cannot change the name.
In the Connection Type field, choose NetSuite.
In the Email field, enter the email addressed linked to the NetSuite account to be used for the connection.
In the Password field, enter the password of the NetSuite account.
In the Account field, enter the user name for the NetSuite account.
In the Role field, select the appropriate role for this connection from the roles mapped to the particular NetSuite user account.

The Role field is optional. If you leave the Role field blank, the default role is used to log in through the connection.

Attention: Only standard roles are supported. Custom roles are not supported.
To test the connection, click Test.
Click Save.

Note: To INSERT a record using a NetSuite connection, use an UPSERT query with the primary key (internalId) blank.