How to Read Data From Csv API Response?

2023-06-05

If you have an API endpoint that returns a CSV file (as explained here), you can read it by first installing the CsvHelper NuGet package, and then by reading the HTTP response content:

HttpResponseMessage response = await client.GetAsync($"/api/downloadCsv");

using (var csvStream = await response.Content.ReadAsStreamAsync())
using (var reader = new StreamReader(csvStream))
using (var csvReader = new CsvReader(reader, CultureInfo.InvariantCulture))
{
    Data[] records = csvReader.GetRecords<Data>().ToArray();
}

Once we have the CsvReader, we can access the actual data by calling csvReader.GetData<T>().

The file name can be accessed this way:

HttpResponseMessage response = await client.GetAsync($"/api/downloadCsv");
var filename = response.Content.Headers.ContentDisposition.FileName;