Help Desk

Submit a ticket My Tickets
Welcome
Login

NetSuite Command Reference

This BizApp provides functionality to interact with the data inside NetSuite, including getting the data from saved searches, querying for records, updating records, and various other functions.

Connections

NetSuite Token Authentication

Credentials for the BizApp to use. This connection relies on an Integration being built in NetSuite, as well as an Access Token that is also created in NetSuite.

Inputs

Input Type Detail Notes
Account ID TextField The Account ID. You can find this at Setup -> Integration -> Web Services Preferences in NetSuite
Consumer Key TextField The Consumer Key of the Integration in NetSuite. If you don't have the key, you can edit the Integration and reset the credentials.
Consumer Secret TextField The Consumer Secret of the Integration in NetSuite. If you don't have the secret, you can edit the Integration and reset the credentials.
Token ID TextField The Token ID of the access token in NetSuite. If you don't have the id, you must create a new access token.
Token Secret TextField The Token Secret of the access token in NetSuite. If you don't have the secret, you must create a new access token.
Sandbox BooleanField If the NetSuite environment you want to connect to is a sandbox account, you must check this.

Commands

Get File

Download a file from the file cabinet.

Inputs

Input Type Detail Notes
Internal ID TextField The internal id of the File

Outputs

Output Output Type Notes
File File
File size Integer

Exit Codes

Code Type Detail
0 Success Success
1 Error Invalid inputs
2 Error Authentication with NetSuite failed
3 Error There was a problem running the command
50 Error NetSuite returned an error when trying to run this command

Get Saved Search Data

Get the data from a Saved Search. NOTE: The NetSuite API does not support getting data from a saved search that contains summary results.

Inputs

Input Type Detail Notes
Search Type DropdownField The type of the saved search. (e.g. Transaction, Account, etc.)
Search ID TextField The internal id of the Saved Search
Data Format DropdownField The output data format

Outputs

Output Output Type Notes
Error Code String
Search Data File
Record Count Integer

Exit Codes

Code Type Detail
0 Success Success
1 Error Invalid inputs
2 Error Authentication with NetSuite failed
3 Error There was a problem running the command
50 Error NetSuite returned an error when trying to run this command
51 Error Invalid search paramaters
54 Error No records were found
55 Error The search failed

Get Standard Record Data

Get the JSON data for a standard record.

Inputs

Input Type Detail Notes
Record Type DropdownField The type of the record. (e.g. Transaction, Account, etc.)
Internal ID TextField The internal id of the record

Outputs

Output Output Type Notes
Record Json

Exit Codes

Code Type Detail
0 Success Success
1 Error Invalid inputs
2 Error Authentication with NetSuite failed
3 Error There was a problem running the command
50 Error NetSuite returned an error when trying to run this command

List Saved Searches

For a given search type, list the available saved searches.

Inputs

Input Type Detail Notes
Search Type DropdownField The type of the search. (e.g. Transaction, Account, etc.)

Outputs

None

Exit Codes

Code Type Detail
0 Success Success
1 Error Invalid inputs
2 Error Authentication with NetSuite failed
3 Error There was a problem running the command
50 Error NetSuite returned an error when trying to run this command
B
Brian is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.