How to get filtered sharepoint list item using REST API

Question

I am using REST Api to get sharepoint List items.

Now I am trying to retrieve all filtered list items where status is completed.

But i was getting 400 request error

I was fire query like below.

https://MySiteName/_api/lists/getbytitle('MyList')/items?$select=Title,ID,Status&$filter=Status eq 'Completed' 

Answer 1

Try this below code its working for me,

     /_api/web/lists/GetByTitle('Listname')/items?$select=Title,ID,Status$filter=Status eq 'Completed'


    /_api/Web/Lists(guid'GUID')/Items?$select=Title,ID,Status$filter=Status eq 'Completed'

Answer 2

I tested it, and in my environment it is working. SharePoint 2013 on-prem.

Listname:

MyList

Columns:

Title (by default included)

ID (by default included)

Status -> Dropdown -> Fieldvalues -> Open, Completed

After entering the query in browser I get:

As far as I understood here: https://msdn.microsoft.com/en-US/library/office/fp142380.aspx

It should not make a difference for your requirement. Snippet:

To access a specific site collection, use the following construction:

http://server/site/_api/site

To access a specific site, use the following construction:

http://server/site/_api/web

Answer 3

Finally i got solution i am passing in URL so URL never contain white space it so i change like this and its work for me

https://MySiteName/_api/lists/getbytitle('MyList')/items?$select=Title,ID,Status&$filter=Status+eq+'Completed' 

Answer 4

I think it needs to be

https://MySiteName/_api/web/lists/getbytitle('MyList')/items?$select=Title,ID,Status&$filter=Status eq 'Completed'

Answer 5

https://MySiteName/_api/lists/getbytitle('MyList')/items?$select=Title,ID,Status&$filter=Status eq 'Completed'

You missed 'web' before /lists/

https://MySiteName/_api/lists/getbytitle('MyList')/items?$select=Title,ID,Status&$filter=Status eq 'Completed'

Answer 6

/_api/web/lists/GetByTitle('Listname')/items?$select=Title,ID,Status$filter=Status eq 'Completed'

you should remove guid before '' like this:

/_api/Web/Lists('GUID')/Items?$select=Title,ID,Status$filter=Status eq 'Completed'

for example :

 /_api/web/lists('%7B326038AE-D47E-454D-AAD4-5440E6133EF2%7D')