Asp.net Web API - How to set the filename for a custom CSV Media Type Formatter

I have successfully implemented a Csv Media Type Formatter in my ASP.Net Web API project. I am able to get results back in Csv format. However the resulting filename is "parts" without an extension.

Ideally, I want to be able to set this filename in the controller, but being able to add the extension globally would be a minimum.

Below are the examples I have found

Override OnGetResponseHeaders - I don't see that as an option in the current version. http://forums.asp.net/t/1782973.aspx/1?Setting+response+and+content+headers+esp+ContentDisposition+inside+a+MediaTypeFormatter

According to that article this should work

public override IEnumerable<KeyValuePair<string, string>> OnGetResponseHeaders(Type objectType, string mediaType, HttpResponseMessage responseMessage)
{
       return new[] { new KeyValuePair<string, string>("Content-Disposition", "attachment; filename=testing.csv") };
}

However Visual Studio says "There is no suitable method for override" and won't compile when I add that to my custom Csv Formatter.

Return HttpMessageResponse from controller - How to set downloading file name in ASP.NET MVC Web API However this appears to just be pushing existing server files, which would take the Csv serialization out of the mix. Below is an attempt to make this approach work:

public HttpResponseMessage Get(string id)
{
    var response = new HttpResponseMessage();

    if (id == "test")
    {
        var data = GetTestData();
        response.StatusCode = HttpStatusCode.OK;
        response.Content = new StreamContent(data);
        response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment");
        response.Content.Headers.ContentDisposition.FileName = "testorama.csv";
        return response;
    }

    return null;
}

The issue here is that new StreamContent() is expecting a stream - is there a way to get the current stream that Custom Csv Formatter created?

Bottom line, how can I set the filename for a resultset that is first serialized to Csv format?

Solution

Thanks Claudio - that got me going in the right direction. A couple changes from what you posted:

  1. I was deriving from BufferedMediaTypeFormatter for my custom Csv Formatter and to use SetDefaultContentHeaders I had to instead derive from MediaTypeFormatter.

  2. SetDefaultContentHeaders accepts the mediaType parameter with a type of MediaTypeHeaderValue and not string.

Here is the final code:

public override void SetDefaultContentHeaders(Type type, HttpContentHeaders headers, MediaTypeHeaderValue mediaType)
{
    base.SetDefaultContentHeaders(type, headers, mediaType);
    headers.Add("Content-Disposition", "attachment; filename=testorama.csv");
}

Answers


Override the method SetDefaultContentHeaders on your MediaTypeFormatter

public override void SetDefaultContentHeaders(
    Type type, HttpContentHeaders headers, string mediaType)
{
    base.SetDefaultContentHeaders(type, headers, mediaType);
    headers.Add("Content-Disposition", "attachment; filename=yourname.csv");
}

Need Your Help

Uploading a Picture (with Title) to Facebook Page through App

php facebook facebook-graph-api facebook-php-sdk facebook-access-token

So I wanted to do the following: a php script should upload a picture with a title to a facebook page.

Inner join with 3 tables in mysql

mysql database inner-join

I want to select data from more tables with Inner join.