ODATA URI filter IN and NOT IN expressions?

(0) Share

Report

Posted on by BilginOzkan

Hey guys,

I have a powershell script that calls a specific URI. I have the standard eg and gt etc. But I want to be able to add a NOT IN {'A' 'B' 'C'} expression ala SQL, but get the following error in POSTMAN when I try to test it with

not(Property in ('FOO', 'BAR'))

Client requests that contain \"Not\" filter options are not supported by Dynamics 365 Business Central OData web services.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

DAnny3211 11,407 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi

the IN should work perfectly:

example:

$filter=YOURFIELD in ('10000','20000')

the NOT is not expected on an odata query, but you could get around it this way:

$filter=(YOURFIELD ne '10000') and (YOURFIELD ne '20000')

regards

DAniele

Was this reply helpful? Yes No