What's the best way to parse a csv file and create entries in a webapi project?

titariko 1

I have a csv file with hundreds of rows with 5 columns. Ofc the 1st row consists of the column names while the rest of the rows are the data.
What is the best way to parse and create entries while at the same time excluding some of the data if they don't meet a certain condition?

Thank you

AgaveJoe 26,136 Reputation points

2021-06-19T18:07:33.99+00:00

NuGet has CSV parsers. The official docs cover reading a text file and looping over each line. Split the line by the comma and apply whatever validation logic you require.
titariko 1 Reputation point

2021-06-19T19:13:26.97+00:00

ok thanks, but where should the code for the parsing be written exactly?
AgaveJoe 26,136 Reputation points

2021-06-19T22:24:01.103+00:00

In Web API custom code runs within an action invoked from an HTTP method (GET POST etc) Typically, the parsing logic exists in a class or library. The Web API action calls the class or library to perform the task. I think you'll be interested in going through a few Getting Started tutorials found on this site.

https://learn.microsoft.com/en-us/aspnet/core/tutorials/first-web-api?view=aspnetcore-5.0&tabs=visual-studio
https://learn.microsoft.com/en-us/aspnet/core/web-api/?view=aspnetcore-5.0
titariko 1 Reputation point

2021-06-20T21:50:37.927+00:00

alright thanks