Web API and OData- Pass Multiple Parameters

by

You can define a function import named GetReports that has two parameters.

(Note: the name of the function import can’t be the same with entity set name)

Configure your EDM model as:

var builder = new ODataConventionModelBuilder();
builder.EntitySet<Report>("Reports");
var function = builder.Function("GetReports");
function.Parameter<int>("Id");
function.Parameter<int>("Year");
function.ReturnsCollectionFromEntitySet<Report>("Reports");
var model = builder.GetEdmModel();

And then write your method as:

[HttpGet]
[ODataRoute("GetReports(Id={Id},Year={Year})")]
public IHttpActionResult WhateverName([FromODataUri]int Id, [FromODataUri]int Year)
{
    return Ok(_reportsRepository.GetReports(Id, Year));
}

Then the request

Get ~/GetReports(Id=22,Year=2014)

will work.

More Related Contents:

  1. Adding a custom query backed Navigation Property to ODataConventionModelBuilder
  2. No connection could be made because the target machine actively refused it?
  3. Dot character ‘.’ in MVC Web API 2 for request such as api/people/STAFF.45287
  4. FromBody string parameter is giving null
  5. Swagger UI Web Api documentation Present enums as strings?
  6. Web API 2: how to return JSON with camelCased property names, on objects and their sub-objects
  7. Newtonsoft JSON dynamic property name
  8. JsonConverter with Interface
  9. Post byte array to Web API server using HttpClient
  10. Order of execution with multiple filters in web api
  11. Pass multiple complex objects to a post/put Web API method
  12. Asp.Net WebApi2 Enable CORS not working with AspNet.WebApi.Cors 5.2.3
  13. Could not load file or assembly ‘System.Web.Http 4.0.0 after update from 2012 to 2013
  14. How to prevent a single object property from being converted to a DateTime when it is a string
  15. Web API optional parameters
  16. How to return a PDF from a Web API application
  17. WebAPI and ODataController return 406 Not Acceptable
  18. Return more info to the client using OAuth Bearer Tokens Generation and Owin in WebApi
  19. OData with ServiceStack? [closed]
  20. How to in-code supply the password to a connection string in an ADO.Net Entity Data Model
  21. Get Content-Disposition parameters
  22. Net Core: Using OData in Onion Architecture, Convert Query Parameters Into Linq
  23. How to put attributes via XElement
  24. What is the difference between the Data Mapper, Table Data Gateway (Gateway), Data Access Object (DAO) and Repository patterns?
  25. Unit testing HTTP requests in c#
  26. C# UDP Broadcast and receive example
  27. Get parent directory of parent directory
  28. How to open a form within a form?
  29. Upload file from Html form (multipart/form-data) to WCF REST service as a stream without streaming the whole form’s inputs?
  30. Installer Custom Action problem – can’t write to register key

Leave a Comment