Oracle NetSuite

This documentation for the Oracle NetSuite integration describes the technical capabilities of this integration, including authorization, scopes/permissions, and utilized endpoints. For more information on how to integrate Oracle NetSuite, visit our connection instructions.

Version

This integration utilizes the Oracle NetSuite REST API v1.

Base URL

The base URL used for all Oracle NetSuite API endpoints contains the Account ID:

https://ACCOUNT_ID.suitetalk.api.netsuite.com/services/rest/record/v1/

---

Authentication & Authorization

The DataGrail Oracle NetSuite integration connects using OAuth 2.0 with the following credentials: Client ID and Client Secret.

Sensitive Credentials

Publicly exposing your API credentials can allow unauthorized access to Oracle NetSuite API endpoints by a third party. DataGrail stores your API credentials encrypted and protected.

Limits

Limits in Oracle NetSuite are calculated using the leaky bucket algorithm. All requests that are made after rate limits have been exceeded are throttled and an HTTP 429 Too Many Requests error is returned. Requests succeed again after enough requests have emptied out of the bucket.

• DataGrail supports requests throttling to stay within 70-80% of specified service rate limits.
• DataGrail processes API responses with HTTP 429 status to interrupt requests, waiting and retrying (using an exponential backoff strategy).

---

Capabilities

Access

DataGrail's Oracle NetSuite integration provides Synchronous Access capabilities for the following supported identifier category: Email.

Data Interactions

For Access requests, DataGrail will take the following actions:

1. Search for the customer by the Data Subject email.
2. Get customer details for each of the found customers.
3. Search for the contact by the Data Subject email.
4. Get contact details for each of the found contacts.
5. Search for the employee by the Data Subject email.
6. Get employee details for each of the found employees.
7. Search for the vendor by the Data Subject email.
8. Get vendor details for each of the found vendors.
9. Search for the credit memo by the Data Subject email.
10. Get credit memo details for each of the found credit memos
11. Search for the invoice by the Data Subject email.
12. Get invoice details for each of the found invoices
13. Search for the message by the Data Subject email.
14. Get message details for each of the found messages
15. Search for the purchase order by the Data Subject email.
16. Get purchase order details for each of the found purchase orders
17. Search for the sales order by the Data Subject email.
18. Get sales order details for each of the found sales orders
19. Fetch owned phone calls where the owner can be one of the collected customers, contacts, employees or vendors.
20. Get phone call details for each of the found phone calls.
21. Fetch owned calendar events where the owner can be one of the collected customers, contacts, employees or vendors.
22. Get calendar event details for each of the found calendar events.
23. Fetch owned tasks where the owner can be one of the collected customers, contacts, employees or vendors.
24. Get task details for each of the found tasks.
25. Fetch owned time bills where the employee can be one of the collected customers, contacts, employees or vendors.
26. Get time bill details for each of the found time bills.
27. Fetch cash sales related to one of the collected customers, contacts, employees or vendors
28. Get cash sale details for each of the found cash sales.
29. Fetch vendor bills related to one of the collected customers, contacts, employees or vendors
30. Get vendor bill details for each of the found cash sales.

Endpoints Utilized

Method	Endpoint	Purpose	Docs
GET	/calendarEvent	Fetch owned calendar events
GET	/calendarEvent/ID	Get calendar event details
GET	/cashSale	Fetch cash sales
GET	/cashSale/ID	Get cash sale
GET	/contact	Search for the contact
GET	/contact/ID	Get contact details
GET	/creditMemo	Search for the credit memo
GET	/creditMemo/ID	Get credit memo details
GET	/customer	Search for the customer
GET	/customer/ID	Get customer details
GET	/employee	Search for the employee
GET	/employee/ID	Get employee details
GET	/invoice	Search for the invoice
GET	/invoice/ID	Get invoice details
GET	/message	Search for the message
GET	/message/ID	Get message details
GET	/phoneCall	Fetch owned phone calls
GET	/phoneCall/ID	Get phone call details
GET	/purchaseOrder	Search for the purchase order
GET	/purchaseOrder/ID	Get purchase order details
GET	/salesOrder	Search for the sales order
GET	/salesOrder/ID	Get sales order details
GET	/task	Fetch owned tasks
GET	/task/ID	Get task details
GET	/timeBill	Fetch owned time bills
GET	/timeBill/ID	Get time bill details
GET	/vendor	Search for the vendor
GET	/vendor/ID	Get vendor details
GET	/vendorBill	Fetch vendor bills
GET	/vendorBill/ID	Get vendor bill details

---

Deletion

DataGrail's Oracle NetSuite integration provides Synchronous Deletion capabilities for the following supported identifier category: Email.

Data Interactions

For Deletion requests, DataGrail will take the following actions:

1. Anonymize relevant objects:

Objects

• contacts
• employees
• vendors
• credit memos
• invoices
• messages
• purchase orders
• sales orders
• phone calls
• calendar events
• tasks
• time bills
• cash sales
• vendor bills

Endpoints Utilized

Method	Endpoint	Purpose	Docs
PATCH	/calendarEvent/ID	Anonymize the calendar event
PATCH	/cashSale/ID	Anonymize the cash sale
PATCH	/contact/ID	Anonymize the contact
PATCH	/creditMemo/ID	Anonymize the credit memo
PATCH	/customer/ID	Anonymize the customer
PATCH	/employee/ID	Anonymize the employee
PATCH	/invoice/ID	Anonymize the invoice
PATCH	/message/ID	Anonymize the message
PATCH	/phoneCall/ID	Anonymize the phone call
PATCH	/purchaseOrder/ID	Anonymize the purchase order
PATCH	/salesOrder/ID	Anonymize the sales order
PATCH	/task/ID	Anonymize the task
PATCH	/timeBill/ID	Anonymize the time bill
PATCH	/vendor/ID	Anonymize the vendor
PATCH	/vendorBill/ID	Anonymize the vendor bill

---