Create a GET web API with endpoint

Nitin Pawar

6y1.3k.NET

Hi ,

I am new Web Api learner, I have one below task can you help me which way easily to complete this task.

1. Create a GET web API with endpoint /?state=

Endpoint

- This API should return the value of Population or Households according to the path endpoint, for the states given in the comma-delimited query parameter state.

- Example /population?state=1,10,12 will return the population data for states 1, 10 and 12.

- Enable CORS for this endpoint.

Logic

- For the required states, look up Actuals table first. If the data is available, return that data. If not, return a sum of the value over all districts for the required state in the Estimates table.

- If any input state id is not available, return a 404 HTTP Code instead.

Response

- The response should be in JSON format like this:

[{ “State”: 1, “Population”: 22805514.45 }, { “State”: 10, “Population”: 338888364.12 }, ….]

Please can you provide me solution sample as well as reference link.

Thanks

Nitin

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar6y ago
Accepted answer
Hi Nitin,

You need to take new Web API project with new controller and new end point with parameter,
public class PopulationController : ApiController
{
    [HttpGet]
    public IHttpActionResult Households(List<int> state)
    {
        var statePopulationCount = new List();
        // Logic to get Population Count for each state id
        // statePopulationCount.Add() for each state result

        return Ok(new { results = statePopulationCount });
    }
}
Periyasamy Vellingirisamy6y ago
Hi Nitin,
Refer following info,

[HttpGet]
[Route("~/population")]
[EnableCors(PolicyName = "nameofthepolicydefined")]
public IActionResult Population([FromQuery] string state)
{
//Logic
//1. Using for loop of splitted state value and getting the population from table, if not available add it as 404 result in one list object.
//2. Passing state into stored procedure and return desire result.
return Ok(new { results = //Result object });
}