I've been messing with the OData and realized that URIs are case sensitive. .../Northwind.svc/Products != .../Northwind.svc/products Is this done on purpose? is there a way to make it case insensitive?
OData API filter value which you are selecting for $FILTER parameter is always case sensitive.
The $select option specifies a subset of properties to include in the response body. For example, to get only the name and price of each product, use the following query: Console Copy. GET http://localhost/odata/Products?$select=Price,Name.
A URL used by an OData service has at most three significant parts: the service root URL, resource path and query options.
The recommended solution is to either use the supported OData functions toupper
or tolower
to work out the case sensitivity issues (when using a filter$
command) and get the full result set.
I wrote a brief post explaining this a bit further in detail:
Dealing With Case Sensitivity in OData
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With