Oracle NetSuite REST Adapter Capabilities

The Oracle NetSuite REST Adapter enables you to create an integration in Oracle Integration that connects to the NetSuite application. You can configure the Oracle NetSuite REST Adapter as an invoke connection in an integration in Oracle Integration.

The Oracle NetSuite REST Adapter provides the following capabilities:

  • Supports CRUD (create, retrieve, update, or delete) operations on records using standard REST methods (POST, GET, PATCH, PUT, and DELETE).

  • Allows you to retrieve single or multiple records by creating customized queries using SuiteQL. You can make queries dynamic by adding binding parameters.

  • Allows synchronous and asynchronous requests:

    • CRUD and SuiteQL search operations can be executed synchronously or asynchronously.
    • Synchronous requests are suitable for records up to 104 MB in size. Results are returned instantly.
    • Asynchronous requests support long-running tasks (records greater than 104 MB in size) such as large data retrieval or heavy SQL searches. A job ID is returned in the response.

      See REST Web Services Request Processing.

  • Supports asynchronous operations:

    • Allows checking of the job status using the Check Job Status operation and retrieves the task ID using the Retrieve Task ID operation.
    • Fetches results using the returned IDs through the Fetch Async Results operation.
  • Supports RESTlet operations:
    • Defines custom operations by writing JavaScripts and deploying them within the NetSuite application.
  • Supports the OAuth Authorization Code Credentials and JWT Client Credentials Assertion for NetSuite security policies.

The Oracle NetSuite REST Adapter is one of many predefined adapters included with Oracle Integration. See the Adapters page in the Oracle Help Center.

Advantages Over the Oracle NetSuite Adapter

The Oracle NetSuite REST Adapter provides the following advantages over the Oracle NetSuite Adapter.

  • Unlike the Oracle NetSuite Adapter, which uses SOAP APIs, the Oracle NetSuite REST Adapter uses REST APIs and JSON payloads, which are lightweight, human-readable, and easy for modern integration platforms to process.
  • The Oracle NetSuite Adapter relies on the Username Password Token Policy (token-based authentication). This policy exposes higher risk because credentials may be stored in integration systems. On the other hand, the Oracle NetSuite REST Adapter uses OAuth 2.0 Authorization Code Credentials, a modern, secure, industry-standard authentication method, which eliminates the need to manage or store user passwords.
  • The Oracle NetSuite REST Adapter allows you to create customized queries, define custom operations by writing JavaScript, and deploy them within the NetSuite application.
  • The Oracle NetSuite REST Adapter is more powerful and flexible, with modern querying and custom API extension capabilities.