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.

  • NetSuite can collect a maximum of 1 million rows per single report. To fetch more data than this, split your fetch into smaller date ranges in the Initial Fetch step of creating a datastream.

Prerequisites

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

  • 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/.

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.

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?