NetSuite REST

Learn how to use the NetSuite REST Connector in DBSync Cloud Workflow

Overview

The NetSuite REST Connector in DBSync Cloud Workflow provides secure and flexible integration between Oracle NetSuite and external systems - including CRM platforms, e-commerce solutions, analytics tools, databases, and SaaS applications - using NetSuite’s REST APIs.

Unlike the traditional NetSuite Web Services (SOAP) interface, the NetSuite REST Connector uses NetSuite’s REST API, offering simplified authentication, streamlined resource access, and efficient data operations for master and transactional records.

This connector supports real-time and scheduled synchronization, enabling organizations to automate business processes while maintaining consistent ERP data across systems.

Key Benefits

For Business Users:

• Modern Integration Experience: Leverages REST APIs for easier development and maintenance.

• Faster Connectivity: Reduced complexity compared to SOAP/Web Services for common data interactions.

• Improved Operational Visibility: Synchronize ERP data for reporting, analytics, and automation.

For Technical Teams:

• Secure Token-Based Authentication: Uses OAuth 2.0 or NetSuite Token-Based Authentication (TBA) for secure access.

• Flexible Object Support: Enables querying and manipulating both standard and custom NetSuite objects.

• Performance-Optimized: Uses REST endpoints for efficient filtering, sorting, and pagination.

Key Features

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

• Supports Read, Write, and 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

Before configuring the NetSuite REST Connector, confirm the following prerequisites are met:

1. DBSync Access

   • An active DBSync Cloud Workflow subscription with access to REST-based connectors.

2. NetSuite Account

   • Admin-level NetSuite account

3. 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.

4. Permissions

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

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, and more.

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, and others.

• Items: Inventory Part, Non-Inventory Part, Discount, and others.

Connector Configuration

Each NetSuite REST connector instance represents a connection to a particular NetSuite environment (sandbox or production). For multiple environments, create separate connector entries.

Authentication Parameters

Field	Description	Required
Account ID	NetSuite account identifier	Yes
Client ID	OAuth 2.0 or integration client identifier	Yes
Client Secret	OAuth 2.0 or integration client secret	Yes
TBA Access Token	Token used for API access (if using TBA)	Yes
TBA Access Token Secret	Secret associated with the access token (if using TBA)	Yes

Because this connector uses REST APIs, the setup uses modern token flows instead of older SOAP sessions, reducing complexity and improving performance.

Quick Setup Guide

1

Login to DBSync Cloud Workflow

Use your DBSync credentials to access the platform.

2

Add the NetSuite REST Connector

From the connectors list, choose “NetSuite REST.”

3

Enter Authentication Credentials

Provide Account ID, Client ID, Client Secret, Access Token, and Token Secret.

4

Test Connection

Click Test Connection to verify credentials and connectivity.

5

Save Configuration

After successful validation, save the connector.

6

Refresh Metadata

Refresh Metadata is used to update the connector schema with the latest structure from NetSuite.

Ensure that you click Refresh Metadata every time the object structure changes in Netsuite.

Once completed, the NetSuite REST connector is available for use in workflows and synchronization tasks.

Note: To enable token-based authentication (TBA) in NetSuite and obtain the values needed for configuring DBSync NetSuite connector, refer to Netsuite Connector Settings.

Operations and Usage

• Read, Write, and Update 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 (say, Sales Order to Invoice), when supported by NetSuite APIs.

Troubleshooting

Common Issues	Resolutions
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

Common Use Cases

• Real-Time Customer Sync

  • Keep customer and contact data aligned between CRM and NetSuite.

• Order Lifecycle Integration

  • Push order information from front-end systems into NetSuite for fulfillment.

• Inventory & Item Synchronization

  • Maintain up-to-date inventory and item master lists across systems.

• Financial Data Exchange

  • Sync invoices, payments, and accounting records for downstream systems.

• Custom Data Workflows

  • Integrate custom record types supporting specialized business processes.

Frequently Asked Questions (FAQ)

Can this connector be used alongside the traditional NetSuite Web Services connector?

Yes, you can use both REST and Web Services connectors in the same environment based on your integration needs.

Are custom records supported?

Yes, the REST connector supports both standard objects and custom REST resources exposed by NetSuite.

Is bi-directional sync possible?

Yes, workflows can be configured for bidirectional or one-way synchronization.

How often can workflows run?

Workflows can be scheduled to run every minute.

Do I need technical skills to configure this?

The connector setup is designed to be straightforward — credentials and roles are entered through a guided UI with validation.

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 permissions are granted in NetSuite.

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.

Summary

The NetSuite REST Connector in DBSync Cloud Workflow provides a modern, performant, and secure way to integrate NetSuite with your broader enterprise ecosystem. By leveraging NetSuite’s REST APIs, this connector enables efficient data synchronization, operational automation, and simplified authentication - helping organizations streamline business processes and maintain data consistency across systems.