OAuth 2.0 for NetSuite
This section describes the steps to configure Alteryx Analytics Cloud (AAC) to integrate with your NetSuite deployment using OAuth 2.0 to authenticate.
Create OAuth 2.0 Client App in NetSuite
Follow these steps to create an OAuth 2.0 client app in Netsuite...
Sign in to your NetSuite account using the credentials which have access to Administrator role.
Change your role to Administrator.
Navigate to Setup > Integration > Manage Integrations > New.
Enter these details as required...
Name: Name of the OAuth 2.0 Client.
State: Set as Enabled.
Description: (Optional) Description of the client.
OAuth 2.0:
Authorization Code Grant: Set this value to true.
Rest Web Services: Set this value to true.
Redirect URI: Enter this callback URL:
https://us1.alteryxcloud.com/oauth2/callback
After entering the details, click Save.
Copy the Consumer Key or Client ID and Consumer Secret or Client Secret.
Enable Features and Permissions
You must enable these features and permissions in NetSuite account for the OAuth process to work successfully:
SuiteCloud tab:
Go to Setup > Company > Enable features > SuiteCloud tab.
Enable these features...
a. Select SuiteScript > Client SuiteScript & Server SuiteScript.
b. Select SuiteTalk > Rest Web Services.
c. Select Manage Authentication > OAuth 2.0.
Analytics tab:
Navigate to Setup > Company > Enable features > Analytics tab.
Select SuiteAnalytics Workbook > SuiteAnalytics Workbook.
Permissions
Enable permissions for your role : Setup > Users/Roles > Manage roles > <
Name of your role
> > Edit.Enable these permissions...
Select Permissions > Reports >Add SuiteAnalytics Workbook (Edit).
Select Permissions > Setup > Add Custom Fields(View), Custom Record Types(View), Log in using OAuth 2.0 Access Tokens(Full), OAuth 2.0 Authorize Applications Management(Full) and REST Web Services(Full).
Verify that your role which has all of the above permissions enabled is set as the
default
role.
For more information, go to https://cdn.cdata.com/help/DNG/jdbc/pg_permissions.htm.
Create OAuth 2.0 Client for NetSuite
After you create the NetSuite connected app, you must create an OAuth 2.0 client in AAC, which is used to integrate with the OAuth 2.0 connected app that you created above.
Note
You must create 1 OAuth 2.0 client in AAC for each NetSuite connected app that you want to use.
Steps:
Sign in to AAC as a Workspace Administrator.
Select Profile menu > Workspave Admin > OAuth2.0 Clients.
On the OAuth2.0 Clients page, select Register OAuth2.0 Client.
Specify the new client. Apply these values:
Setting
Description
Type
Set to
NetSuite
.Name
Display name for the OAuth 2.0 client in AAC.
Client ID
Set this value to the Client ID created above.
Client Secret
Set this value to the Client Secret value created above.
Authorization URL
Set this value to the following:
https://<ACCOUNT_ID>.app.netsuite.com/app/login/oauth2/authorize.nl
Token URL
Set this value to the following:
https://<ACCOUNT_ID>.suitetalk.api.netsuite.com/services/rest/auth/oauth2/v1/token
Scopes
Set to rest_webservices
.Access Token Expires In
Set this value to
3600000
.Refresh Token Expires In
Set this value to
604800000
.To save your OAuth 2.0 client, select Create.
For more information, go to Create OAuth2 Client.
Create NetSuite Connection
After you creat the 2 OAuth 2.0 client references, you can create a connection to your NetSuite data.
Note
You must create a separate connection for each OAuth 2.0 client that is available in AAC.
For more information, go to NetSuite Connections.