Record Filtering and Query

The query operation is used to execute a query on a specific record type based on a set of criteria.

Record query only returns record IDs and HATEOAS links. That is, query results have a form of non-expanded references. Additionally, you can only use body fields in query conditions. Saved queries, multilevel joins, and sublist and subrecord queries are not supported.

REST web services only supports limited record query. Joins are not supported.

For more information, see the following topics:

• Listing All Record Instances

• Record Collection Filtering

• Executing SuiteQL Queries Through REST Web Services

• Working with SuiteAnalytics Datasets in REST Web Services

• Collection Paging

Related Topics

• SuiteTalk REST Web Services Overview and Setup
• Authentication and Session Management for REST Web Services
• REST Web Services Request Processing
• Working with REST Web Services Using Postman
• Working with Resource Metadata
• Working with Records
• Working with Sublists
• Working with Subrecords
• Error Handling and Logging in REST Web Services

General Notices