Hi,

What is wrong with this filter parameters 

https://<Sharepoint Server URL>/_api/Lists(guid'6DA2C173-3A59-435F-A1B8-B62567B9F146')/Items?$filter MonthYear eq Apr2015 and Status eq Approved and EmployeeCodeId eq 12

I think you should get columns first,

I mean try this way:

https://<Sharepoint Server URL>/_api/Lists(guid'6DA2C173-3A59-435F-A1B8-B62567B9F146')/Items?$select=MonthYear,Status,EmployeeCodeId&$filter MonthYear eq Apr2015 and Status eq Approved and EmployeeCodeId eq 12

First try with only one parameter and if getting result keep on increasing :)

This will not work as my URL gives correct result for 1 parameter alright. 

however when i write multiple parameters it does not filter on anything and returns all the records.

and No select is not required. 

Give it one more try:

https://[SiteUrl]/_api/web/lists/getbytitle('ListName')/items?$filter=(((MonthYear eq 'Apr2015') and  ([Status] eq 'Approved')) and ([EmployeeCodeId] eq '12'))

Refer: http://www.sharepointyammertech.com/2014/11/sharepoint-2013-rest-services-how-to.html

Hi Parth,

Any update?

Thanks

Still struggling with the same Issue. As of now i have kept the multiple filters in my c# Code (if else conditions) and created another Service Wrapper to access the records. 

Between, is queries on SharePoint Online is different then the queries on On Prem SharePoint ?

As Certain REST Queries which used to work on, OnPrem SharePoint does not work on SharePoint Online....