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