> For the complete documentation index, see [llms.txt](https://docs.coupler.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coupler.io/sources/category/sales/netsuite.md).

# NetSuite

NetSuite (Oracle NetSuite) is a cloud ERP that unifies accounting, order management, inventory, and CRM in one system. Connecting NetSuite to Coupler.io lets you export standard and custom records, or run your own SuiteQL queries, into spreadsheets, BI tools, or databases on a schedule — without building a custom integration.

## Why connect NetSuite to Coupler.io?

* **Automate sales and financial reporting** — Schedule regular exports of sales orders, invoices, vendor bills, and other records instead of running manual saved searches.
* **Query exactly what you need** — Use the SuiteQL data type to pull custom joins, filters, or aggregations that a single record type can't provide.
* **Build custom dashboards** — Export NetSuite data to Looker Studio, Power BI, or Google Sheets for reporting NetSuite doesn't offer natively.
* **Combine with other sources** — Merge NetSuite data with e-commerce, marketing, or support data for a complete view of the business.
* **Flexible destinations** — Export to AI tools, Google Sheets, Excel, BigQuery, Looker Studio, Power BI, or other supported destinations.

## Prerequisites

Before connecting, make sure you have:

* **Administrator access** to your NetSuite account, needed to enable features and create the integration and token records below
* **Token-Based Authentication** and **REST Web Services** enabled (Setup → Company → Enable Features → SuiteCloud tab)
* An **Integration record** with Token-Based Authentication enabled (Setup → Integration → Manage Integrations → New) — this gives you a **Consumer Key** and **Consumer Secret**
* An **Access Token** created for the role you want Coupler.io to use (Setup → Users/Roles → Access Tokens → New) — this gives you a **Token Key** and **Token Secret**
* Your **NetSuite Account ID** (Realm) — found under Setup → Company → Company Information, or in your NetSuite URL

{% hint style="warning" %}
NetSuite only shows the Consumer Secret and Token Secret once, at the moment you create them. Copy all five values (Realm, Consumer Key, Consumer Secret, Token Key, Token Secret) before leaving the page — if you lose them, you'll need to create a new access token.
{% endhint %}

## Quick start

{% hint style="success" %}
Start with the **Objects** data type and the **Invoice** entity, leaving **Start date** and **Window in days** at their defaults. Run it once to confirm the connection and see the fields available, then switch to **SuiteQL** if you need a custom join or filter.
{% endhint %}

## How to connect

NetSuite uses token-based authentication (TBA) — you enter credentials generated in NetSuite rather than signing in through a redirect.

{% hint style="info" %}
See [How to Connect](/sources/category/sales/netsuite/how-to-connect.md) for the full walkthrough of generating your Realm, Consumer Key/Secret, and Token Key/Secret in NetSuite, including the required role and feature setup.
{% endhint %}

{% stepper %}
{% step %}
In NetSuite, enable **Token-Based Authentication** and **REST Web Services** (Setup → Company → Enable Features → SuiteCloud), then create an **Integration record** (Setup → Integration → Manage Integrations → New) with Token-Based Authentication turned on. Note the **Consumer Key** and **Consumer Secret** NetSuite generates.
{% endstep %}

{% step %}
Create an **Access Token** for the role you want Coupler.io to use (Setup → Users/Roles → Access Tokens → New). Note the **Token Key** and **Token Secret**.
{% endstep %}

{% step %}
In Coupler.io, create a new data flow and select **NetSuite** as a source.\
Enter your **Realm** (Account ID), **Consumer Key**, **Consumer Secret**, **Token Key**, and **Token Secret**, then click **Connect**. For a sandbox account, append the sandbox suffix to the Realm, e.g. `1234567_SB1`.
{% endstep %}

{% step %}
Choose a **Data type**: **Objects** to select a standard or custom NetSuite record type, or **SuiteQL** to write a custom query.
{% endstep %}

{% step %}
**For Objects:** select an **Object** (e.g., Invoice, Vendor Bill, Customer) and adjust **Start date** or **Window in days** if needed.
{% endstep %}

{% step %}
**For SuiteQL:** enter your query in the **SuiteQL** field.
{% endstep %}

{% step %}
Choose your destination and run the data flow.
{% endstep %}
{% endstepper %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.coupler.io/sources/category/sales/netsuite.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.