Table of Contents

Connections

Commands

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

Get all records for record types that cannot be searched.

Inputs

Input

Type

Detail

Notes

Record Type

TextField

The type of record

Outputs

Output

Output Type

Notes

Records

File

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

Did this answer your question?