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
Request Body
{"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' "}
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}}}