Collecting data from NetSuite

This guide explains how to collect data from NetSuite. To learn how to collect data from a different data source, go back to the Available data sources in Adverity overview.

Prerequisites

Before you start collecting data from NetSuite, perform all of the following actions:

Creating a datastream to collect data from NetSuite

The basics of creating a datastream to collect data from any data source are explained in our guide to Creating a datastream. This guide contains information about the specific steps to create a datastream to fetch data from NetSuite.

Authorization: Allow Adverity to access NetSuite

Before creating an authorization to give Adverity access to NetSuite, perform the following actions:

  1. Retrieve the following values to create an authorization to NetSuite:

    • Account ID: the account ID is shown in the beginning of the NetSuite URL. For example, if your NetSuite URL is https://123456.app.netsuite.com, your account ID is 123456.

    • Client ID: the client ID is generated after the integration record is created.

    • Client secret: the client secret is generated after the integration record is created.
      For more information on how to create an integration record, see the NetSuite documentation. When creating an integration record, set the redirect URI to https://oap.datatap.io/oauth2/callback/.

  2. To use the token-based authentication, configure it for your Netsuite account and create an access token. For more information, see the Oracle documentation.

Configuration: Choose the data you want to collect from NetSuite

To choose what data to collect and customize the NetSuite datastream configuration, follow these steps:

  1. (Optional) Rename your datastream.

  1. In Extraction method, select how to fetch data.

  2. For the Record type extraction method, in Record type, select the type of records you want to collect.

  3. For the SuiteQL extraction type, in Query, enter the query to collect data in the following JSON format. For more information, see the NetSuite documentation.

    {
	"q": "{SuiteQL Query}"
}

What's next?