NetSuite

Provides integration into NetSuite via its SOAP API.

Revision History

2.0.0.3 Initial Release
2020.1.0.1 Updated signature method
2020.1.0.2 Updated signature algorithm
2020.1.0.3 Added MaxReceivedMessageSize on request

Properties

Connection

Type: Connection Input
The Connection Property

Url
Type: String
The location of your NetSuite, for example https://123456-sb1.suitetalk.api.netsuite.com

Account
Type: String
NetSuite account number. Note that for sandbox accounts, the account number should usually end with _SB1 (case sensitive and using an underscore rather than a dash) and should not be specified as -sb1 as may be assumed from the URL.

ConsumerKey
Type: Password
NetSuite consumer key

ConsumerSecret
Type: Password
NetSuite consumer secret

TokenId
Type: Password
NetSuite token ID

TokenSecret
Type: Password
NetSuite token secret

Operation

Type: String Input
The name of the operation to be performed. This will be set automatically when you load a Node Sample.

RecordType

Type: String Input
The type of record that will be used for the operation. This will be set automatically when you load a Node Sample.

Preferences

Type: String Input
Specifies preferences for handling the request. Although this Property will be set automatically when a Node Sample is loaded, it can be left blank unless the default preferences need to be customized.

Request

Type: String Input
The Request Property
The primary request payload for the operation. A sample of this document will be set automatically when you load a Node Sample. To prepare it for use, either hardcode values into the document or generate using QuickMap.

Response

Type: String Output
The result returned by NetSuite.

Custom Inputs

Loading certain Node Samples will cause Custom Input Properties to be added to the Node.

Remarks

This Node is a wrapper around the NetSuite SOAP API and makes it possible to interact with NetSuite without additional code. Refer to https://www.netsuite.com/portal/developers/resources/suitetalk-documentation.shtml for detail on the specific calls that are implemented.

When querying data from NetSuite, the Preferences value indicates the number of records to be returned in a page. In order to get the next page of data, one has to execute the "SearchMoreWithId" function of the NetSuite node, passing it the next page number, and the searchId returned by the initial call, as shown in the paging sample below.

MaxReceivedMessageSize will be set on the request and will be the same value as the Max Data Size on the Connection under the advanced properties.

Partial Fulfillments.

NetSuite will automatically fulfill the whole sales order when using the fulfillment operation. To achieve a partial fulfillment first perform an Initialize operation for a specific sales order. This will prepare the sales order and provide a unique line field for each line item.

These unique line ids will be use in the fulfillment operation and passed into the orderLine field.

Examples

See Sample Workflow for a set of examples.
See https://flowgear.me/#s/PE57vcr for an example of paging a result set.