To interact with the data inside NetSuite® as part of a chain, add a step that includes a NetSuite connection command. For example:
- Retrieve files
- Retrieve saved searches or data from a saved search
- Retrieve JSON data for a standard record
- Search for records by type or ID
Note: After you retrieve this data, you can transfer it to other systems via standard tabular format.
To enable these commands, an IT admin first creates a NetSuite Token Authentication connector.
Get file
To download a file from the file cabinet, add a Get File command.
Properties
| Property | Detail |
|---|---|
| Internal ID | Enter the internal ID of the file to download. |
Outputs
| Output | Output type |
|---|---|
| File | File |
| File size | Integer |
Exit codes
| Code | Type | Detail |
|---|---|---|
| 0 | Success | Success |
| 1 | Error | Invalid input |
| 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
To retrieve the data from a saved search, add a Get Saved Search Data command.
Note: The NetSuite API doesn't support getting data from a saved search that contains summary results.
Properties
| Property | Detail |
|---|---|
| Search type | Select the type of the saved search data to retrieve, such as Transaction or Account. |
| Search ID | Enter the internal ID of the saved search. |
| Data format | Select the output data format. |
| Concurrency | Enter how many pages of data to retrieve at the same time. |
Outputs
| Output | Output type |
|---|---|
| File | File |
| Error code | String |
| Search data | File |
| Record count | Integer |
Exit codes
| Code | Type | Detail |
|---|---|---|
| 0 | Success | Success |
| 1 | Error | Invalid input |
| 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 parameters |
| 54 | Error | No records found |
| 55 | Error | Search failed |
Get standard record data
To retrieve the JSON data for a standard record, add a Get Standard Record Data command.
Properties
| Property | Detail |
|---|---|
| Record type | Select the type of the record data to retrieve, such as Transaction or Account. |
| Internal ID | Enter the internal ID of the record. |
Outputs
| Output | Output type |
|---|---|
| File | File |
| Error code | String |
| Record | JSON |
Exit codes
| Code | Type | Detail |
|---|---|---|
| 0 | Success | Success |
| 1 | Error | Invalid input |
| 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
To list the available saved searches for a given search type, add a List Saved Searches command.
Properties
| Property | Detail |
|---|---|
| Search type | Select the type of saved searches to list, such as Transaction or Account. |
Outputs
None
Exit codes
| Code | Type | Detail |
|---|---|---|
| 0 | Success | Success |
| 1 | Error | Invalid input |
| 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
To search for a record by type or ID, add a Search Records command.
Tip: To replicate NetSuite's Saved Search feature, use this command with the Get Saved Search Data command.
Properties
| Property | Detail |
|---|---|
| Record type | Select the type of record to search for, such as Transaction or Account. |
| Data format | Select the format of the output data. |
| Search IDs | To search for the record by ID, enter the IDs to match. |
Outputs
| Output | Output type |
|---|---|
| Error code | String |
| Search data | File |
| Record count | Integer |
Exit codes
| Code | Type | Detail |
|---|---|---|
| 0 | Success | Success |
| 1 | Error | Invalid input |
| 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 parameters |
| 54 | Error | No records were found |
| 55 | Error | The search failed |