Share via


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 the OData IN operator when querying Business Central web services. This operator simplifies OData queries and makes integrations easier to develop.

Feature details

Before this release, to query an OData endpoint, a developer needed to write a filter expression. For example, to query an API for a short list of customer numbers, the developer wrote $filter=CustomerNo eq '10000' or CustomerNo eq '20000' or CustomerNo eq '30000'.

With this release, the developer can use the OData IN operator and write $filter=CustomerNo IN ('10000','20000','30000').

Geographic areas

Visit the Explore Feature Geography report for Microsoft Azure areas where this feature is planned or available.

Language availability

Visit the Explore Feature Language report for information on this feature's availability.

Additional resources

Using filter expressions in OData URIs (docs)