Skip to content

NetSuite SuiteAnalytics Authentication Guide

This document details how to configure an OAuth to use with NetSuite SuiteAnalytics. This requires the creation of an OAuth in your Matillion ETL instance and the generation of specific credentials using your NetSuite account.

Before you begin

  1. Familiarize yourself with the NetSuite Query authentication guide and follow that guide as far as Step 8, so that you have enabled the SuiteCloud features. You do not need to create a NetSuite OAuth in your Matillion ETL instance. Record the Redirect URI from your Matillion ETL instance, as you will require it later.
  2. Log in to the NetSuite customer portal. Navigate to SuiteAnalytics via Setup → Company → Enable Features and select the Analytics tab. Enable the SUITEANALYTICS WORKBOOK option by ticking the checkbox next to it.

Create an app integration in NetSuite

  1. Create an App Integration. Follow the Oracle documentation here: Create Integration Records for Applications to Use OAuth 2.0.
  2. Enable the OAuth 2.0 feature in your integration app and add the redirect URL from your Matillion ETL instance.
  3. Copy the Client ID and Client Secret at the end of this process. You won't have another opportunity to copy the secret.
  4. Create a user role and add the required OAuth access to that role, following the process here: Getting Started with OAuth 2.0.
  5. Add the following permissions to your user: Log in Using OAuth 2.0 Access Tokens and OAuth 2.0 Authorized Applications Management.

Create API OAuth entry in Matillion ETL

Create a new API OAuth entry in your Matillion ETL instance, following the steps in Manage OAuth. Enter the following parameters:

  • Grant Type: Leave the field as Authorisation Code.
  • Auth URL: https://<account_id>.app.netsuite.com/app/login/oauth2/authorize.nl, where <account_id> is the 7-digit ID in your NetSuite URL, for example https://1234567.app.netsuite.com.
  • Token URL: https://<account_id>.suitetalk.api.netsuite.com/services/rest/auth/oauth2/v1/token, where <account_id> is the 7-digit ID in your NetSuite URL, for example https://1234567.app.netsuite.com.
  • Client ID: Generated when you created the app integration, as above.
  • Client Secret: Generated when you created the app integration, as above.
  • Client Auth: Leave the field as Basic Authentication in Header.
  • Additional Parameters:
    • scope: rest_webservices suite_analytics.
    • state: Any 9-digit string of numbers. This field can't be left blank.