Issue with Filtering on Custom Field in Business Central API

(2) Share

Report

Posted on by NV-11021010-0

Hello Everyone,

I am facing an issue while retrieving records from the custom API page in Business Central.

When we use Get Record by ID, the custom field (SageNo) is returned correctly in the response.

However, when we try to retrieve the same record using $filter on the SageNo field, the record is not returned for certain values. Interestingly, filtering works for some SageNo values but fails for others, even though:

The field exists in the API pag
The value is present in the record
The same company and environment are being used
The same filter syntax is applied

Example:

GET by ID → Record is returned and SageNo is visible
GET with $filter=SageNo eq '161129' → No record found (for some values)
Filtering works for other SageNo values

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 97,264 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

That's a bit strange. Can you find it using the IN operator?

PS: Dynamics 365 Business Central: How to use the OData V4 IN operator in web service queries

https://yzhums.com/48974/

Thanks.

ZHU

Was this reply helpful? Yes No