NetSuite Operation

Note: Before working with a Connector operation, you should be familiar with general Process development, building Connectors and the XML profile.

The NetSuite operation defines how to interact with your NetSuite account. The operation represents a specific action (e.g., Add, Modify, Query or Delete) to be performed against a specific NetSuite record type or object (e.g., Purchase Order, Item Receipt, Customer, etc.). Not all actions are available for every object. You must create a separate operation component for each action/object combination required for your integration.

Note: Contact your NetSuite Representative to learn about the API requirements for your account and how to access the integration guides in the user community for field definitions.

Options Tab

Available Actions: Depending on how you create the NetSuite operation component, the Action type is either non-configurable or selectable from the drop-down list. The actions listed below describe the different settings that can be configured for each type.

[ GET ] [ SEARCH ] [ INITIALIZE ] [ ADD ] [ UPDATE ] [ DELETE ] [ ATTACH ] [ DETACH ]

Import Wizard: The Import Wizard steps instruct you how to define the object you are integrating with based on the action you specified. It is required that you click the Import button and follow the wizard to successfully configure an operation and automatically generate the Response XML Profile that can include all required base and custom fields.

Select or Create the NetSuite Connection component and click Next.
Select the desired Object Type from the drop-down.
Select the desired Action from the drop-down and click Next.
Review results and click Finish.

Standard Fields: This table describes the default field definitions for each action type.

Field Name	Description
Object	Defines the object that you want to integrate with which was selected in the Import Wizard.
Action	Defines the action that will be performed against the defined object which was selected in the Import Wizard.
Request/Response Profile	The XML Profile definition that represents the XML structure that is being sent or received by the Connector.
Version	Identifies the Netsuite API version being used. When running the Import Wizard, Dell Boomi AtomSphere will use the Netsuite version defined in the Netsuite connection component to build the operation.

Inbound Actions

This section describes how the NetSuite operation can be configured to retrieve document records from a NetSuite account instance. For all inbound operations, unique parameters are required at run-time to request data. Review the Setting Parameters section to understand how these parameter values can be statically or dynamically defined in a Process for run-time.

GET

The GET action will allow AtomSphere to look up data based on the NetSuite Internal ID. The NetSuite internalID is a key column that uniquely identifies a row of data. It also links that data record to corresponding records across objects. More NetSuite object types are retrievable using the GET action when compared to the QUERY action. Supplying one internal ID will return one object record document.

Note: If your integration scenario requires you to retrieve records dynamically with a GET ID, then consider performing a SEARCH to retrieve a list of IDs that can be used as a dynamic input parameter for the GET operation.

SEARCH

The SEARCH action allows AtomSphere to look up object records based on specific search criteria. This action requires you to supply static or dynamic request parameters aka filters to control the object records being selected. Zero to many object record documents can be returned from a single QUERY request.

Search Configuration

After completing the Import Wizard:

Highlight the Object node in the lower left window.
Click the icon to the left of Filter and Choose 'Add Logical Sub-Group'.
Highlight the 'Logical - AND' node (default operator) and Click the icon to the left of it to 'Add Expression'.
Highlight the Expression node to show the Filter Options.
Continue adding Expressions under the 'Logical - AND' node to define one or more filters.

Include List Fields?
This check box allows the operation to control the return of any list detail records that are associated with the object being searched. Clearing the check box will retrieve only the base data for the object. For example, if you are searching for Customer records and want to include the Contact List, then you would want to check Include List Fields?.

Filter Options

Field Name	Description
Filter name	Reference Name for expression. Common practice is to define the selected field name and associated operator (e.g., CompanyNameIs).
Field	Selectable name that references the Netsuite fields available for search filters.
Operator	Used to define how request input parameter should be compared against the filter (e.g. = , != , >)

INITIALIZE

The INITIALIZE action allows AtomSphere to more easily build outbound Netsuite transactions based on values from a related object record. For example, initializing an invoice by referencing an existing sales order transaction.

The Initialize Reference Type dropdown controls the object record type that is used for building the "initialized" response.

Outbound Actions

This section describes how the NetSuite operation can be configured to send data to a Netsuite account instance. For all outbound operations, request XML data needs to be sent into the Connector that corresponds with the defined XML Profile. In most cases, request documents are the destination output of a Data Map. However, you can also set parameters on the outbound Connector's Parameter tab within the Process to supply static or dynamic request values.

Return Application Error Responses
This check box is available for all Send Netsuite connector actions. If checked, failed operations will not be reported on the Manage manu and the Netsuite responses can be forwarded through the Process flow as a documents.

ADD

The ADD action will allow you to insert data into your NetSuite account. The internal 'ID' field is generated automatically per each request sent to the operation. Upon successful record creation, the operation automatically returns an XML response with the newly generated internal ID.

UPDATE

The UPDATE action allows you to update existing data within your NetSuite account. You must supply the internalID or externalID field in the request to update the existing object record.

Note: If the IDs are not readily available in your source data, consider using a Connector Call function to SEARCH data based on a field value such as CompanyName.

DELETE

The DELETE action allows you to delete existing data within your NetSuite account. You must supply the internalID or externalID field in the request to delete the existing object record.

Note: If the IDs are not readily available in your source data, consider using a Connector Call function to SEARCH data based on a field value such as CompanyName.

ATTACH

The ATTACH action allows you to define a relationship between two records or attach an actual file document. You must supply the internal ID and record types when building the request.

The Attached Record Type drop-down identifies the objects that you can link or the possibility of attaching a file.

DETACH

The DETACH action allows you to remove a relationship between two records or detach an actual file document. You must supply the internal ID and record types when building the request.

The Attached Record Type drop-down identifies the objects or file that you can detach.

Archiving Tab

Click here for more information on Archiving.