Skip to Content

NetSuite

NetSuite connections give you access to your company’s finance, operations, and customer relations data.

Source Setup

Etleap uses Token-based Authentication (TBA) Tasks for Administrators to authenticate your NetSuite account. Please perform the following steps within your Netsuite account to enable API access.

Step 1. Enable TBA

  1. Select SetupCompanyEnable Features.

  2. Click the SuiteCloud sub-tab.

  3. In the SuiteScript section, check the following boxes:

    1. Client SuiteScript. Click I Agree on the SuiteCloud Terms of Service page.

    2. Server SuiteScript. Click I Agree on the SuiteCloud Terms of Service page.

  4. In the Manage Authentication section, check the Token-based Authentication Box. Click I Agree on the SuiteCloud Terms of Service Page.

  5. Click Save.

Step 2. Create a Role

  1. Select Setup → Users/Roles → Manage Roles → New to create a new role for Etleap.

  2. Enter a name for the role in the Name field.

  3. Select Permissions → Setup near the bottom of the page and expand the drop-down menu to Set system-wide permissions.

  4. Select each of the following permissions from the drop-down menu and click Add:

    1. Custom Body Fields

    2. Custom Column Fields

    3. Custom Entity Fields

    4. Custom Event Fields

    5. Custom Item Fields

    6. Custom Record Types

    7. Deleted Records

    8. SOAP Web Services

  5. Select each of the following permissions from the drop-down to enable the user to generate and log in with API tokens:

    1. Access Token Management (optional) - This Allows you to create and revoke access tokens for some users with a TBA-enabled role; Cannot generate access tokens for an administrator; Cannot generate access tokens for their own use; Cannot use access tokens to log in to the API.
    2. User Access Tokens - This allows users to generate access tokens only for themselves.
    3. Log in using Access Tokens - This allows users to use access tokens to log in to the API.
  6. Set the desired permissions for each table under the Transactions, Lists, Setup, or Custom Record subcategories.

  7. Click Save once you have set the required permissions.

Step 3. Set additional table permissions (optional)

Some tables, such as Accounts, require multiple permissions for the role to see all the content in the table. Using Accounts as an example, conduct the following steps to set additional permissions for these types of tables:

  1. Select SetupUsers/RolesManage Roles. Under Manage Roles, click Edit beside the applicable role name.
  2. Set Your additional permission(s) from the Lists drop-down menu of the Permissions tab.
  3. Click Add to add the permission.

You can verify whether you added the proper permissions by logging in as a user with the new role and validating if you see all the data that you are expecting.

Step 4. Connect the Role to a User

  1. Select Setup → Users/Roles → Manage Users.
  2. Select the relevant user.
  3. Click Edit.
  4. Scroll down to the Access tab.
  5. Make sure the Give Access box is checked. If it is unchecked, you will need to specify a password for the user.
  6. Expand the Role drop-down list on the Roles tab and select the role you created above.
  7. Click Add and Save.

Step 5. Create the Netsuite Integration to Verify API Access for Etleap

  1. Select Setup → Integration → Manager Integrations → Integration → New.
  2. Set the CONCURRENCY LIMIT. This limit is the Max number of pipelines allowed to run concurrently by the integration. A connection conflict will cause your Etleap pipelines to fail.
  3. In the Manage Authentication sub-tab, check the Token-Based Authentication box.
  4. Click Save.
  5. Copy the CONSUMER KEY and CONSUMER SECRET. For security reasons, the integration credentials will only be displayed once.

Step 6. Create your Access Token

  1. Log in using the new role with your User Access Token permission.
  2. In the Settings portlet, click the Manage Access Tokens link.
  3. Click New My Access Token.
  4. On the Access Token page:
    1. Select the Application Name or Integration Record Name.
    2. The Token Name is already populated with a concatenation of application name, user, and role. Enter your own name for this token if desired.
  5. Click Save.
  6. Copy the TOKEN ID and TOKEN SECRET values. For security reasons, the integration credentials will only be displayed once.

Step 7. Obtain your Account ID

  1. Select Setup → Integration → SOAP Web Services Preferences.
  2. Copy the ACCOUNT ID in the top-left of the page.

You will need to access the ACCOUNT ID, CONSUMER KEY, CONSUMER SECRET, TOKEN ID, and TOKEN SECRET values when creating a connection in Etleap.

Note

Prefer using an API? Go here  and select NetSuite under the Body header to create your connection via API.

What Data is Available?

Warning

Update-Mode Deletes Support

Deletes  are not supported for update-mode entities with this connector.

You can create NetSuite pipelines with the following entities:

