Problem retrieving crawled column with the Graph API

Question

I am unable to retrieve a crawled column named Target (mapped to the managed property RefinableString107) from a SharePoint list using the Microsoft Graph API. Despite following the documentation and community guidance, the column values do not appear in API responses.

url = f"https://graph.microsoft.com/v1.0/sites/" + {site_id} + "/lists/" + {list_id} + "/items?$expand=fields($select=RefinableString107,Target,OWS_Target,CRB_Contact,CRB_ClientsandCompaniesTax)"
docs = requests.get(ur, headers=headers).json()

In the selected fields I put:

• The internal name of the column: Target
• The managed property name: RefinableString107
• The mapped crawled property name : OWS_TARGET
• Other columns: CRB_Contact,CRB_ClientsandCompaniesTax

Results:

• I can only retrieve the values for CRB_Contact and CRB_ClientsandCompaniesTax.
• No errors are returned—the fields are simply omitted or empty.

Request: Please clarify:

1. Are crawled/managed properties like RefinableString107 retrievable via Microsoft Graph API?
2. If yes, what is the correct method to access them?

Thanks in advance for your help !

Answer 1

Hi @Fariss, Meryem,

As per my knowledge, crawled and managed properties, such as RefinableString107, are primarily used in SharePoint search scenarios and cannot be directly retrievable via the Microsoft Graph API.

he Graph API typically interacts with SharePoint lists and their fields using internal names rather than managed properties or crawled properties.

---

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.