You can compare to null using the equality operator like this: $filter=CustomerID eq null In your case the query would degenerate to something like: $filter=(CustomerID eq null) or (null eq null) Which should work, but it’s not very nice. Did you consider removing the predicate completely in such case?
The “eq” operator is supposed to be case sensitive. Usage of tolower (or toupper) is the currently recommended way of doing this.
Currently the OData protocol doesn’t support the distinct operator, or any other operator which would help with such query (assuming you’re looking for disctinct values of a primitive property on some entity). You should be able to workaround this by implementing a service operation on the server which performs such query on the underlying provider … Read more
OData is a similar specification to JSON API. Both of them describe a standard protocol for creation and consumption of RESTful APIs. GraphQL is a totally different approach to API design and specifies a different way of querying API resources. OData: Designed and developed at Microsoft since 2007, standardized by the OASIS consortium. The latest … Read more
Figured this out. OData V2 out-of-the-box returns dates out of SQL in JSON Date format like so: /Date(1338282808000)/ However, in order to use a date as a filter within an OData call, your date has to be in EDM format, looking like this: 2012-05-29T09:13:28 So, I needed to get the date from my initial OData … Read more
Swagger is a specification for documenting APIs. By creating a swagger document for your API, you can pass it to an instance of Swagger UI, which renders the document in a neat, readable format and provides tooling to invoke your APIs. See the swagger.io website for further information. OData is a specification for creating data … Read more
I have researched and also tried with Both GraphQL in Dot Net and Odata in DotNet Web API to create a working demo and What I found are Developer Usability Considering you have existing WebAPI(DotNet Framework) and want to migrate to GraphQL or OData compatible WebAPI then my answer is to choose OData because of … Read more