NetSuite REST

Overview

The DBSync NetSuite REST Connector empowers organizations to integrate NetSuite with a variety of cloud and on-premise systems using modern REST web services. The connector is designed for real-time, secure, and scalable data automation, allowing users to synchronize, transfer, and manage business-critical information such as transactions, customers, items, and custom records across disparate applications. All integrations are achieved via RESTful methods, adhering to industry best practices for performance and security.

Key Features

• Enables integration with CRMs, e-commerce platforms, analytics tools, finance systems, and more.​

• Supports CRUD ( Read, Write, Update) for both standard and custom NetSuite records.​

• Utilizes secure OAuth2.​​

• Processes real-time and scheduled data workflows to automate business tasks and reporting.​

• Highly configurable and developer-friendly for robust customizations and extensibility.​

• No specific NetSuite version dependency.

Prerequisites

• DBSync Account: An active DBSync license and valid access to the DBSync cloud platform.​

• NetSuite Account: Admin-level NetSuite account.

• Permissions: The integration user must be assigned a custom role with all permissions listed in the table below.

• Token-Based Authentication (TBA): TBA must be enabled in NetSuite. Obtain the Account ID, Client ID, Client Secret, TBA Access Token, and TBA Access Token Secret from NetSuite's integration and access token management screens.​ Required NetSuite Permissions

  Assign the following permissions to the NetSuite user role intended for DBSync REST integration.

  Permission Name	Tab/Subtab	Level	Description
  Web Services	Setup	Full	Enables SuiteTalk API & REST access
  REST Web Services	Setup	Full	Enables REST API features
  Access Token Management	Setup	Full	Needed for TBA configuration
  User Access Tokens	Setup	Full	Manage user-specific tokens
  Custom Record Types	Lists/Transactions	Full	Required for custom record access
  (Transaction) Record Types*	Transactions	Full	Enable access to all objects like Bill, Invoice, Sales Order, etc.

Note:

• Expand transaction, item, and Entity permissions to include all record types your integration will access.

Supported NetSuite Records

The connector supports all standard and custom record types for which the integration user has been granted permissions. Examples include:

• Transactions: Bill, Invoice, Credit Memo, Customer Deposit, Payment, Purchase Order, Sales Order, Work Order, etc.

• Items: Inventory Part, Non-Inventory Part, Discount, etc. Connector Configuration Parameters

  Field Name	Description
  Account ID	NetSuite account identifier (from NetSuite admin page)
  Client ID	OAuth2 Client ID generated for API integration
  Client Secret	OAuth2 Client Secret from NetSuite integration screen
  TBA Access Token	Token-Based Authentication access token
  TBA Access Token Secret	Access token secret for TBA

Setup Instructions

1. Create a NetSuite Integration Record

   • In NetSuite, navigate to Setup > Integrations > Manage Integrations > New.

   • Enable Token-Based Authentication.

   • Note the Consumer Key and Secret (Client ID/Secret).

2. Assign Required Role and Permissions

   • Create a custom role.

   • Add all permissions listed previously — especially for Web Services, REST Web Services, and all record types used in sync.

   • Assign this role to the integration user.

3. Enable Token-Based Authentication (TBA)

   • In NetSuite, enable TBA globally: Setup > Company > Enable Features > SuiteCloud.

   • Under Manage Users, assign the role to your integration user.

4. Generate Tokens for the User

   • In NetSuite: Setup > Users/Roles > Access Tokens > New.

   • Select the integration record and user/role. Save and copy the token ID and secret.

5. Enter Credentials in DBSync

   • Log in to DBSync Cloud Workflow.

   • Access the NetSuite REST connector setup page.

   • Enter: Account ID, Client ID, Client Secret, TBA Access Token, and TBA Access Token Secret as shown in the UI.

   • Click “Validate Connection” to confirm successful authentication.

   • Click “Refresh Metadata” to fetch available object definitions and templates.

6. Save the Connection

   • Click “Save Connection” to finish the setup.

Operations and Usage

• CRUD Support: Perform write, read, and update operations on every permitted NetSuite record. Supports single-record and batch operations.​

• Record Transformation: Transform records from one type to another (e.g., Sales Order to Invoice), when supported by NetSuite APIs.​

Common Issues & Resolutions:

Issue	Resolution
Invalid Credentials/Error 401	Verify token and keys, ensure TBA settings match NetSuite
Permission Denied/Error 403	Check role and permissions – add missing types or upgrade role
Metadata Refresh Fails	Ensure REST Web Services is enabled and user has access
Object Not Found/Field Missing	Confirm record/object type is supported and enabled in NetSuite

FAQ

• Is real-time sync possible? Yes, the connector supports scheduled workflows depending on your triggers and mapping configuration.​

• Can custom NetSuite records be synced? Yes, if they are enabled and mapped in both NetSuite and DBSync, and permissions are granted.

• Is there a limit to how many records I can process? Subject to NetSuite API’s service limits and your subscription, design integrations for batch efficiency, where needed.

Useful Links

• Salesforce and NetSuite Rest Order to Cash