
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.
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