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,453 Super User 2025 Season 2 on at

Like (1)

Report

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

95,765 Super User 2025 Season 2 on at

Like (1)

Report

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. 20,975 Super User 2025 Season 2 on at

Like (1)

Report

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,856

#2

Khushbu Rajvi. 765 Super User 2025 Season 2

#3

YUN ZHU 581 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans