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.