您位於此處：
執行 SOQL 查詢的範例要求與回應
此範例要求是使用 Data 360 驗證權杖 (dataCloudAuthToken) 和從範例 Exchange 存取權杖 (Data 360 權杖要求和回應) 取得的 instance_url 來提取所需資料的查詢。
針對此範例,所需值是從 Data 360 權杖要求與回應的 範例交換存取權杖取得。
範例要求
curl --location 'https://your_instance_url/api/v2/query' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer dataCloudAuthToken' \
--data '{
"sql": "SELECT ssot__Id__c, ssot__CreatedById__c, ssot__CreatedDate__c, ssot__DataSourceId__c, ssot__DataSourceObjectId__c, ssot__EndDateTime__c, ssot__ExternalRecordId__c, KQ_Id__c, ssot__LastModifiedById__c, ssot__LastModifiedDate__c FROM ssot__Conversation__dlm",
"limit": 2,
"offset": 0
}'範例回應
{
"data": [
[
"0dwLT0000002uyzYAA",
"005LT0000007SQzYAM",
"2024-03-22 05:47:10.000 UTC",
"Salesforce_00DLT0000009MKf",
"Conversation",
null,
"ac6390e6-a63e-452a-a6f3-d5a07ddf97e5",
null,
"005LT0000007SQzYAM",
"2024-03-22 10:47:39.000 UTC"
],
[
"0dwLT0000002vztYAA",
"005LT0000007SQzYAM",
"2024-04-25 09:46:47.000 UTC",
"Salesforce_00DLT0000009MKf",
"Conversation",
null,
"7d76c5e5-c363-4a20-b1d5-2b3a44568416",
null,
"005LT0000007SQzYAM",
"2024-04-26 22:11:06.000 UTC"
]
],
"startTime": "2024-05-01T21:55:35.896553Z",
"endTime": "2024-05-01T21:56:06.02948Z",
"rowCount": 2,
"queryId": "20240501_215536_24297_pq7pn",
"nextBatchId": "f84434bf-6cd5-42f1-bfed-cdd58052254a",
"done": false,
"metadata": {
"ssot__CreatedDate__c": {
"type": "TIMESTAMP WITH TIME ZONE",
"placeInOrder": 2,
"typeCode": 2014
},
"ssot__CreatedById__c": {
"type": "VARCHAR",
"placeInOrder": 1,
"typeCode": 12
},
"ssot__EndDateTime__c": {
"type": "TIMESTAMP WITH TIME ZONE",
"placeInOrder": 5,
"typeCode": 2014
},
"ssot__ExternalRecordId__c": {
"type": "VARCHAR",
"placeInOrder": 6,
"typeCode": 12
},
"ssot__LastModifiedById__c": {
"type": "VARCHAR",
"placeInOrder": 8,
"typeCode": 12
},
"ssot__Id__c": {
"type": "VARCHAR",
"placeInOrder": 0,
"typeCode": 12
},
"ssot__DataSourceObjectId__c": {
"type": "VARCHAR",
"placeInOrder": 4,
"typeCode": 12
},
"ssot__LastModifiedDate__c": {
"type": "TIMESTAMP WITH TIME ZONE",
"placeInOrder": 9,
"typeCode": 2014
},
"ssot__DataSourceId__c": {
"type": "VARCHAR",
"placeInOrder": 3,
"typeCode": 12
},
"KQ_Id__c": {
"type": "VARCHAR",
"placeInOrder": 7,
"typeCode": 12
}
}
}另請參照：
此文章是否解決您的問題？
請讓我們知道，以便我們改進！
