Forum Discussion

Mike Jansen's avatar
Mike Jansen
Iron Contributor
Mar 21, 2017
Solved

Rest api search query --- Lookup field issue

I have a document library which has a custom field "Label" this Label field is a lookup field (to a list) multiple values allowed. For example my documentlibrary:   Title          Label doc1      ...
apis
developer
Extensibility
  • Luis Mañez's avatar
    Luis Mañez
    Mar 22, 2017
    Haven't tested it, but it should work with the $filter:

    /_api/web/lists/GetByTitle('Documents')/items?$select=*,Label/Title&$expand=Label&$filter=Label/Title eq 'labelX'

    Let us know how it goes.
Brent Ellis's avatar
Brent Ellis
Silver Contributor
Mar 21, 2017
Mike, don't have a ready of example of this, but you may have to "expand" it to get the Label text. By default, all you see is the ID.

For example, getting "more" fields for a user field is done like this:
<site>/_api/web/Lists(guid'<LIST ID>')/Items?$expand=PERSONFIELD&$select=*,PERSONFIELD/EMail
  • Mike Jansen's avatar
    Mike Jansen
    Iron Contributor
    Mar 21, 2017

    Hi Brent Ellis

     

    Great!! This works:

    https://blabla.sharepoint.com/sites/mike/label/_api/web/lists/getByTitle('Documents')/items?$expand=Label&$select=*,Label/Title

    But now I need to get it to the next level. I want to filter on "LabelX"

     

     

    Something like this:

    https://blabla.sharepoint.com/sites/mike/label/_api/web/lists/getByTitle('Documents')/items?$expand=Label&$select=*,Label/Title&refinementfilters='Label/Title eq ('labelX')

     

    Any suggestions?

    • Luis Mañez's avatar
      Luis Mañez
      MVP
      Mar 22, 2017
      Haven't tested it, but it should work with the $filter:

      /_api/web/lists/GetByTitle('Documents')/items?$select=*,Label/Title&$expand=Label&$filter=Label/Title eq 'labelX'

      Let us know how it goes.
      • Mike Jansen's avatar
        Mike Jansen
        Iron Contributor
        Mar 22, 2017

        Hi Luis Mañez, and Brent Ellis,

         

        Thank you both!! Found the solution.

        Now make it some more dynamic but I can manage that.

         

        For your information, this is my query:

         

         

        https://blabla.sharepoint.com/sites/mike/label/_api/web/lists/getByTitle('Documents')/items?$select=*,Label/Title&$expand=Label&$filter=Label/Title eq 'labelX'&rowlimit=500

         

Resources