# NetSuite REST

## 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&#x20;

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

{% stepper %}
{% step %}

### Login to DBSync Cloud Workflow

Use your DBSync credentials to access the platform.
{% endstep %}

{% step %}

### Add the NetSuite REST Connector

From the connectors list, choose “NetSuite REST.”
{% endstep %}

{% step %}

### Enter Authentication Credentials

Provide Account ID, Client ID, Client Secret, Access Token, and Token Secret.
{% endstep %}

{% step %}

### Test Connection

Click **Test Connection** to verify credentials and connectivity.
{% endstep %}

{% step %}

### Save Configuration

After successful validation, save the connector.
{% endstep %}

{% step %}

### Refresh Metadata

Refresh Metadata is used to update the connector schema with the latest structure from NetSuite.
{% endstep %}
{% endstepper %}

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

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FFryYiuS4igdqksMfeAnK%2Funknown.png?alt=media&#x26;token=3c101384-ac38-4c6a-8716-d705815ff942" alt=""><figcaption></figcaption></figure>

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**&#x20;
  * Push order information from front-end systems into NetSuite for fulfillment.
* **Inventory & Item Synchronization**&#x20;
  * Maintain up-to-date inventory and item master lists across systems.
* **Financial Data Exchange**&#x20;
  * Sync invoices, payments, and accounting records for downstream systems.
* **Custom Data Workflows**&#x20;
  * Integrate custom record types supporting specialized business processes.

## Frequently Asked Questions (FAQ)

<details>

<summary>Can this connector be used alongside the traditional NetSuite Web Services connector?</summary>

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

</details>

<details>

<summary>Are custom records supported?</summary>

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

</details>

<details>

<summary>Is bi-directional sync possible?</summary>

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

</details>

<details>

<summary>How often can workflows run?</summary>

Workflows can be scheduled to run every minute.

</details>

<details>

<summary>Do I need technical skills to configure this?</summary>

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

</details>

<details>

<summary>Is real-time sync possible?</summary>

Yes, the connector supports scheduled workflows depending on your triggers and mapping configuration.

</details>

<details>

<summary>Can custom NetSuite records be synced?</summary>

Yes, if they are enabled and permissions are granted in NetSuite.

</details>

<details>

<summary>Is there a limit to how many records I can process?</summary>

Subject to NetSuite API’s service limits and your subscription, design integrations for batch efficiency, where needed.

</details>

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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.mydbsync.com/cloud-workflow/2026_connectors_new/netsuite-rest.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
