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:
-
Retrieve the following values to create an NetSuite:
to-
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:
-
(Optional) Rename your datastream.
-
In Extraction method, select how to fetch data.
-
For the Record type extraction method, in Record type, select the type of records you want to collect.
-
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?
-
Apply Data Mapping to your collected data to harmonize data collected from different sources in Adverity.
-
Transform your data to meet your needs by creating and applying enrichments to your datastream.
-
Load your data into Explore & Present to visualize your data in Adverity
-
Load your data into an external destination of your choice