Business Central API Filters Error

(3) Share

Report

Posted on by SK-14101306-0

Hi Team,

I want to Use two filters in API Date and Time both Columns need to be filter but it filter till date but when i try to mention time it gives me error

https://api.businesscentral.dynamics.com/v2.0/xxxxxxxxxxxxxxxxxxxxxxxx/Production/ODataV4/Company('HB%20POS')/TransactionRegister/?$filter=Date eq 2025-03-11

above is my API for Use and Till Date API it is working Fine But after using Time Column to Be filtered getting this Error

{
    "error": {
        "code": "BadRequest",
        "message": "A binary operator with incompatible types was detected. Found operand types 'Edm.String' and 'Edm.TimeOfDay' for operator kind 'Equal'.  CorrelationId:  bb17c4ac-ad41-4410-837b-4e90684cd0c9."
    }
}
 
Regards,

Shahrukh khan

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central migration

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Mohamed Amine Mahmoudi 26,434 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

I hope this can help you and give you some hints.

https://blog.steveendow.com/2024/02/filter-by-date-range-with-business.html

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,236 Most Valuable Professional on at

Like (2)

Report

Hi, good day
I hope this can help you, and give you some hints.

Using filters with API/OData calls - Business Central | Microsoft Learn

Filter with date (ODATA) and add date formatting - Alexander Henkel

Best Regards
Gerardo

Was this reply helpful? Yes No
Nitin Verma 21,708 Moderator on at

Like (2)

Report

Hi,

In your api can you try this filter

$filter(date eq 2025-03-11 and Time eq time'09:00:00')

Was this reply helpful? Yes No
Verified answer

SK-14101306-0 23 on at

Like (2)

Report

Finally I found an Answer Thank you so much for your Supports

https://api.businesscentral.dynamics.com/v2.0/97e86d50-e0e3-4cff-9982-fc2eb4fcb4ff/Production/ODataV4/Company('HB%20POS')/TransactionRegister/?$filter=date eq 2025-03-11 and Time gt '17:10:40'

and Thank you so much @Nitin Verma for Help

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,601 Super User 2025 Season 2 on at

Like (2)

Report

Hope this helps as well:https://www.youtube.com/watch?v=DWhPivAZk_I

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-connect-apps-filtering

Was this reply helpful? Yes No