Logo
Salesforce Developers API Documentation

Query

POST https://{{dne_cdpOffcoreUrl}}/api/v1/query

Use this API to query the Customer 360 Audiences data lake across data model, lake, unified, and linked objects.

https://developer.salesforce.com/docs/atlas.en-us.c360a_api.meta/c360a_api/c360a_api_query.htm

 

Body PARAM

Key Datatype Required Description 



HEADERS

Key Datatype Required Description 
Content-Type
string




RESPONSES

status OK

{ "data": [ { "ssot__DataSourceId__c": "POS", "ssot__DataSourceObjectId__c": "storage_direct_20210310-061836_84278f03-3d5d-4c14-bedc-feca7bfbdfb2", "ssot__InternalOrganizationId__c": "", "ssot__PurchaseOrderDate__c": "2021-02-28T00:00:00.000+00:00", "ssot__Id__c": "InStore_018", "ssot__SoldToCustomerId__c": "A001" }, { "ssot__DataSourceId__c": "POS", "ssot__DataSourceObjectId__c": "storage_direct_20210310-061836_84278f03-3d5d-4c14-bedc-feca7bfbdfb2", "ssot__InternalOrganizationId__c": "", "ssot__PurchaseOrderDate__c": "2021-02-26T00:00:00.000+00:00", "ssot__Id__c": "InStore_002", "ssot__SoldToCustomerId__c": "A001" }, { "ssot__DataSourceId__c": "POS", "ssot__DataSourceObjectId__c": "storage_direct_20210310-061836_84278f03-3d5d-4c14-bedc-feca7bfbdfb2", "ssot__InternalOrganizationId__c": "", "ssot__PurchaseOrderDate__c": "2021-02-28T00:00:00.000+00:00", "ssot__Id__c": "InStore_014", "ssot__SoldToCustomerId__c": "A001" } ], "startTime": "2021-09-08T14:59:39.120024Z", "endTime": "2021-09-08T14:59:41.71155Z", "rowCount": 3, "queryId": "08be2ddc-4a1d-4a4b-8fa8-efce1acf1b83", "done": true, "metadata": { "ssot__PurchaseOrderDate__c": { "type": "TIMESTAMP", "placeInOrder": 3, "typeCode": 93 }, "ssot__InternalOrganizationId__c": { "type": "VARCHAR", "placeInOrder": 2, "typeCode": 12 }, "ssot__SoldToCustomerId__c": { "type": "VARCHAR", "placeInOrder": 5, "typeCode": 12 }, "ssot__DataSourceObjectId__c": { "type": "VARCHAR", "placeInOrder": 1, "typeCode": 12 }, "ssot__Id__c": { "type": "VARCHAR", "placeInOrder": 4, "typeCode": 12 }, "ssot__DataSourceId__c": { "type": "VARCHAR", "placeInOrder": 0, "typeCode": 12 } } }



Curl
curl -X POST 'https:///api/v1/query' -H 'Content-Type: application/json' -d '{"sql":"SELECT ssot__DataSourceId__c, ssot__DataSourceObjectId__c, ssot__InternalOrganizationId__c, ssot__PurchaseOrderDate__c, ssot__Id__c, ssot__SoldToCustomerId__c FROM ssot__SalesOrder__dlm WHERE ssot__SoldToCustomerId__c = 'A001' "}'

ENDPOINTS