SuiteQL

SuiteQL is a query language based on the SQL-92 revision of the SQL database query language. It provides advanced query capabilities you can use to access your NetSuite records and data, and it supports querying the analytics data source. For more information, see Analytics Data Source Overview.

SuiteQL is currently available using SuiteAnalytics Connect, the N/query module in SuiteScript, and SuiteTalk REST web services. For more information, see Using SuiteQL.

Some benefits of using SuiteQL include the following:

• Support for the analytics data source: SuiteQL lets you query the analytics data source. This data source enhances the capabilities of querying your NetSuite data. The exposed data is consistent with SuiteAnalytics Workbook, which resolves previous data exposure inconsistencies in saved searches and reports. For more information, see Analytics Data Source Overview.

• Improved security: SuiteQL enforces the same role-based access restrictions used in SuiteAnalytics Workbook. This approach means that SuiteQL lets you query the same data you can access in the SuiteAnalytics Workbook user interface, which helps to increase security. SuiteQL also includes a list of supported SQL functions and does not allow you to use unsupported SQL functions in your query, which prevents SQL injection.

SuiteQL supports the syntax for both SQL-92 and Oracle SQL. However, you cannot use both syntaxes in the same query.

To help you understand how to use SuiteQL, see the following help topics:

• Using SuiteQL

• SuiteQL Join Types

• SuiteQL Syntax and Examples

• SuiteQL Limitations and Exceptions

• SuiteQL Supported and Unsupported Functions

• SuiteQL Supported Built-in Functions

Related Topics

Analytics Data Source Overview

The Analytics Data Source and SuiteAnalytics Workbook

General Notices