Forum Discussion

Joel Rodrigues's avatar
Joel Rodrigues
MVP
Oct 18, 2017
Solved

REST API bug when retrieving managed metadata list field configured to allow single values?

Hi everyone,   Any suggestion on this problem would be much appreciated. I'm trying to load all the items from a list that contains some managed metadata fields using the REST api. The API return...
  • Andrew Koltyakov's avatar
    Andrew Koltyakov
    Oct 18, 2017

    Hi Joel,

     

    This is a well-known issue since 2013.

    Single-valued MMD columns just can be retrieved as desired with OData, with Multi-valued MMD columns it is much better.

     

    But there is a workaround. There is a possibility of getting single-valued MMD columns' values while items request if do it with `getItemsByCAMLQuery` list's method. It's a part of REST API, is an implementation for backward compatibility. The downside of the approach is that OData configurators like ($select, $filter, $expand and so on) can't be used together with OData.

     

    --

    Regards,

    Andrew

Joel Rodrigues's avatar
Joel Rodrigues
MVP
Oct 18, 2017

I have now gave up and used JSOM to load the data...although I would still like to hear suggestions if you have come across this scenario before.

 

In case you are working with SPFx web parts and need to use JSOM for some reason (REST is the recommended approach and I trust everyone will understand why), this article provides excellent guidance on how to quickly setup everything and get started

https://docs.microsoft.com/en-us/sharepoint/dev/spfx/web-parts/guidance/connect-to-sharepoint-using-jsom 

 

Joel

Resources