NetSuite Connection

See the Connector Marketplace topic. Please request your administrator to start a trial or subscribe to the Premium NetSuite connector.

NetSuite is a cloud-based system that helps companies manage important business processes like financials, inventory, and customer relationships all in one place.

This topic describes how to authenticate to NetSuite and configure any necessary connection properties in the NetSuite connection connector.

Connection Configuration #

Each connection property available in the NetSuite connector is explained below.

Connection Name #

The name of the connection to be created should be provided. This is the name that will display on the list of available connections.

Auth Scheme #

The type of authentication to use when connecting to Workday.

Possible Values

• Basic: Set this to use BASIC user / password authentication.

• OAuth: Set to this to perform OAuth authentication. This is essentially token based authentication where the token is dynamically created instead of directly in the NetSuite UI.

Basic #

If Basic is selected, additional configuration parameter will get listed.

User #

The user of the NetSuite account used to authenticate.

Password #

The password of the NetSuite user used to authenticate.

Account ID #

The company account your username is associated with on NetSuite.

Role ID #

The RoleId is the InternalId of the role that will be used to log in to NetSuite. Leave empty to use the user’s default role.

Together with User, Password, and AccountId, this field is used to authenticate to NetSuite.

If no RoleId is specified, the user’s default role will be used.

Otherwise, a RoleId may be obtained by logging into NetSuite, and navigating to the Setup -> Integration -> Web Services Preferences page.

Here you can select a different Web Services Default Role as well as obtain the Id, displayed next to the specified role.

OAuth #

If OAuth is selected, additional configuration parameters will get listed.

Client ID #

The client Id assigned when you register your application with an OAuth authorization server.

Client Secret #

The client secret assigned when you register your application with an OAuth authorization server.

Refresh Token #

The OAuth refresh token for the corresponding OAuth access token.

IncludeChildTables #

A boolean indicating if child tables should be displayed.

If this is set to true, tables will be displayed for all child lists of a given entity.

For instance, the CashRefund table in the NetSuite development environment has a child list called ItemList.

Therefore, a new table called CashRefund_ItemList will be displayed if this property is set to true.

This can be useful for listing each item in the list in its own row.

After entering all the details, click on the TEST button.

If the connection service identification and authentication details are provided correctly, a success message stating “connection available” is generated.

Click on the CREATE button to save the changes.

If the details are incorrect or the server is down, you will get a message “Connection unavailable”.