Connector Details
| Name | Value |
|---|---|
| Platform | NetSuite |
| Auth Type | API Keys |
| Direction | Bidirectional |
| Tap Repo | https://github.com/hotgluexyz/tap-NetSuite |
| Target Repo | https://gitlab.com/hotglue/target-NetSuite-v2 |
| Tap Metrics | Usage: |
| Target Metrics | Usage: |
| Unified Schema |
Credentials Setup
Follow the steps below to get the credentials you need to use the NetSuite connector.Step 1: Create a new Integration in NetSuite.
Head to Setup > Integration > Manage Integrations > New.
- Choose an integration name of your choice.
- You must select Token Based Authentication and TBA: Issuetoken Endpoint
- You must NOT select Authorization Code Grant
Step 2A (Easy): Create a NetSuite Role with the appropriate permissions.
This is the easiest way to setup a NetSuite Role with the appropriate permissions for Hotglue.Head to Customization > SuiteBundler > Search & Install Bundles
If you want write permission given to Hotglue, you can type in 572066. Make sure the package says Hotglue (read+write).
Step 2B (Hard): Create a NetSuite Role with the appropriate permissions.
It is recommended that you follow Step 2A (Easy):Head to Setup > Users/Roles > Manage Roles > New
Choose a new role name of your choice and go to Permissions - Setup on the bottom of the page.
- User Access Token (Full)
- SOAP Web Services (Full)
- Log in using Access Tokens (Full)
- Integration Application (Full)
- REST Web Services (Full)
- Access Token Management (Full)
Add the permissions you need to access relevant data in the Transactions, Reports, and Lists sections.
See a full list of available objects in the NetSuite docs
Step 3: Assign NetSuite Role to NetSuite User
If you want to assign the Integration Token a New User, head to Lists > Employees > Employees > New
Alternatively, if you already have a User you’d like to use ready, head to Lists > Employees > Employees > Search and open the user.
Once you have opened the relevant user, and select Edit
Edit EmployeeScroll down to the Access > Roles tab, and add our new Integration Role to the list
Add Integration Role to UserPress SaveStep 4: Generate NetSuite Access Token / Secret
Head to Setup > Users/Roles > Access Tokens > New
Step 5: Add the credentials to Hotglue
We’re done! You’re ready to use the NetSuite integration in Hotglue.To find your account ID, you can either search NetSuite for Account ID, or you can take the first number in your URL for NetSuite.Tap Changelog
Tap Changelog
Tap Changelog
| Version | Notes |
|---|---|
| v1.5.20 | |
| v1.5.19 | |
| v1.5.18 | |
| v1.5.17 | |
| v1.5.16 | |
| v1.5.15 | |
| v1.5.14 | |
| v1.5.13 | |
| v1.5.12 | |
| v1.5.11 | - Update replicate key logic |
| v1.5.10 | - Fix replication keys issues |
| v1.5.9 | |
| v1.5.8 - Add support for discount lines | - Add support for discount lines in Invoices |
| v1.5.7 - Add backoff handling | - Add backoff handling in NetSuite SDK to handle gateway timeouts and concurrent request exceptions |
| v1.5.6 - Bump NetSuite sdk | - Bumped NetSuite sdk version |
| v1.5.5 - Handle empty data error | - Handle error when there’s no data for a stream |
| v1.5.4 - Fix Item schema issue | - Updated rate schema to string instead of number |
| v1.5.3 - Add support for Purchase Orders | - Added support for Purchase Orders |
| v1.5.1 – Add SalesOrder support | Added support for pulling Sales Orders and added internalid to payloads |
| v1.5.0 – Fix issue with duplicate columns in output | - Fixed schema issue causing duplicate LastModDate entry in the output for InventoryItem |
| v1.4.33 - Hotfix for pulling Vendor Payments and Vendor Bills | Fixed bug pulling Vendor Payments and Vendor Bills which was caused by updating NetSuite SDK |
| v1.4.32 - Add support for inventory management endpoints | Added support for inventory management endpoints |
| v1.4.31 | Update issue with replication_key_value missing assignment |
| v1.4.30 | Add support for Vendors, VendorBills, VendorPayments, and Invoices |