V2

Oracle NetSuite

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

Revision History

1.0.0.4 - 2025/12/17 - Initial release.
1.0.0.5 - 2026/01/20 - Fixed shared OAuthConnection lock handling.
1.0.0.6 - 2026/01/21 - Fixed error message handling.
0.0.0.11 - Node name correction.

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).
Metadata String Cached OpenAPI metadata retrieved via Acquire Metadata.
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

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 Dictionary<string, object> Route/query parameters resolved into the request.
Body IAsyncEnumerable Optional request body streamed into the operation.
Return Type Notes
Response IAsyncEnumerable Streamed response payload; arrays are emitted item-by-item and primitives are wrapped.

Mutation

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 Dictionary<string, object> Route/query parameters resolved into the request.
Body IAsyncEnumerable Optional request body streamed into the operation.
Return Type Notes
Response IAsyncEnumerable Streamed response payload; arrays are emitted item-by-item and primitives are wrapped.

Known Issues

  • Only record types included in the metadata catalog are available in templates; adjust Record Types and reacquire metadata to extend coverage.
  • Responses that are simple values are wrapped in a value property to keep output shapes consistent.