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 Deleted Records

Get deleted records from Netsuite. NOTE: Netsuite API does not support returning the context or the user which performed the deletion.

Inputs

Input Type Detail Notes
Predefined Date DropdownField A predefined date search, such as "last month"
Date Operator DropdownField The date operator
Start Date TextField The start date of the search, if not using a predefined date. Should be YYYY-MM-DD format.
End Date TextField The end date of the search, if not using a predefined date. Should be YYYY-MM-DD format.
Time Zone DropdownField The time zone of the dates, if not using a predefined date.
Record Types ArrayField The record types to filter on
Output Format DropdownField The output format of the results

Outputs

Output Output Type Notes
Error Code String
Deleted Records 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

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
Concurrency NumberField Use this setting to adjust how many pages will be retrieved for the search concurrently.

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

Search Records

Search for a record type with the option of filtering by the record's internal ID

Inputs

Input Type Detail Notes
Record Type DropdownField The record type to search. (e.g. Transaction, Account, etc.)
Data Format DropdownField The output data format
Search IDs ArrayField If specified, the search results will only return records that match any of the specified IDs
Concurrency NumberField Use this setting to adjust how many pages will be retrieved for the search concurrently.

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
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.