Read Csv on asp.net core endpoint

Question

I am trying to create an endpoint that accepts a CSV file but the data stream doesn't return any records.

This is my view model:

public class BulkUploadViewModel
{
    [Required]
    public IFormFile JobCsv { get; set; }
    [Required]
    public string UserId { get; set; }
}

And this is my endpoint:

[Route("BulkUpload")]
[HttpPost]
public async Task<IActionResult> BulkUpload(BulkUploadViewModel bulkUpload)
{
    if(!ModelState.IsValid)
    {
        return BadRequest();
    }

    List<BulkUploadDataModel> bulkList = new List<BulkUploadDataModel>();

    using (var memoryStream = new MemoryStream())
    {
        await bulkUpload.JobCsv.CopyToAsync(memoryStream);
        TextReader textReader = new StreamReader(memoryStream);

        var csv = new CsvReader(textReader);

        csv.Configuration.HasHeaderRecord = true;

        bulkList = csv.GetRecords<BulkUploadDataModel>().ToList();
    }

    return Ok(bulkList.Count());
}

I have also tried reading the CSV line by line but Csv.Read() returns false. I am not sure how to debug this.

I am generating the post with postman:

In the debugger I can see the file name and length value are populated correctly in bulkUpload.JobCsv so I assume my error is in how I am accessing the stream.

What did I do wrong?

Ashkan Nourzadeh · Accepted Answer · 2018-02-03 06:04:28Z

3

You are just missing memoryStream.Position = 0 after
await bulkUpload.JobCsv.CopyToAsync(memoryStream);.

like this:

await bulkUpload.JobCsv.CopyToAsync(memoryStream);
memoryStream.Position = 0;
TextReader textReader = new StreamReader(memoryStream);

answered Feb 3, 2018 at 6:04

Ashkan Nourzadeh

1,94218 silver badges33 bronze badges

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

Comments

lilo.jacob · Accepted Answer · 2018-02-03 06:03:30Z

0

I have Asp.Net project, where I use Csv package and this code to read csv from a file:

using (var stream = bulkUpload.JobCsv.OpenReadStream())
{
    var csvLines = CsvReader.ReadFromStream(stream).ToList();
}

answered Feb 3, 2018 at 6:03

lilo.jacob

2,4341 gold badge21 silver badges20 bronze badges

Collectives™ on Stack Overflow

Read Csv on asp.net core endpoint

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related