Instructions for getting started with the Aquifer NetSuite connector. Aquifer interacts with NetSuite using two APIs, the RESTful API that was introduced a few years ago and the SOAP API which has been around since the early 2000s. In these guide, you will be setting up access for Aquifer for both of these APIs. If you do not need to support files and other certain operations, you may only need to set up the REST API, please ask Aquifer support which APIs you require.

• REST API
  • Used to read and write most NetSuite data.
  • Aquifer authenticates with NetSuite REST API using the industry standard OAuth 2.0. In these instructions, you will enable OAuth 2.0 in your NetSuite account, add Aquifer as an integration, and setup the credentials needed for Aquifer to connect.
• SOAP API
  • Primarily used to read and write file attachments, which are not supported by the REST API.
  • Also used for attaching contacts, which is not supported by the REST API.
  • Used for some objects that have issues being read or written to by the REST API.
  • Uses NetSuite’s custom Token Based Authentication (TBA)

REST API Steps

1. Enable OAuth 2.0 in your NetSuite account - https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_157771482304.html#Enable-the-OAuth-2.0-Feature
   1. You may have already completed this step for another integration in the past, if so, it can be skipped.
   2. Note Aquifer does not require the Client SuiteScript or Server SuiteScript to be selected.
2. Create an Integration record - https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_157771733782.html#Create-Integration-Records-for-Applications-to-Use-OAuth-2.0
   1. Uncheck everything in the section “Token-based Authentication”
   2. Under the “OAuth 2.0” section, the follow options should be checked:
      1. “Client Credentials (Machine to Machine) Grant”
      2. “REST Web Services”
   3. Make sure to record the Client ID, it won’t be displayed again, and you’ll need to enter it into the connector setup form for Aquifer.
3. Setup Client Credentials - https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_162686838198.html#OAuth-2.0-Client-Credentials-Setup
   1. For the Entity, choose a user with Administrative access or one that has been created specifically for Aquifer.
   2. For the Role, choose Administrator or a role that has been created specifically for Aquifer.
   3. For Application, choose Aquifer, this was made in the previous step.
   4. For Certificate, upload the public key file Aquifer provided you.
   5. Make sure to record the Certificate ID, you’ll need to enter it into the connector setup form for Aquifer.

SOAP API Steps

1. Make sure Token Based Authentication (TBA) is enabled - https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/bridgehead_4253254429.html#Enable-the-Token-based-Authentication-Feature
2. Create an Integration record, perhaps calling this "Aquifer Files” - https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/bridgehead_4249032125.html#Create-Integration-Records-for-Applications-to-Use-TBA
   1. On the Authentication tab
      1. Check "Token-based Authentication (TBA)”
      2. Uncheck "User Credentials" if it is checked
   2. After saving, it should display the Consumer Key and Consumer Secret. If it doesn't, they can be regenerated - https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4395597766.html#Regenerating-a-Consumer-Key-and-Secret
3. Create an Access Token - https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/bridgehead_4254081947.html#procedure_4253065595
   1. Select the Application from the previous step, along with a User and Role
   2. After you click save, record the Token ID and Token Secret

Aquifer Connection Setup

1. From the Aquifer UI, click “Connect”
2. Look for NetSuite and click “Connect”
3. A step-by-step wizard will be presented
   1. Give the connection a name, typically “netsuite” but if you have multiple accounts it could be “netsuite_somesubsidiary”
   2. Fill out the connection form
      1. Account ID - You can find that in your NetSuite web URL - https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_1498754928.html#Finding-Your-NetSuite-Account-ID
      2. Client ID - This is from the second step from the REST API setup.
      3. Certificate ID - This is from the third step from the REST API setup.
      4. Consumer Key - This is from the second step from the SOAP API setup.
      5. Consumer Secret - This is from the second step from the SOAP API setup.
      6. Token ID - This is from the third step from the SOAP API setup.
      7. Token Secret - This is from the third step from the SOAP API setup.
   3. Click “Finish”