ASP.NET CORE Web API Fails to return file but instead it returns text

Question

I have to export the list users as a CSV file.

Here is my Sample.cs

   `public int Id { get; set; }
    public string Name { get; set; }
    public string Email { get; set; }
    public string Password { get; set; }
    public DateTime DateOfBirth { get; set; }`

Here is my controller code and sample data.

   `
  private IList<Sample> sample = new List<Sample>
    {
        new Sample {Id=1,Name ="pons",Email="[email protected]"},
        new Sample {Id=2 ,Name="maddy",Email="[email protected]"},
        new Sample {Id=3,Name="thom",Email="[email protected]"},
        new Sample {Id=4,Name="gomz",Email="[email protected]"},
        new Sample { Id=5,Name="vaandu",Email="[email protected]"}
    };
   [HttpGet]
    [Route("GetValue")]
    public IActionResult ExportToCSV()
    {

        var builder = new StringBuilder();
        builder.AppendLine("Id,Name,Email");
        foreach (var data in sample)
        {
            builder.AppendLine($"{data.Id},{data.Name},{data.Email}");
        }
        return File(Encoding.UTF8.GetBytes(builder.ToString()), "text/csv", "god.csv");`

The above code is expected to return a file (automatically download a csv file).It returns a text instead of a file. Here is the output of the above code

This how it return to my angular request

Malvik Bhavsar · Accepted Answer · 2021-09-13 17:39:54Z

2

It should be FileContentResult instead of IActionResult

[HttpGet]
[Route("GetValue")]
public FileContentResult ExportToCSV()
{

    var builder = new StringBuilder();
    builder.AppendLine("Id,Name,Email");
    foreach (var data in sample)
    {
        builder.AppendLine($"{data.Id},{data.Name},{data.Email}");
    }
    return File(Encoding.UTF8.GetBytes(builder.ToString()), "text/csv", "god.csv");`

answered Sep 13, 2021 at 17:39

Malvik Bhavsar

4405 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Malvik Bhavsar Over a year ago

Can you please share your angular download file request code? Because in API code there is no issue.

Malvik Bhavsar Over a year ago

In postman, there is an option to save the response as a file, and if you direct hit this API URL in a web browser. then it's CSV file download with your current code. Please check

Thomas Raj Over a year ago

export() { return this.http.get(environment.ApiUrl+"Values/GetValue") } This is how I call the above service method onSubmit() { this.service.export().subscribe( res=>{}, err=>{} );}

Malvik Bhavsar Over a year ago

Okay. So you need to use Blob. Please refer to this link

Thomas Raj Over a year ago

Is there any way to return a csv file from api controller directly?

|

Dharman · Accepted Answer · 2021-09-22 09:35:06Z

0

Instead of returning a file from ApiController, I returned a list as Response to angular,displayed it in a table and exported that table using table exporter package.

Table exporter implementation

For Angular version more than 9(up to 12) Don't forget to add matTableExporter attribute as below

<table mat-table [dataSource]="dataSource" matSort matTableExporter #exporter="matTableExporter">

This satisfied my requirement.

edited Sep 22, 2021 at 9:35

Dharman♦

33.9k27 gold badges103 silver badges157 bronze badges

answered Sep 22, 2021 at 9:29

Thomas Raj

5897 silver badges15 bronze badges

Collectives™ on Stack Overflow

ASP.NET CORE Web API Fails to return file but instead it returns text

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related