Skip to main content

NetSuite

Integrating NetSuite with Osano​

Connecting to NetSuite​

In order for Osano to discover data stored in your systems, we must connect to those data providers via an API. We require, at minimum, read-only access to establish a connection to these providers. Each provider you connect may require different information. Please see the linked vendor documentation for instructions on where and how to obtain this data.

Required Fields​

  • Consumer Key
  • Consumer Secret
  • Token ID
  • Token Secret

Required Scopes​

Lists​

PermissionLevel
ContactsFULL
CustomersFULL
EmployeesFULL
Employee RecordFULL

Reporting​

PermissionLevel
SuiteAnalytics WorkbookEDIT

Setup​

PermissionLevel
Company InformationFULL
User Access TokensFULL
Log in using Access TokensFULL
REST WEB ServicesFULL

NetSuite Setup​

1. Enable Features​

  1. Go to Setup -> Company -> Enable Features
  2. Enable REST WEB Services
  3. Enable Token Based Auth
  4. Enable SuiteAnalytics Workbook

2. Registering the App​

  1. Go to Setup -> Integrations -> New
  2. Select Token Based Authentication
  3. Click save and note down the Consumer Key and Consumer Secret

3. Creating a new Role​

  1. Go to Setup -> User/Roles -> Manage Roles -> New

  2. Select ALL for accessible subsidiaries and check the WEB SERVICES ONLY ROLE option

    Add permissions for the following:

    Lists​

    PermissionLevel
    ContactsFULL
    CustomersFULL
    EmployeesFULL
    Employee RecordFULL

    Reporting​

    PermissionLevel
    SuiteAnalytics WorkbookEDIT

    Setup​

    PermissionLevel
    Company InformationFULL
    User Access TokensFULL
    Log in using Access TokensFULL
    REST WEB ServicesFULL

  3. Add the role to the user you will being using for the integration and save

4. Creating the Access Token​

  1. Go to Setup -> Users/Roles -> Access Tokens -> New
  2. Select the app, the user you will be using for the integration, and the new role
  3. Create the token and note down the Token ID and Token Secret.

5. Copying Account Id​

  1. Click Setup -> Company -> Company Information -> Copy the Account ID

Core Functionality​

  • Data Discovery
  • User Search
  • Data Deletion

Base URL​

https://{accountIdForUrl}.suitetalk.api.netsuite.com/services/rest/record/v1/

Auth​

  • oauth
  • apiKey

API KEY HEADER authentication

  • email
  • name
  • phoneNumber
  • address
  • birthday
  • userId