Question Re: IN operator in odata get query in Technology Q&A

IN operator in odata get query

former_member717479 — Tue, 09 Mar 2021 16:40:35 GMT

Hi SAP,

I am trying to create an OData query with IN operator as it is mentioned in the sap help center that ODATA v2 adapter now supports IN operator in filter. Link to the sap help center: https://help.sap.com/viewer/368c481cd6954bdfa5d0435479fd4eaf/Cloud/en-US/c5c2e38e0c87472e996dfda04920bfc4.html

I want to get the same result of the below query which uses eq with or operator, but I want to use IN operator

$select=OrderID,CustomerID,OrderDate&$filter=OrderID eq 10248 or OrderID eq 10249

The query which I created is with IN operator is below but its not working.

$select=OrderID,CustomerID,OrderDate&$filter=OrderID in 10248,10249

I am getting error in CPI is (Fault:Sequential processing failed for number 0)

Please let me know if I am missing something in the query.

Thanks

Anuja

Re: IN operator in odata get query

tobias_breyer — Wed, 10 Mar 2021 08:06:58 GMT

Hi Anuja,

have you tried putting the IDs into brackets so that it is "OrderID IN (10248,10249)"?

I can't find OData standard docu on the topic, but I have seen several examples of the IN-clause in that way. Note that OData is "SQL for the Web", so sometimes the syntax and requirements are like in SQL. Also there, the IN clause uses brackets - otherwise it is difficult to parse a query in an appropriate way.

However, if this is an issue of the CPI OData Adapter, then please use the tag

https://answers.sap.com/tags/73554900100800003241 for CPI for your question, instead of Cloud Platform Workflow. Otherwise you won't get the attention of CPI experts.

I have asked moderators to move the post to that tag.

Regards,

Tobias

Re: IN operator in odata get query

former_member717479 — Wed, 10 Mar 2021 08:56:55 GMT

Hi tobias.breyer,

Thank you for your response and for the tag suggestion.

And yes I have tried with the brackets and its still not working.

I am providing the below link where is it mentioned about the IN operator used in the filter option while creating query:

https://help.sap.com/viewer/368c481cd6954bdfa5d0435479fd4eaf/Cloud/en-US/c5c2e38e0c87472e996dfda04920bfc4.html

Any help will be useful.

Thanks

Re: IN operator in odata get query

MauriF — Wed, 10 Mar 2021 15:35:38 GMT

Hi Anuja, does the OData service you are trying to consume support the IN operator in query parameter $filter ? According to this article https://docs.microsoft.com/en-us/odata/odatalib/in-operator the IN operator is supported only from OData version 4.01. So if you are calling an OData version 2 service the IN operator is probably not supported. The mentioned article links to the official 'what's new' document by OASIS which also states that values must be listed as a collection which is a parentheses-enclosed list of comma-separated primitive values. I see in the SAP documentation that parentheses are omitted in the shown example. I guess this is misleading ( an error in the documentation ).

regards

Mauri

Re: IN operator in odata get query

former_member37103 — Wed, 09 Mar 2022 08:32:31 GMT

Hi Anuja,

Kindly use in operator like this &$filter=userId in '82094','108713' with odata V2

Thank you,

Wajahat Imam

Re: IN operator in odata get query

former_member36641 — Thu, 12 May 2022 14:12:05 GMT

Hi wajahat_n2a,

This does not work and throws error "Invalid parametertype used at function 'and' (Position: 90)"

If we use $filter=OrderID eq 10248 or OrderID eq 10249 then it works fine.