EntityPipeline Mode
Account Replace
Accounting Period Replace
Adv Inter Company Journal Entry Update
Assembly Build Update
Assembly Item Update
Assembly Unbuild Update
Billing Account Replace
Billing Schedule Replace
Bin Replace
Bin Transfer Update
Bin Worksheet Update
Bom Replace
Bom Revision Replace
Budget Replace
Budget Category Replace
Calendar Event Update
Campaign Replace
Campaign Audience Replace
Campaign Category Replace
Campaign Channel Replace
Campaign Family Replace
Campaign Offer Replace
Campaign Search Engine Replace
Campaign Subscription Replace
Campaign Vertical Replace
Cash Refund Update
Cash Sale Update
Charge Replace
Check Update
Classification Replace
Consolidated Exchange Rate Replace
Contact Update
Contact Category Replace
Contact Role Replace
Cost Category Replace
Coupon Code Replace
Credit Memo Update
Currency Replace
Currency Rate Replace
Custom List Replace
Custom Record Replace
Customer Update
Customer Category Replace
Customer Deposit Update
Customer Message Replace
Customer Payment Update
Customer Refund Update
Customer Status Replace
Customer Subsidiary Relationship Replace
Department Replace
Deposit Update
Deposit Application Update
Description Item Update
Discount Item Update
Download Item Update
Employee Update
Entity Group Replace
Estimate Update
Expense Category Replace
Expense Report Update
Fair Value Price Replace
File Update
Folder Replace
Gift Certificate Update
Gift Certificate Item Update
Global Account Mapping Replace
Hcm Job Replace
Inbound Shipment Replace
Inter Company Journal Entry Update
Inter Company Transfer Order Update
Inventory Adjustment Update
Inventory Cost Revaluation Update
Inventory Item Update
Inventory Number Replace
Inventory Transfer Update
Invoice Multi-batch Update
Issue Update
Item Account Mapping Replace
Item Demand Plan Replace
Item Fulfillment Update
Item Group Update
Item Receipt Update
Item Revision Replace
Item Supply Plan Replace
Job Update
Job Status Replace
Job Type Replace
Journal Entry Update
Kit Item Update
Lead Source Replace
Location Replace
Lot Numbered Assembly Item Update
Lot Numbered Inventory Item Update
Manufacturing Cost Template Replace
Manufacturing Operation Task Replace
Manufacturing Routing Replace
Markup Item Update
Merchandise Hierarchy Node Replace
Message Update
Nexus Replace
Non Inventory Purchase Item Update
Non Inventory Resale Item Update
Non Inventory Sale Item Update
Note Update
Note Type Replace
Opportunity Update
Other Charge Purchase Item Update
Other Charge Resale Item Update
Other Charge Sale Item Update
Other Name Category Replace
Partner Update
Partner Category Replace
Paycheck Update
Paycheck Journal Update
Payment Item Update
Payment Method Replace
Payroll Item Replace
Period End Journal Update
Phone Call Update
Price Level Replace
Pricing Group Replace
Project Task Replace
Promotion Code Replace
Purchase Order Update
Purchase Requisition Update
Resource Allocation Replace
Return Authorization Update
Rev Rec Schedule Replace
Rev Rec Template Replace
Sales Order Update
Sales Role Replace
Sales Tax Item Replace
Serialized Assembly Item Update
Serialized Inventory Item Update
Service Purchase Item Update
Service Resale Item Update
Service Sale Item Update
Solution Update
State Replace
Statistical Journal Entry Update
Subsidiary Replace
Subtotal Item Update
Support Case Update
Support Case Issue Replace
Support Case Origin Replace
Support Case Priority Replace
Support Case Status Replace
Support Case Type Replace
Task Update
Tax Acct Replace
Tax Group Replace
Tax Type Replace
Term Replace
Time Bill Update
Time Entry Update
Time Sheet Replace
Topic Replace
Transfer Order Update
Units Type Replace
Usage Replace
Vendor Update
Vendor Bill Update
Vendor Category Replace
Vendor Credit Update
Vendor Payment Update
Vendor Return Authorization Update
Vendor Subsidiary Relationship Replace
Win Loss Reason Replace
Work Order Update
Work Order Close Update
Work Order Completion Update
Work Order Issue Update

Key Considerations

When creating the Integration Record (see “Create the Integration Record” step on Source Setup), you must configure the CONCURRENCY LIMIT, limiting the number of concurrent pipelines allowed by integration. If there is a conflict between the limit set in NetSuite and Etleap, your Etleap pipelines will fail.

Integration Record New Record Page