Oracle NetSuite is a comprehensive, cloud-based ERP solution that integrates key business functions such as accounting, HR, supply chain, and CRM. It offers real-time insights into business processes, enhancing efficiency and decision-making across organizations of any size with detailed financial and performance metrics.
The NetSuite - Generic connector enables you to call endpoints in the NetSuite API, providing flexibility to interact with tailored NetSuite workflows or retrieve specialized data beyond standard operations.
Configuration
NetSuite - Connection (ver. 1.0.0)
URL
URL of your NetSuite instance.
Account ID
Account ID for NetSuite API.
Consumer Key
Consumer key for NetSuite API.
Consumer Secret
Consumer secret for NetSuite API.
Token ID
Token ID for NetSuite API.
Token Secret
Token secret for NetSuite API.
NetSuite - Custom Request Configuration (ver. 1.3.0)
Endpoint
Specifies the NetSuite API endpoint to be called. You can select from predefined options, or take the endpoint dynamically from input.
HTTP Method
Specifies the HTTP method to use for the API request. Options include standard methods like GET, POST, DELETE, PUT, PATCH, or dynamically set the method from input.
Error behavior
The available values are:
-
Fail and return response: The connector fails at the specified line but generates output with error details.
-
Fail without response: The connector fails - the error will be displayed only in the log.
-
Do not fail and return response: The connector does not fail but generates output records that may be marked with an error and detailed information.
Input & Output Schema
Input
NetSuite - Generic Request (ver. 1.6.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Endpoint | String | Yes | Specifies the NetSuite API endpoint to be called |
| HttpMethod | String | Yes | Specifies the HTTP method (e.g., GET, POST) for the request |
| Body | JSON | Yes | Provides the JSON payload for the API request, if needed |
Output
NetSuite - Generic Response (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| StatusCode | Integer | No | HTTP status code returned by the NetSuite API indicating the result of the operation |
| IsError | Bool | No | Indicates whether the operation resulted in an error |
| Message | String | Yes | Error or status message providing additional information |
| Headers | JSON | Yes | Received HTTP headers returned by the NetSuite API |
| Content | JSON | Yes | The response content returned by the NetSuite API |
Status Code
- 200 Success
- 400 Bad request
- 404 Not found
- 500 Server error
Release notes
3.0.14
- First release