Sdílet prostřednictvím


Use the OData V4 IN operator in web service queries

Enabled for Public preview General availability
Users by admins, makers, or analysts Apr 1, 2024 Apr 2, 2024

Business value

Integrators can now use OData IN operator when querying Business Central web services. This can simplify OData queries and therefore make integrations easier to develop.

Feature details

Prior to this release, a developer who wanted to query an OData endpoint—for example, to query an API for a (short) list of Customer numbers—would have to write a filter expression such as $filter=CustomerNo eq '10000' or CustomerNo eq '20000' or CustomerNo eq '30000'.

With this release, they can just write $filter=CustomerNo IN ('10000','20000','30000') by using the OData IN operator.

See also

Using filter expressions in OData URIs (docs)