Microsoft Graph Search API - $select fields of SharePoint Managed Property

Question

How am I able to select SharePoint Managed Property on the new Microsoft Search API?
Something as simple as:

{
    "requests": [
        {
            "entityTypes": [
                "driveItem"
            ],
            "query": {
                "queryString": "ContentTypeId:0x0120D520* AND *"
            },
            "from": 0,
            "size": 10,
            "fields": [
                "Title",
                "Path",
                "RefinableString01",
                "Description"
            ]
        }
    ]
}

Does not seem to be supported like in SharePoint Search API $select query.

Answer 1

Hi @Jonathan Aditya , according to my understanding of your needs, you are using the Microsoft Search API to query Microsoft 365 data in your apps.

Here is the docuemtation for your reference: https://learn.microsoft.com/en-us/graph/api/resources/search-api-overview?view=graph-rest-1.0

In the case of getting selected properties, you can include in the fields property specific entity properties, including custom managed properties from SharePoint and OneDrive.
And the query options are expressed in the POST body.

Here is a sample of request body, hope it will help you.

{  
  "requests": [  
    {  
      "entityTypes": [  
        "listItem"  
      ],  
      "query": {  
        "queryString": "contoso product"  
      },  
      "from": 0,  
      "size": 25,  
      "fields": [  
        "title",  
        "description"  
      ]  
    }  
  ]  
}  

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

@Zehui Yao_MSFT Now I get that I need to use
listItem
instead of
driveItem
.

I am now curious on why the search results within fields are lowercased by default and does not follow the correct managed property naming convention..

Answer 3

@Tong Zhang_MSFT
@Zehui Yao_MSFT

In fields we provide the column names which we want to receive in response.

But how can we get all columns in response? "*" is not working

{  
    "requests": [  
        {  
            "entityTypes": [  
                "listItem"  
            ],  
            "query": {  
                "queryString": "issue"  
            },  
            "fields": [  
                "*"  
            ]  
        }  
    ]  
}