V2

Oracle NetSuite

Executes Oracle NetSuite REST Web Services operations using the published metadata catalog and OpenAPI-driven templates for record resources.

Revision History

0.0.0.4 - Initial release.
0.0.0.5 - Fixed shared OAuthConnection lock handling.
0.0.0.6 - Fixed error message handling.
0.0.0.11 - Node name correction.
0.0.0.19 - Parameter and template fixes.

Setup Notes

  1. Create a NetSuite Integration record with REST Web Services enabled and capture the Client ID and Client Secret.
  2. Identify your NetSuite Account ID (for example, 123456_SB1) and ensure REST Web Services are enabled.
  3. Configure the OAuth redirect URI in NetSuite, then initiate the OAuth flow in Flowgear to obtain Access Token and Refresh Token.
  4. (Optional) Limit the metadata catalog to specific record types by listing them (one per line) in Record Types, then click Acquire Metadata to download templates faster.
  5. Use the Query and Mutation templates to select the desired operation ID before invoking the node.

Connection

Parameter Type Description
Account ID String NetSuite account ID (for example, 123456_SB1).
Record Types String Optional record types to include when acquiring metadata (one per line).
Client ID String NetSuite integration client ID.
Client Secret Masked NetSuite integration client secret.
Access Token Masked OAuth access token obtained during authorization.
Refresh Token Masked OAuth refresh token obtained during authorization.
Scope String OAuth scopes requested (default: rest_webservices).
Timeout (seconds) Integer Timeout applied to API calls and metadata acquisition.

Functions

Query

Retrieves NetSuite resources.

Parameter Type Notes
Connection Connection NetSuite REST connection with OAuth credentials and cached metadata.
Operation ID String Operation identifier from the NetSuite metadata catalog (selected via templates).
Parameters Object Route/query parameters resolved into the request.
Body Array Optional request body streamed into the operation.
Return Type Notes
Response Array Streamed response payload; arrays are emitted item-by-item and primitives are wrapped.

Mutate

Create, update, or delete NetSuite resources.

Parameter Type Notes
Connection Connection NetSuite REST connection with OAuth credentials and cached metadata.
Operation ID String Mutation identifier from the NetSuite metadata catalog (selected via templates).
Parameters Object Route/query parameters resolved into the request.
Body Array Optional request body streamed into the operation.
Return Type Notes
Response Array Streamed response payload; arrays are emitted item-by-item and primitives are wrapped.

Usage Notes

  • Only record types included in the metadata catalog are available in templates; adjust Record Types and reacquire metadata to extend coverage.