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 |