Back to Collection Items
var
http: TChilkatHttp;
success: Integer;
queryParams: TChilkatJsonObject;
resp: IChilkatHttpResponse;
begin
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
http := TChilkatHttp.Create(Self);
queryParams := TChilkatJsonObject.Create(Self);
queryParams.UpdateString('q','SELECT FIELDS(ALL) from EventLogFile ORDER BY LastModifiedDate DESC LIMIT 200');
// Adds the "Authorization: Bearer <access_token>" header.
http.AuthToken := '<access_token>';
http.SetRequestHeader('Content-Type','application/json');
resp := http.QuickRequestParams('GET','https://domain.com/services/data/v{{version}}/query/',queryParams.ControlInterface);
if (http.LastMethodSuccess = 0) then
begin
Memo1.Lines.Add(http.LastErrorText);
Exit;
end;
Memo1.Lines.Add(IntToStr(resp.StatusCode));
Memo1.Lines.Add(resp.BodyStr);
Curl Command
curl -G -d "q=SELECT%20FIELDS%28ALL%29%20from%20EventLogFile%20ORDER%20BY%20LastModifiedDate%20DESC%20LIMIT%20200"
-H "Authorization: Bearer <access_token>"
-H "Content-Type: application/json"
https://domain.com/services/data/v{{version}}/query/
Postman Collection Item JSON
{
"name": "Get event logs",
"request": {
"method": "GET",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"url": {
"raw": "{{_endpoint}}/services/data/v{{version}}/query/?q=SELECT+FIELDS(ALL)+from+EventLogFile+ORDER+BY+LastModifiedDate+DESC+LIMIT+200",
"host": [
"{{_endpoint}}"
],
"path": [
"services",
"data",
"v{{version}}",
"query",
""
],
"query": [
{
"key": "q",
"value": "SELECT+FIELDS(ALL)+from+EventLogFile+ORDER+BY+LastModifiedDate+DESC+LIMIT+200",
"description": "Gets the first 200 EventLogFile records ordered by most recently updated first."
}
]
},
"description": "Executes the specified SOQL query.\n\nIf the query results are too large, the response contains the first batch of results and a query identifier in the nextRecordsUrl field of the response. The identifier can be used in an additional request to retrieve the next batch.\nhttps://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/resources_query.htm"
},
"response": [
]
}