How to apply multiple filter in Odata query?

[sharathnasa]

Hi All,

I'm trying to apply multiple query in a single query as shown below. But i'm not getting the correct syntax on how to apply.

https://my338727.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/LeadCollection?$filter=ID eq '149301'&$filter=OwnerPartyID eq '149301'

If anyone knows the correct syntax on how apply this, please let me know.

Regards,

sharath

[DebashishDas]

You don't need to use $filter every time.Use 'and' for multiple parameter.

[former_member226]

Hi,

You can do the filtering for multiple parameter using following:

https://my3XXXXX.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/LeadCollection?$filter=ID eq '25139' and OwnerPartyID eq '8000000000'

Thanks

Saurabh

[bnienhaus]

Hi Sharath,

I believe this question has already been answered here (among others)

In general, OData requires that you pass multiple arguments in one filter using operators like "and" / "or".

Please check the forum for similar questions prior to posting.

Best Regards,

Brian

[sharathnasa]

Hi Brain,

Prior to posting i had already check the post link which you have shared. That question is more about single filter value with multiple values. Not with multiple filters.

Regards,

Sharath