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.

All responses (1)

Answers (0)

Suggested answer

DAnny3211 9,278 Moderator on at

Like (0)

Report

RE: ODATA URI filter IN and NOT IN expressions?

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