C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
7,621 questions
What's the best way to parse a csv file and create entries in a webapi project?
titariko
1
Reputation point
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
C#
{count} votes
-
AgaveJoe 20,306 Reputation points2021-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.
ok thanks, but where should the code for the parsing be written exactly?
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
alright thanks
Sign in to comment