Oracle NetSuite REST Connector

Oracle NetSuite REST connector allows you to run SuiteQL queries, and perform list, get, delete, update, upsert and create record operations using SuiteTalk REST Web Services.

API Versions: V1

API Types: REST

Authentication and Authorization: OAuth 2.0

Key Capabilities: SuiteQL, Custom Field support, Basic CRUD operations

Prerequisites

  • NetSuite account
  • Working IBM® webMethods Integration tenant

Custom Actions

NetSuite connector allows you create your own custom actions for performing specific tasks.

Learn more about how to create custom actions.

Usage Notes

SuiteQL

  • The default values for select and from clauses are set to fields and recordType selected respectively while creating the operation, unless these values are overridden.

  • The complexQuery takes precedence if specified and any query request inputs are disregarded.

  • The Add a Field option can be used if your query response includes fields not displayed on the field selection screen.

Get Record

  • The default values for fields are set to fields selected while creating the operation.

  • The default value for expandSubresource is set to false. However, to retrieve subresources in the response you can use the parameter expandSubresource. Note that when expandSubresource is used, any specified fields will be ignored.

List Record

  • The List record operation allows you to filter the collection of all record instances by specifying filter conditions. For information on Record Collection Filtering, see the NetSuite Application Online Help.

Other Operations

  • The Create, Update, and Upsert operations allow you to retrieve the Location header in case of a successful response that includes the ID of the affected record.

Limitations

  • Some recordTypes in NetSuite have a beta label indicating that the functionality they provide is preliminary and subject to change or discontinuation without prior notice.

  • The List Records resource retrieves HATEOAS links and record IDs as a response.

  • The REST query service does not support the Asynchronous request execution.

  • The SuiteQL resource retrieves the field values and does not support the retrieval of sublist, subresource, or similar data.

  • The refresh token request returns both an access and a refresh token when using public clients with OAuth 2.0 Authorization code grant flow. The refresh token can only be used once and is valid for three hours.

  • The metadata-catalog call, which retrieves a list of recordTypes, may take longer due to delay in creating an operation.