Articles in this section

See more

Connect to Oracle NetSuite via REST API (Previous UI)

Avatar
Nexla
  • Updated
Follow

Important Nexla Help Center Update:

Nexla's Zendesk Help Center pages are being deprecated and will soon no longer be available.

Nexla Documentation is now the home for Nexla's User Guides, with improved formatting and categories that are easier to navigate, providing a better overall user experience.

Please update any bookmarks to the new Nexla Documentation site (docs.nexla.com/user-guides).

_______________________________________________

This article describes how to add Oracle NetSuite as a new data source via REST API. This guide requires that token-based authentication (TBA) is enabled in NetSuite.

If TBA has not previously been enabled, the article Set Up Token-Based Authentication (TBA) in Oracle NetSuite is referenced in the relevant steps below and indicates how to enable TBA in NetSuite and obtain the required authentication details to add NetSuite as a new data source in Nexla.

 

Contents:

1. Obtain the Required Authentication Values in NetSuite
2. Add Oracle NetSuite as a Data Source
3. Input Your Credential
4. Select the API Endpoint
5. FAQs

1. Obtain the Required Authentication Values in NetSuite

Important: It is recommended to have Notepad or a similar app open and copying/pasting the authentication details listed in the steps below to/from there, as these values cannot be re-accessed after the screen on which they are initially shown is closed. 
  1. If token-based authentication has not previously been enabled in NetSuite: Follow the instructions in Sections 1-5 of Set Up Token-Based Authentication (TBA) in Oracle NetSuite to obtain the required Consumer Key, Consumer Secret, Access Token, and Access Token Secret values.

  2. If token-based authentication has previously been enabled in NetSuite: Follow the instructions in Sections 4-5 of Set Up Token-Based Authentication (TBA) in Oracle NetSuite to generate the required Consumer Key, Consumer Secret, Access Token, and Access Token Secret values for use with Nexla. If you have already obtained and copied these values, skip to Section 2.

2. Add Oracle NetSuite as a Data Source

  1. Log into Nexla with your provided credentials to view the Nexla Dashboard.
    If you need credentials, contact support@nexla.com.
  1. Select Sources.png from the menu on the left.

  2. Click Create_New_Source.png in the upper right corner of the screen.

  3. Select NetSuite.png, and click Next.png in the upper right corner of the screen to begin adding NetSuite as a data source via REST API.

3. Input Your Credential

  1. Click "Add A New Credential".

    Add_a_New_Credential_v2.png

  2. Enter the name of the credential in the Credential Name field.

    Credential_Name.png

  3. Optional: Enter the desired description of the credential in the Credential Description field.

    Credential_Description.png

  4. Enter the NetSuite account ID to be used with this credential in the NetSuite Account ID field.

    NetSuite_Account_ID.png
    Your NetSuite account ID can be found by navigating to Setup-->Company-->Company Information. It can also be found in your URL, as follows: https://<accountid>.app.netsuite.com/app/center/card.nl?. While leveraging NetSuite REST API services, please capitalize all letters in the account ID.

    Your account ID will include a hyphen and other characters. For example, it may be shown in the above locations as "<12345>-sb1". However, please capitalize all letters when entering the account ID in Nexla. The preceding example should be entered as "<12345>_SB1".
  1. Paste the Consumer Key obtained in Section 1 into the OAuth1 Consumer Key field.

    Consumer_Key.png

  2. Paste the Consumer Secret obtained in Section 1 into the OAuth1 Consumer Secret field.

    Consumer_Secret.png

  3. Paste the Token ID obtained in Section 1 into the OAuth1 Access Token field.

    Access_Token.png

  4. Paste the Token Secret obtained in Section 1 into the OAuth Access Token Secret field.

    Token_Secret.png

  5. Optional: Enter the appropriate NetSuite realm ID in the OAuth1 Realm (Account ID/Company Identifier) field.

    Realm_ID.png
    The realm ID is the NetSuite Account ID. This can be found in your account if you are using a sandbox or test-drive account. When entering the realm ID in Nexla, replace any hyphens shown in these locations with underscores, and capitalize all letters. If the realm ID is shown as "<12345>-sb1", enter "<12345>_SB1".
  1. Click Save.png.
    If the above information was entered correctly, Nexla should now save the credential and authenticate to the associated NetSuite account.

 

4. Select the API Endpoint

  1. Select the appropriate API endpoint from the Endpoint dropdown menu.

    Endpoint.png

  2. Click Create.png to finish connecting Nexla to NetSuite.

  3. Optional: Click Test.png to test the endpoint connection.

    nexla.runtest.png

5. FAQs

1. Verifying Account and Realm IDs

  • Your NetSuite account ID can be found by navigating to Setup-->Company-->Company Information. It can also be found in your URL, as follows: https://<accountid>.app.netsuite.com/app/center/card.nl?. While leveraging NetSuite REST API services, please capitalize all letters in the account ID.

  • Your account ID will include a hyphen and other characters. For example, it may be shown in the above locations as "<123345>-sb1". However, please capitalize all letters while following this guide. The preceding example should be entered as "<12345>_SB1".

  • The realm ID is the NetSuite Account ID. This can be found in your account if you are using a sandbox or test-drive account. While following this guide, replace any hyphens shown in these locations with underscores, and capitalize all letters. If the realm ID is shown as "<12345>-sb1", enter "<12345>_SB1".

2. Resolving an "Account ID is Invalid" Error in Nexla

If the below error is encountered in Nexla,

"detail":"Invalid login attempt. Your Account ID is invalid, or your account has been disabled. Provide a valid Account ID.","o:errorCode": "INVALID_LOGIN"
  • Please verity your account and realm IDs as described in FAQ #1.

  • If the account and realm IDs are correct, ensure that all alphabetical characters are capitalized. Both the account ID and realm ID should always be capitalized when used in Nexla.

3. Verifying that Token-Based Authentication Is Enabled in Your NetSuite Account

To verify that TBA is enabled in your NetSuite account, log into NetSuite, and

  • Navigate to Setup-->Users/Roles-->Access Tokens. Ensure that the "Access Tokens" feature is enabled in NetSuite.

  • Navigate to Setup-->Company-->Enable Features, and select the "SuiteCloud" tab. Under "Manage Authentication", enable "Token-Based Authentication".

4. Creating Your NetSuite Token Authentication Information

Your integration will require token authentication details provided by NetSuite. We recommend keeping a Notepad-type app open during the generation of these values and copying/pasting the required token values to/from there, as these values cannot be re-accessed after the screen in which they are initially shown is closed.

The four token values generated by NetSuite are the:

  1. Consumer Key
  2. Consumer Secret
  3. Token ID
  4. Token Secret

Comments

0 comments

Please sign in to leave a comment.

Powered by Zendesk