how to read Web APi csv file

prasanna p

5y7.7k.NET

Hi Friends,

To read data from our client API, first I am login into the URL https://site.com by using username, password and location.

After login to get the data another Web API URL is there https://site.com/users/reports/csv?location_id=42&from_date=2020-11-02&to_date=2020-11-05

After login, we used this URL the file is automatically downloading in the browser.

I want to read this CSV file content and I need to insert the records into the database.

for web Api login I wrote this code

var userName = "[email protected]";
var passwd = "5CadcPT";
var url = "https://site.com";
var location= "Hyderabad";
var client = new HttpClient();
var authToken = Encoding.ASCII.GetBytes($"{userName}:{passwd}:{location}");
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic",
Convert.ToBase64String(authToken));
var result1 = await client.GetAsync(url);
var content = await result1.Content.ReadAsStringAsync();
For downloading file I used this code file is downloading but the HTML content is coming in the downloaded CSV file.
stream = await response.Content.ReadAsStreamAsync();
var fileInfo = new FileInfo("reports_2020-11-10 08_14_12.csv");
using (var fileStream = fileInfo.OpenWrite())
{
await stream.CopyToAsync(fileStream);
}

how to do this?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
hii
follow the code to add auth credential to construct rest request
var userName = "myuser";
var password = "mypassword";
var host = "www.abc.com";
var client = new RestClient("https://" + host + "/methodName");
client.Authenticator = new HttpBasicAuthenticator(userName, password);
var request = new RestRequest(Method.POST);
request.AddHeader("Accept", "application/json");
request.AddHeader("Cache-Control", "no-cache");
request.AddHeader("Content-Type", "application/json");
request.AddParameter("application/json","{}",ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
Mageshwaran R5y ago
Hi prasanna,
please refer this link,
https://stackoverflow.com/questions/29948809/web-api-return-csv-file/29951751
prasanna p5y ago
hi Sachin Singh,

I tried your code getting the unauthorized error at Lines.GetLength(0) data is not coming.Login to site url is mandatory after that only the other url will download the csv file.

Please tell me how to implement this?
Sachin Singh5y ago
var restSharpClient = new RestClient("https://www.site.com");

var downloadRequest = new RestRequest("research/stock-screener/api/downloadCSV?pageSize=20",
    Method.GET);

IRestResponse response = restSharpClient.Execute(downloadRequest);


string[] strSeparators = new string[] { "\r\n" };
string[] Lines = response.Content.Split(strSeparators, StringSplitOptions.None);

string[] Fields;
Fields = Lines[0].Split(new char[] { ',' });
int Cols = Fields.GetLength(0);
DataTable dt = new DataTable();
//1st row must be column names; force lower case to ensure matching later on.
for (int i = 0; i < Cols; i++)
    dt.Columns.Add(Fields[i].ToLower(), typeof(string));
DataRow Row;
for (int i = 1; i < Lines.GetLength(0); i++)
{
    Fields = Lines[i].Split(new char[] { ',' });
    if (Fields.Length > 1)
    {
        Row = dt.NewRow();
        for (int f = 0; f < Cols; f++)
            Row[f] = Fields[f];
        dt.Rows.Add(Row);
    }
}
if (dt.Rows.Count > 0)
{
    // TODO: Code for save data to database.
}