Query Function
Query Function
Description
The Query function makes it easy to run ad-hoc SuiteQL queries against NetSuite. Data is returned as a dynamic array, which makes it seamless to integrate with Power Query for more advanced data modeling.
Function Arguments
| Argument Name | Input Information |
|---|---|
| Query | The SuiteQL query to execute |
| Omit Header (optional) | If TRUE, then the header row is omitted in the result |
| Skip (optional) | The number of rows to skip (must be a multiple of Take if specified) |
| Take (optional) | The number of rows to return. When omitted, it will return all results |
Remarks
The queries supported are those that are available over the SuiteTalk REST Web Services endpoint in NetSuite. Any table joins, filters, etc. must be specified in the query itself.
For more information on the SuiteQL syntax, please refer to the SuiteQL documentation (opens in new tab).