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. This integration is facilitated through preconfigured actions, subflows, connection and credential aliases, and scripted REST APIs, streamlining Oracle NetSuite record management within ServiceNow workflows.
Show less
This spoke requires an active Integration Hub subscription and depends on specific ServiceNow plugins to function correctly. It is designed primarily for Oracle NetSuite API version 1.0 but may support later versions.
Key Features
- Record Management Actions: Includes actions for creating, deleting, updating, and looking up record details in Oracle NetSuite. For example, creating purchase orders or deleting accounts.
- Metadata Retrieval: Actions to retrieve lists of Oracle NetSuite objects and their schemas, helping you understand and utilize available data structures.
- Sample Subflows: Provides example subflows such as "Get Record Details (Inbound)" for retrieving and logging record data, and "Create Purchase Order (Outbound)" for creating records with inputs formatted per API requirements. These can be customized by copying to a new application scope.
- Connection and Credential Aliases: Uses aliases to manage connection and OAuth credential information, simplifying management across multiple environments without needing to update individual actions if connection details change.
Key Outcomes
- Seamlessly integrate Oracle NetSuite record operations into ServiceNow workflows, improving automation efficiency.
- Reduce manual data entry and synchronization errors by automating Oracle NetSuite CRUD operations.
- Leverage prebuilt actions and subflows to quickly deploy integration use cases or customize them to fit specific business needs.
- Maintain secure and manageable connections through centralized aliases, supporting flexible environment configurations.
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 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.