none
OData query problem... RRS feed

  • Question

  • Hi

    I'm trying to extract projects with does not have the number 88 (which is a text value) in the Project Priority field but am getting an error.

    https://xxx.sharepoint.com/sites/pwa/_api/ProjectData/Projects()?$filter=ProjectPriority ne %2288%22

    The field heading Project Priority so correct.  I've tried adding double quotes, apostrophes or nothing around 88 but still get an error.  Any thoughts on where I'm going wrong.

    Many thanks

    James

     



    • Edited by JamesP435 Tuesday, June 13, 2017 4:08 AM
    Tuesday, June 13, 2017 4:08 AM

Answers

  • For anyone interested I got it to work using:

    https://xxx.sharepoint.com/sites/pwa/_api/ProjectData/Projects/?$filter=ProjectPriority eq '88'

    I had tried this previously using Excel but it didn't work.  I found pasting into the IE url helpful.  And now sure why it should work in Excel afterwards... hey ho the delights of using oData



    • Edited by JamesP435 Tuesday, June 13, 2017 11:00 AM
    • Marked as answer by JamesP435 Tuesday, June 13, 2017 11:00 AM
    Tuesday, June 13, 2017 10:59 AM