Forum Discussion
Pulling Data from Custom Properties in the SharePoint Term Store to Power BI
Hi everyone, I have a SharePoint site with data stored in Term Sets in the Term Store linked to Managed Metadata fields in lists. I'm using functionality in the Custom Properties tab to store so...
I spotted your question while searching for a solution getting these properties in a SharePoint WebPart.
Following the Microsoft documentation for the SharePoint Rest API ( https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/use-odata-query-operations-in-sharepoint-rest-requests#select-fields-to-return ) in some cases "[...] these properties are not included in the default query, and must be explicitly requested".
For my SharePoint situation i was successfull with this url: https://[tenant-name].sharepoint.com/sites/[sitename]/_api/v2.1/termStore/termSets/[setId]/terms/[termid]?$SELECT=*,properties,localProperties
Maybe this helps you finding your solution.