EONE BLOG

Tech Tuesday: Setting up the NetSuite Connector in SmartConnect.com


We use two different authentication methods for setting up our NetSuite connector in SmartConnect.com. The first method is User Credential (SuiteSignOn) authentication. This method uses a user’s email address and password in combination with an application id, role id, and account id. The second, and preferred method, is Token Based Authentication. This method requires a little more setup on the NetSuite side, but it does have its benefits such as:

  1. Ability to make 5 concurrent API requests (user credential is only one connection).
  2. Not affected if a password expires.
  3. No need to give out user credentials.
  4. User credentials are not stored.

Setup for User Credential Authentication

  • Setup an integration to get an application id.
    • In NetSuite, navigate to Setup>>Integration>>Manage Integrations>>New
    • Name the Integration.
    • Check the box for USER CREDENTIALS.
    • Save the integration.
    • After saving, take note of the APPLICATION ID. It will be used on the connector setup.



  • Add user to Web Services Preferences for the Account Id and Role Id.
    • In NetSuite, navigate to Setup>>Integration>>Web Services Setup
    • Add the user you want to use to sign in with. This will give you a Role Id and the Account Id is shown under the Primary Information section.

Netsuite Connector SC.com

  • Setup a NetSuite connector in SmartConnect.com using SuiteSignOn.
    • In SmartConnect, navigate to Connections>>Create Connection>>NetSuite
    • Name the connection and choose SuiteSignOn for the Authentication type.
    • Enter the information for the active fields that we gathered in the previous steps and click Validate.
    • Save the connector after successful validation.

Netsuite Connector SC.com

This connector can now be used for sources and destinations in SmartConnect.com. With this authentication type you will be able to make one connection to NetSuite at a time.

Setup for Token Based Authentication

  • Enable Token Based Authentication
    • In NetSuite, Navigate to Setup>>Company>>Enable Features. Click the Suite Cloud tab and go to the Manage Authentication Section.
    • Select the TOKEN-BASED AUTHENTICATION Box and Save.
  • Setup an integration
    • In NetSuite, navigate to Setup>>Integrations>>Manage Integrations>>New
    • Name the integration.
    • Check the box for TOKEN-BASED AUTHENTICATION.
    • Save the integration. This will create a CONSUMER KEY and CONSUMER SECRET that will only be displayed one time, so save them now. You will need both later in SmartConnect.

NetSuite Connector SC.com

  • Create an Access Token. To create an access token, we need to setup a role and assign the role to a user.
    • To create a new role or update an existing role, navigate to Setup>>User/Roles>>Manage Roles.
    • Click the New Role button or edit an existing role if you have one setup that you would like to add token based authentication to.
    • You can setup the role as needed, but you need to make sure to add the Employee Record and Employees under Permissions>>Lists and the User Access Tokens and Web Permissions under Permissions>>Setup. These are the minimum permissions needed to be able to setup the connector. You will need additional permissions in place in order to query role categories/types depending on your specific needs.NetSuite Connector in SC.comNetSuite Connector in SC.com
    • Add this role to a user by navigating to List>>Employees>>Employees>Edit on desired user. Click on the Access tab, then the Roles sub tab.NetSuite Connector in SC.com
    • Generate the Access token by navigating to Setup>>Users/Roles>>Access Tokens>>New. Choose the Application Name that was created in Step 2, select the user we assigned the role to, and choose the role.
    • Click Save and a this will create a Token and Token Secret that will only be shown once, so save them now. You will need both later in SmartConnect.
Netsuite Connector in SC.com
  • Setup a NetSuite connector in SmartConnect.com using Token Based Authentication.
    • In SmartConnect, navigate to Connections>>Create Connection>>NetSuite
    • Name the connection and choose Token Based Authentication.
    • Enter the information we gathered in the previous steps and click Validate. Note: Your Account Id can be found in NetSuite by navigating to Setup>>Company>>Company Information.
    • Save the connector after successful validation.

This connector can now be used for sources and destinations in SmartConnect.com.  With this authentication type you will be able to make five connections to NetSuite at a time.  If the user access tokens are active, this connection will work, even if the user needs to change their password due to a password policy. 

If you have any more questions, feel free to send us an email at sales@eonesolutions.com

Leave a Comment





RECENT POSTS


The Pick Popdock Papers, Part IV: That's nice, but what else can it do?
Tech Tuesday: Integrating Record Notes in Dynamics GP with SmartConnect
Targeting Your Audience Based On Contacts From Multiple Applications With Popdock
eOne Offices Closed for Labor Day, Monday, September 2nd
How to Connect with eOne Solutions at the GP Tech Conference

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
New Releases of Extender and SmartList Builder
2017 SmartConnect Integration Bootcamps

CATEGORIES

ARCHIVES

open all | close all

TAGS

Business Central CRM Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight Events Excel Excel Report Builder Extender Extender Enterprise Flexicoder GP GPUG integration Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Office Relationships partners Popdock release Reporting SalesForce SalesForce.com scripting SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Office Hours SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.