Get custom list columns from Microsoft Search API

Question

Hi,
I have a list which has a custom column named Issue. I'm using Microsoft Search API (https://learn.microsoft.com/en-us/graph/api/search-query?view=graph-rest-1.0) to search list items and I would like to get the value of this custom column for list items.
I have tried below queries but it is not returning the column
{
"requests": [
{
"entityTypes": [
"listItem"
],
"query": {
"queryString": "fix favorite"
},
"fields":[
"Issue"
]
}
]
}

{
"requests": [
{
"entityTypes": [
"listItem"
],
"query": {
"queryString": "fix favorite"
},
"fields":[
"label_Issue"
]
}
]
}

Can someone help me with this?

Answer 1

Hi @captain_atharv ,

Refer to specify select properties, with below sample snippet. I am able to get Title, WebUrl, Description properties which are requested in the Graph API.

POST https://graph.microsoft.com/v1.0/search/query  
{  
    "requests": [  
        {  
            "entityTypes": [  
                "listItem"  
            ],  
            "query": {  
                "queryString": "Issue 1"  
            },  
            "fields": [  
                "id",  
                "contentclass",  
                "title",  
                "webUrl",  
                "Description"  
            ]  
        }  
    ]  
}  

Here is my search result screenshot.

Fields that you are using fields should be from the crawled-and-managed-properties-overview.
Since Title, Description are already mapped as managed properties, I am able to fetch using Graph response.

If need to fetch any custom field which is not predefined crawled property, you need to add it to search schema, manage-search-schema.

Hope this helps.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Hello @captain_atharv

Thanks for reaching out!

I was able to reproduce this behavior. Initially, I was getting no data in Search Graph API response. However, I noticed that it took around 15 minutes to reflect the expected data in API response. Please refer below screenshots with request payload for better understanding.

Sample request payload:

{  
    "requests": [  
        {  
            "entityTypes": [  
                "listItem"  
            ],  
            "query": {  
                "queryString": "SSE"  
            },  
            "fields": [  
                "Designation"  
            ]  
        }  
    ]  
}  

SharePoint List-

Graph API response-

Hope this helps.

If the answer is helpful, please click Accept Answer and kindly upvote. If you have any further questions about this answer, please click Comment.