To query NetSuite® Datasets as part of a chain, add a step that includes a NetSuite Analytics command.
List Datasets
To retrieve a list of available datasets from NetSuite, add a List Datasets command.
Outputs
| Output |
Output type |
| Datasets |
File (JSON array) |
| Exit Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
General failure |
Execute Dataset
To run a dataset and retrieve its data, add an Execute Dataset command.
Properties
| Property |
Detail |
| Dataset ID |
Enter the Dataset ID to execute.
Note: To find the ID in NetSuite, open the dataset and click the info icon next to the dataset name.
|
Outputs
| Output |
Output type |
| Records (JSON) |
File (JSON) |
| Records (CSV) |
File (CSV) |
| Exit Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
General failure |
Execute SuiteQL Query
To return a list of Netsuite records using SuiteQL, add an Execute SuiteQL Query command.
Note: NetSuite limits response to 1000 records. For larger datasets, you must add an ORDER BY clause to your query in NetSuite. Click here to learn more.
Properties
| Property |
Detail |
| SuiteQL Query |
Enter the SuiteQL query to execute.
|
Outputs
| Output |
Output type |
| Records (JSON) |
File (JSON array) |
| Records (CSV) |
File (CSV) |
| Exit Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
General failure |