Oracle NetSuite Spoke
Summarize
Summary of Oracle NetSuite Spoke
The Oracle NetSuite spoke enables ServiceNow customers to automate create, read, update, and delete (CRUD) operations on Oracle NetSuite records directly from their ServiceNow instance. It offers preconfigured actions, subflows, connection and credential aliases, and scripted REST APIs to facilitate seamless integration and automation between ServiceNow and Oracle NetSuite.
Show less
This spoke requires an Integration Hub subscription and is compatible with Oracle NetSuite API version 1.0, with potential compatibility for later versions. Installation depends on several prerequisite plugins, some of which may require additional licenses if used outside the spoke.
Key Features
- Preconfigured Actions: Automate key tasks such as creating, deleting, updating, and looking up records (e.g., purchase orders, accounts) in Oracle NetSuite.
- Metadata Retrieval: Retrieve lists of available objects and detailed schema information for Oracle NetSuite records.
- Sample Subflows: Includes sample subflows like "Get Record Details" and "Create Purchase Order" to demonstrate automation capabilities. These can be customized by copying into a new application scope.
- Connection and Credential Aliases: Simplifies management of connection profiles and OAuth credentials across multiple environments, reducing maintenance effort when connection details change.
Practical Benefits for ServiceNow Customers
- Streamlines integration workflows by automating Oracle NetSuite record management directly from ServiceNow.
- Reduces manual data entry and errors by using prebuilt actions and subflows tailored to Oracle NetSuite's API requirements.
- Facilitates scalable and maintainable integrations through connection aliases, minimizing configuration updates during environment changes.
- Provides a clear foundation for extending or customizing automation to fit specific business processes using subflows and scripting utilities.
Automate create, read, update, and delete (CRUD) record management operations in Oracle NetSuite from your ServiceNow instance by using the Oracle NetSuite spoke. It provides preconfigured actions, subflows, connection and credential aliases, and scripted REST APIs to do these operations.
Request apps on the Store
Visit the ServiceNow Store website to view all the available apps and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the ServiceNow Store version history release notes.
Integration Hub subscription
This spoke requires an Integration Hub subscription. For more information, see Legal schedules - IntegrationHub overview.
Spoke version
Oracle NetSuite spoke v1.2.0 is the latest version.
Supported versions
This spoke was built for Oracle NetSuite API version 1.0, but may be compatible with later versions.
Spoke dependencies
- Complex Object (com.glide.object)
- ServiceNow IntegrationHub Action Template - Data Stream (com.glide.hub.action_type.datastream)
- ServiceNow IntegrationHub Runtime (com.glide.hub.integration.runtime)
- ServiceNow IntegrationHub Action Step - REST (com.glide.hub.action_step.rest)
- ServiceNow IntegrationHub Action Step - SOAP (com.glide.hub.action_step.soap)
- ServiceNow Flow Designer - Dynamic Inputs (com.glide.hub.dynamic_inputs)
- ServiceNow Flow Designer - Dynamic Outputs (com.glide.hub.dynamic_outputs)
Spoke subflows
The Oracle NetSuite spoke provides sample subflows to demonstrate automating Oracle NetSuite tasks. To customize a sample subflow, copy it to a new application scope. Available sample subflows include:
| Subflow | Description |
|---|---|
| Get Record Details (Inbound) | Triggers the 'Look up Record Details' action. The output of the action is logged for reference. You can replace the logging step with custom logic, such as creating records in a desired table, depending on the requirement to store record details. |
| Create Purchase Order (Outbound) | Triggers the 'Create Record' action of the Oracle NetSuite Spoke. Required data is provided through subflow inputs, and all fields are structured exactly as per the API requirements. All subflow inputs are passed directly to the action, except for one: the input of type Array of Objects is converted to a string using the OracleNetsuiteUtils.stringifyArray(array) method before being passed. This method should be used for all Array of Object type inputs. |
Spoke actions
The Oracle NetSuite spoke provides actions to automate Oracle NetSuite tasks when events occurs in your ServiceNow instance. Available actions include:
| Category | Action | Description |
|---|---|---|
| Record Management | Create Record | Creates a record corresponding to an object in Oracle NetSuite. For example, create a new record for the object: “purchaseOrder”. |
| Delete Record | Delete a record corresponding to an object in Oracle NetSuite. For example, delete a record for the object: “account”. | |
| Look up Record Details | Retrieves any type of record details from Oracle NetSuite. | |
| Update Record | Updates a record corresponding to an object in Oracle NetSuite. For example, update a record for the object: "purchaseOrder". | |
| Look up Record List Stream | Retrieves the list for a given record or object from Oracle NetSuite. For example, retrieve the list of all purchaseOrder(s). | |
| Metadata Retrieval | Get Objects (Metadata) | Retrieves the list of all records or objects from Oracle NetSuite. |
| Get Object Schema (Metadata) | Retrieves all schema or fields related data from Oracle NetSuite for a given object. |
Connection and credential alias requirements
Integration Hub uses aliases to manage connection and credential information, and OAuth credentials. Using an alias eliminates the need to configure multiple credentials and connection information profiles when using multiple environments. If the connection or credential information changes, you don't need to update any actions that use the connection.
For information about setting up the spoke, see Set up Oracle NetSuite Spoke.