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:

  1. Access the Data Sources page using one of these modules:
    Management Console:
    Access Management Console using the URL: http://server:port/managementconsole, 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.
    Go to Resources > Data Sources.
    Metadata Insights:
    Access Metadata Insights using the URL: http://server:port/metadata-insights, 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.
    Go to Data Sources.
  2. Click the Add button .
  3. In the Name field, enter a name for the connection. The name can be anything you choose.
    Note: Once you save a connection you cannot change the name.
  4. In the Type field, choose NetSuite.
  5. In the Email field, enter the e-mail linked to the NetSuite account to be used for the connection.
  6. In the Password field, enter the password of the NetSuite account.
  7. In the Account field, enter the user name for the NetSuite account.
  8. 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.
  9. To test the connection, click Test.
  10. Click Save.
    Note: To INSERT a record using a NetSuite connection, use an UPSERT query with the primary key (internalId) blank.