web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Filter in API

Small and medium business | Business Central, N...

Suggested Answer

Filter in API

(1) Share

Report

Report

Posted on by SG-05091051-0

163

Hi All,

I am using On-Prem Business Central.

I have created one API where i want to use 2 filter, record should be fetch if anyone of the filter value match.
Example Item No or Item Name - if anyone is match record should be fetch.

https://xyz.com:1234/testUAT/ODataV4/Company('abc)/GetItemDetailById?$filter = ItemNo eq '10010500001'

Does anyone have any idea about this. Please help me on this.

Thanks for your help.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 26,801 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

You must use OR in your filter.

for e.g.

https://xyz.com:1234/testUAT/ODataV4/Company('abc')/GetItemDetailById?$filter = ItemNo eq '10010500001' or ItemName eq 'Name'

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No

Suggested answer

YUN ZHU

99,084 Super User 2026 Season 1 on at

Like (1)

Report

Hi, You use OData, which is described in detail in the following MS Learn.

Using Filter Expressions in OData URIs - Business Central | Microsoft Learn

Definition	Example and explanation	Equivalent AL expression
Select a range of values	`$filter=Entry_No gt 610 and Entry_No lt 615` Query on GLEntry service. Returns entry numbers 611 through 614.	..
In a list of values	`$filter=EntryNo in (610, 612, 614)` Query that returns entry numbers 610, 612, and 614 Note: This only works in `$schemaversion=2.1`.
And	`$filter=Country_Region_Code eq 'ES' and Payment_Terms_Code eq '14 DAYS'` Query on Customer service. Returns customers in Spain where Payment_Terms_Code=14 DAYS.	&
Or	`$filter= Country_Region_Code eq 'ES' or Country_Region_Code eq 'US'` Query on Customer service. Returns customers in Spain and the United States. Alert: You can use OR operators to apply different filters on the same field. However, you can't use OR operators to apply filters on two different fields.	\|
Less than	`$filter=Entry_No lt 610` Query on GLEntry service. Returns entry numbers that are less than 610.	<
Greater than	`$filter= Entry_No gt 610` Query on GLEntry service. Returns entry numbers 611 and higher.	>
Greater than or equal to	`$filter=Entry_No ge 610` Query on GLEntry service. Returns entry numbers 610 and higher.	>=
Less than or equal to	`$filter=Entry_No le 610` Query on GLEntry service. Returns entry numbers up to and including 610.	<=
Different from (not equal)	`$filter=VAT_Bus_Posting_Group ne 'EXPORT'` Query on Customer service. Returns all customers with VAT_Bus_Posting_Group not equal to EXPORT.	<>
endswith	`$filter=endswith(VAT_Bus_Posting_Group,'RT')` Query on Customer service. Returns all customers with VAT_Bus_Posting_Group values that end in 'RT'.	*
startswith	`$filter=startswith(Name, 'S')` Query on Customer service. Returns all customers names beginning with 'S'.	*
contains	`$filter=contains(Name, 'urn')` Query on Customer service. Returns customer records for customers with names containing the string “urn”.
substring	`$filter=substring(Location_Code, 5) eq 'RED'` Query on Customer service. Returns true for customers with the string RED in their location code starting as position 5.
tolower	`$filter=tolower(Location_Code) eq 'code red'`
toupper	`$filter=toupper(FText) eq '2ND ROW'`

Was this reply helpful? Yes No

Suggested answer

Khushbu Rajvi. 22,128 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

To achieve filtering in your API request so that records are fetched if either the Item No or Item Name matches, you can use the $filter query option with the or operator in your OData query.

https://xyz.com:1234/testUAT/ODataV4/Company('abc')/GetItemDetailById?$filter=ItemNo eq '10010500001' or ItemName eq 'YourItemName'

Hope this helps: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/use-filter-expressions-in-odata-uris

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,946 Super User 2026 Season 1

#2

YUN ZHU 1,177 Super User 2026 Season 1

#3

Khushbu Rajvi. 555 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans