I have a web api 2.2 that is configured for OData v4. I want to return a user by ID and include only the user group Id's that the user is a member of. When I do this http://localhost/User?$filter=...

I'm using WebAPI 2.2 and Microsoft.AspNet.OData 5.7.0 to create an OData service that supports paging. When hosted in the production environment, the WebAPI lives on a server that is not exposed e...

I currently have an OData V4 service that has the following model. "Category" -- "Codes" For each category there can be many codes. I need to $expand the Codes, $filter where Active = true and th...

I am writing a query for metadata in Dynamics 365, but I think this problem could be universal for any OData query. My problem is as follow: In Dynamics, we can have multiple types of fields in ...

I have a fairly large data model that I want to expose using Web API OData using the OData V4 protocol. The underlying data is stored in a SQL Server 2012 database. That database has many DateTime...

Couldn't find a group by references in ODATA V4 documentation. When we pass the group by query in URL it just returns the key, not the actual grouped results. Any references for using Group by ...

I have an OData 4 endpoint I call for displaying data in a table. One of the columns has a set of data concatenated from a string array within my element. Is there a way to order by the first eleme...

I am running a simple .NET Core WebApi application with OData Query v4 and SQL Server 2012. This works, but it's extremely slow: GET /api-endpoint?$filter=date(MyDateTimeField) ge 2018-01-01&...

What's the difference between [EnableQuery(PageSize=20)] and [EnableQuery(MaxTop=20)]? As far as I can tell they both set a max limit on the result. Calling GET odata/Products?$top=100 on either ...

In oData 4.0 Actions and functions are frequently referred. I couldn't get what are they and how they are different. Are function same functions we have in any programming language or something els...

When I run the following sample it is throwing the following exception... Additional information: The entity 'TestEntity' does not have a key defined. I have configured the key using code firs...

In my web service, I override the ExceptionHandler, but it's not clear to me how you would format the exception to fit the OData Error standard. Perhaps i'm approaching it wrong since I can't find ...

Does anyone know how to set / read vocabulary based annotations in the metatdata for OData V4 to define things like max string length? There is an article Client Annotation Support but it does not...

Trying to move from OData v3 to OData v4. Why do I keep getting a 404 when trying to use OData Functions? Web API Config: ODataModelBuilder builder = new ODataConventionModelBuilder(); //etc buil...

I want to get a list of distinct values from my OData endpoint. But distinct or group by isn't supported yet. My URI query looks something like this GET /odata/Products?$select=foo & $top=10 ...

OData Connected Service OData V4 Client Code Generator I know that these extensions are used to generate client code based on Odata service. What is the difference between OData Connected Serv...

I'm using Web Api OData v4 on the server and OData Client code generator on the client. It works fine, but I don't know how to test the code on the client. On the server I expose a "Levels" dbSet....

I have a side-by-side Web API 2.2 APIController and OData v4 ODataController. My APIController uses routing attributes internally like this (there are no predefined routing defaults): [RoutePrefi...

I am trying to get a Web API OData V4 endpoint up and running. I got it going finally (after removing all the DateTime properties from my endpoint) and now the listing of the entities is in JSON. ...