NetSuite is a cloud-based suite of business management applications. It offers a comprehensive set of tools for enterprise resource planning (ERP), financial management, customer relationship management (CRM), and e-commerce, providing a unified platform for businesses to streamline their operations and manage various aspects of their organization.
Authorize Connection to NetSuite
Authorize the connection so Dataddo can write to NetSuite:
| Field | Description |
|---|---|
| A name for this authorizer in Dataddo | A label so you can recognize the connection later. |
| Account ID | Account ID |
| Client ID | Client ID |
| Client Secret | Client Secret |
| Private Key | Private Key |
| Certificate ID | Certificate ID |
Dataddo validates the connection when you save it.
Create a NetSuite Destination
Go to Destinations, click Create Destination, and select NetSuite. Give the destination a name, choose the authorizer, then set:
| Field | Description |
|---|---|
| Endpoint | Select the Netsuite endpoint you would like to load data to. Shown when oAuthId is ``. |
Click Save.
Fields that load from your account (such as the target object or module) appear after you choose the authorizer.
Write Modes
The write mode decides how each flow run changes your NetSuite records. NetSuite supports the modes below.
| Mode | Meaning |
|---|---|
insert |
Creates a new record for every row. |
Flow columns are matched to NetSuite fields by name. If a column has no matching field, it is ignored.
How to Create a Flow to NetSuite
- Go to Flows and click Create Flow.
- Add one or more sources.
- Add NetSuite as the destination and pick the authorizer.
- Select the target object and the write mode.
- Set the schedule and click Save.
Troubleshooting
Cannot connect to NetSuite
Reauthorize the NetSuite connection and make sure the account has permission to write the target object.
Rows are rejected
NetSuite rejected rows that break its field rules (required fields, value formats, or duplicate keys). Fix the source data or the field mapping and restart the flow.