Netsuite RESTlets connection

Setting up the connection

• Make sure you are logged in as an Administrator.
• Enable web services & token-based authentication

Enable web services & token-based authentication

1. Under Setup > Company > Enable Features.

2. Click SuiteCloud.

3. Under SuiteTalk, enable SOAP WEB SERVICES.
4. Under Manage Authentication, enable TOKEN-BASED AUTHENTICATION.
5. Scroll to the end or start of the page and click Save.

Create an integration record (app) for Data Integration

1. Under Setup > Integration > Manage Integrations > New.

2. Name your integration Data Integration.

3. Make sure the TOKEN-BASED AUTHENTICATION (TBA) is enabled, and insert the callback URL based on the site you log in to Data Integration. For US URI:

For accounts using https://console.rivery.io:

https://console.rivery.io/api/oauthcallback/netsuite_restlets

For accounts using https://eu-west-1.console.rivery.io:

https://eu-west-1.console.rivery.io/api/oauthcallback/netsuite_restlets

4. Click Save. A consumer secret and key appear. (Also, they will only appear once).

Create a role and set permission

1. Create a role

   • Go to Setup > Users/Roles > Manage Roles > New.
   • Name your role Data Integration.
   • Under Authentication enable the WEB SERVICES ONLY ROLE option.

2. Set Permission for the role
   There are two options when setting permissions:

3. Set the administrator role:
   This is done under the General tab > issue role > administrator. If you choose this option, continue to the "Create a user..." section once the role is set (don't forget to save the role)

4. Set specific permission for the role:
   A list of minimum permissions you need to grant to the role to use Data Integration with Netsuite:
   

Add permissions

1. Under the permissions tab, find the subtab corresponding to the entity you wish to extract. For example, lists.
2. Find the record to which you want to add permission. For example, Accounts.
3. Set the level of permission for that record. For example, view.
4. Click add.
5. Keep going until you add all entities.
6. Click Save.
7. You must also add specific permission for each record you want to use Data Integration to extract, For example, Accounts, Invoice.

Create a user and assign the role

Create a user and assign the role you previously created to the user. It is recommended to use "Data Integration" as the name of the user and the role.

1. Go to Lists > Employees > Employees > New.
2. Enter the name and the email address.
3. Click the Access subtab.
4. Check Give Access and Send Notification Email.
5. Check Manually Assign or Change Password.
6. Assign a password of your choice.
7. Select the Role that you need to assign. In this case, Data Integration and click Add.
8. Click Save to save the record.

Create an access token for Data Integration

1. Under Setup > Users/Roles > Access Tokens > New.

2. Select the application (an integrated record) you've previously created.

3. Select the user you've previously created.

4. Select the role you've created for that user.

5. Enter a name for the access token or use the generated name.

6. Copy the token ID and secret; you need them in the connection in Data Integration. (Also, they will only appear once.)

Locate your account ID

1. Navigate to: Setup > Integration > Soap Web Services Preference.
2. Under Primary Information, you will find your Account ID.

Upload and deploy Data Integration script

1. Download the javascript file from our repository press right-click on the link here and select Save link as. Otherwise, go into the link and download the raw file there.

(To download the file from GitHub, right-click on Raw, and select Save link as..)

2. Log in to your Netsuite account.

3. Go to Customization > Scripting > Scripts > New.

4. Select a new file (+) and upload the downloaded file. Write a suitable name for your script. Once finished, click Save.

5. Go to Customization > Scripting > Scripts.

6. After selecting the js file, click Create Script Record. In the Script title window opening up, click Save and Deploy.

7. In the Script Deployment screen opening up, check that the same permissions and status are selected:

   • Select specific roles (or all) to run the script, status: released and Deployed.
   • Once finished, click Save.

8. Copy the account ID, script ID, and deploy ID.

note

Sandbox account IDs end with -sb2, while production account IDs do not have this suffix. If your sandbox account ID includes an underscore (e.g., 123456_sb2) or any other character, please update it to use a hyphen instead (e.g., 123456-sb2).

Creating a NetSuite RESTlets connection in Data Integration

Procedure

1. Navigate to your Data Integration account.
2. Click Connections and select + New Connection.
3. Choose NetSuite RESTlets.
4. Enter a Connection Name and insert the connection details you located/created into the corresponding fields:
   • Consumer Key
   • Consumer Secret
   • Token ID
   • Token Secret
   • Account ID - The located Account ID
   • Script ID
   • Deploy ID
5. Click Save and create the connection.
6. Click Test Connection to verify the test is successful.

If the test succeeds, you are ready to work with NetSuite RESTlets in Data Integration

Troubleshoot test failure

If the test-connection fails, check the credentials. If you are certain that these steps are right, then the script's filename does not end with .js. Click edit script filename and add the .js.