NetSuite V2 (REST)

NetSuite is a unified cloud business management solution, including ERP/financials, CRM, and ecommerce.

This connector uses REST API to work with NetSuite. It provides support for NetSuite fields, storing array data, but does not support backup. See NetSuite (SOAP) for an alternative connector.

Data integration: Skyvia supports importing data to and from NetSuite, exporting NetSuite data to CSV files, replicating NetSuite data to relational databases, and synchronizing NetSuite data with other cloud apps and relational databases.

Backup: Skyvia Backup does not support NetSuite backup. You can use our NetSuite (SOAP) connector.

Query: Skyvia Query supports NetSuite.

Establishing Connection

Skyvia supports two kinds of authentication in this connector: OAuth 2.0 and Token-based authentication.

Getting Credentials

To obtain credentials for connecting Skyvia to NetSuite, you need to sign in to NetSuite and perform the following actions:

Obtain Account ID

You can get the account id value in NetSuite SOAP Web Services Preferences. Point to Setup, then to Integrations, and then click SOAP Web Services Preferences. On the opened page, copy your Account ID under Primary Information.

SOAP Web Services Preferences

Obtaining Time Zone

You can get the account id value in your NetSuite preferences. Point to the home icon in the top left corner of the page and click Set Preferences. Under Localization, find your Time Zone.

NetSuite Preferences

Enable Authentication in NetSuite

Perform the following actions:

  1. Point to Setup, then to Company, then click Enable Features.

    Setup -> Company -> Enable Features

  2. Then click Suite Cloud.

    NetSuite Enable Features

  3. If you want to use token-based authentication, in the Manage Authentication group, select the Token-based Authentication checkbox.

  4. If you want to use OAuth 2.0 authentication, in the Manage Authentication group, select the Token-based Authentication checkbox.

    Manage Authentication settings

Create Role

Create a role with the necessary privileges for token-based authentication and access to the necessary objects and assign it to the user that will be used for authentication. You need to assign at least the “Web Services” and “User Access Tokens” privileges.

Create Integration Record

To create an integration record, perform the following:

  1. Point to Setup, then to Integrations, then Manage Integrations, and then click New.

    NetSuite Integrations Menu

  2. In the opened page, enter Name for the application, for example, Skyvia.

    NetSuite integration record

  3. If you plan to use token-based authentication, make sure that under Token-based Authentication:
    • The Token Based Authentication checkbox is selected.
    • The TBA: Authorization Flow checkbox is not selected.
  4. If you plan to use OAuth 2.0 authentication, perform the following:
    1. Under OAuth 2.0, select the Authorization Code Grant checkbox.
    2. In the Redirect URI box, enter https://app.skyvia.com/oauthcallback/netsuite
    3. Select the REST Web Services checkbox.
    4. Make sure that the Public Client check box is not selected.

    NetSuite integration record configured

  5. Click Save.
  6. From the confirmation screen, copy the generated Consumer Key / Client ID, and Consumer Secret / Client Secret. Note that they are displayed only once on this page. If you need them again, you will have to re-generate them, which make the old ones to stop working. You may reuse these values if you need multiple Skyvia connections to this NetSuite account.

    NetSuite integration record credentials

Create Access Token.

This is needed only for token-based authentication. Perform the following actions to create an access token and obtain TokenID and Token Secret:

  1. Point to Setup, then to Users/Roles, then Access Tokens, and then click New.

    Access Tokens menu

  2. Select the Integration record, User, and Role created on the previous steps.

    Access Token editor

  3. Click Save.
  4. From the confirmation screen, copy the generated Token ID and Token Secret. Note that Token ID and Token Secret are displayed only once on this page. If you need them again, you will have to re-generate them, which make the old ones to stop working.

    Access Token saved

Creating Connection

When creating a NetSuite connection, you need to specify different connection parameters depending on the authentication kind you select.

Token-based Authentication

To create a NetSuite connection using token-based authentication, perform the following steps:

  1. Enter the obtained NetSuite Account ID.
  2. Specify your Account Time Zone.
  3. In the Authentication list, select Token-Based.

    NetSuite connection editor - token-based authentication

  4. Paste the copied Consumer Key / Client ID to the Consumer Key box.
  5. Paste the copied Consumer Secret / Client Secret to the Consumer Secret box.
  6. Paste Token ID and Token Secret that you obtain when creating an access token to the Token and Token Secret boxes respectively.

OAuth 2.0 Authentication

To create a NetSuite connection using OAuth 2.0 authentication, perform the following steps:

  1. Enter the obtained NetSuite Account ID.
  2. Specify your Account Time Zone.
  3. In the Authentication list, select OAuth 2.0.

    NetSuite connection editor - OAuth 2.0 authentication

  4. Paste the copied Consumer Key / Client ID to the Client ID box.
  5. Paste the copied Consumer Secret / Client Secret to the Client Secret box.

    NetSuite connection editor - OAuth 2.0 authentication

  6. Click Sign In with NetSuite.
  7. Enter your NetSuite credentials and click Log In

    Signing in to NetSuite

  8. Click Continue to allow Skyvia access to NetSuite.

    Allowing access to NetSuite

Additional Connection Parameters

You can specify the period of time, after which Metadata cache is considered expired. Note that reading metadata for NetSuite takes especially long time, about 5 minutes or so, so connecting the first time may take a while. If you disable metadata caching or set the Metadata cache parameter to a low value, Skyvia can experience slowdowns when querying NetSuite metadata.

Connector Specifics

Nested Array Fields

Many NetSuite objects have fields, storing array data. Such fields fully support Nested object mapping in Import. You can see our tutorials on QuickBooks and Salesforce, demonstrating how to use nested object mapping:

When selecting data from these fields, they return their contents as JSON arrays.

Not Supported Objects

Skyvia does not support the following NetSuite objects: billingaccount, priceplan, subscriptionchangeorder, subscription, subscriptionline, usage.

Supported Actions

Skyvia supports all the common actions for NetSuite.