Data Cloud Query

Synchronously query data across data model, lake, unified, and linked objects. This query returns up to 4,999 rows.

A newer version of the Query API is available. We recommend using Query V2 API to take advantage of GET calls in addition to POST calls, subsequent requests, and larger response sizes.

Note

Resource

Available version

52.0

Requires Chatter

HTTP methods

POST

Request body for POST

Root XML tag

<cdpQueryTag>

JSON example

Properties

Name	Type	Description	Required or Optional	Available Version
`sql`	String	ANSI-standard SQL query.	Required	52.0

Request parameters for POST

Parameter Name	Type	Description	Required or Optional	Available Version
`batchSize`	Integer	Number of records to return. Values are from 1–4999. The default value is 4999.	Optional	53.0
`offset`	Integer	Number of rows to skip before returning results. The sum of `offset` and `batchSize` must be less than 2147483647. The default value is 0.	Optional	53.0
`orderby`	String	Comma-separated values to sort the results in ascending or descending order, for example, `GenderId__c ASC,Occupation__c DESC`.	Optional	53.0

Response body for POST

Data Cloud Query Output

Connect REST API Developer Guide

Data Cloud Query