delphiAx / Microsoft Graph / Search list items with property selection
Back to Collection Items
var
http: TChilkatHttp;
success: Integer;
json: 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);
// Use this online tool to generate code from sample JSON: Generate Code to Create JSON
// The following JSON is sent in the request body.
// {
// "requests": [
// {
// "entityTypes": [
// "listItem"
// ],
// "query": {
// "queryString": "issue"
// },
// "fields": [
// "id",
// "name",
// "contentclass",
// "title",
// "fooCustomProperty"
// ]
// }
// ]
// }
json := TChilkatJsonObject.Create(Self);
json.UpdateString('requests[0].entityTypes[0]','listItem');
json.UpdateString('requests[0].query.queryString','issue');
json.UpdateString('requests[0].fields[0]','id');
json.UpdateString('requests[0].fields[1]','name');
json.UpdateString('requests[0].fields[2]','contentclass');
json.UpdateString('requests[0].fields[3]','title');
json.UpdateString('requests[0].fields[4]','fooCustomProperty');
// Adds the "Authorization: Bearer <access_token>" header.
http.AuthToken := '<access_token>';
http.SetRequestHeader('Content-Type','application/json');
resp := http.PostJson3('https://graph.microsoft.com/beta/search/query','application/json',json.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 -X POST
-H "Authorization: Bearer <access_token>"
-H "Content-Type: application/json"
-d '{
"requests": [
{
"entityTypes": [
"listItem"
],
"query": {
"queryString": "issue"
},
"fields": [
"id",
"name",
"contentclass",
"title",
"fooCustomProperty"
]
}
]
}'
https://graph.microsoft.com/beta/search/query
Postman Collection Item JSON
{
"name": "Search list items with property selection",
"request": {
"method": "POST",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"type": "text",
"value": "application/json"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"requests\": [\n {\n \"entityTypes\": [\n \"listItem\"\n ],\n \"query\": {\n \"queryString\": \"issue\"\n },\n \"fields\": [\n \"id\",\n \"name\", \n \"contentclass\",\n \"title\",\n \"fooCustomProperty\"\n ]\n }\n ]\n}"
},
"url": {
"raw": "https://graph.microsoft.com/beta/search/query",
"protocol": "https",
"host": [
"graph",
"microsoft",
"com"
],
"path": [
"beta",
"search",
"query"
]
}
},
"response": [
]
}