POST /api/v2/query

Use this API to query the Salesforce CDP data lake across data model, lake, unified, and linked objects.

Syntax

HTTP method
POST
Availability
Salesforce CDP v2.0, Salesforce 54.0
Formats
REST
URI
/api/v2/query

Examples

Request
1{
2    "sql": "select * from ssot__WebsiteEngagement__dlm order by 1 asc"
3}
Response
1{
2"data": [
3[
4"1103658353",
5"123",
6"1989-04-01 00:00:00.000 UTC",
7
8
9], [], [] ...
10]
11],
12"startTime": "2021-10-06T13:36:30.33265Z",
13"endTime": "2021-10-06T13:36:32.81927Z",
14"rowCount": 255,
15"queryId": "20211006_133630_00059_9adm3",
16"nextBatchId": "09151b49-54ed-4948-8139-1f4c7c3a9581",
17"done": false,
18"metadata": {
19"ssot__EngagementAssetId__c": {
20"type": "VARCHAR",
21"placeInOrder": 17,
22"typeCode": 12
23},
24"ssot__TaskId__c": {
25"type": "VARCHAR",
26"placeInOrder": 45,
27"typeCode": 12
28},
29"ssot__EngagementDateTm__c": {
30"type": "TIMESTAMP WITH TIME ZONE",
31"placeInOrder": 21,
32"typeCode": 93
33}
34}
35}