Loading

WebClient is failing to execute the url and get the CSV.

WebClient is failing to execute the url and get the CSV.

Ms_ Dev

Ms_ Dev

9y1.1kVisual Basic .NET

HI,

Following code is failing at WebClient statement. I am not able to get the csv from API.

private static async Task<double?> GetStockPriceAsync(string symbol)
{
if (string.IsNullOrWhiteSpace(symbol))
return null;
string url = $"http://finance.yahoo.com/d/quotes.csv?s={symbol}&f=l1" ;
string csv;
using (WebClient client = new WebClient())
{
csv = await client.DownloadStringTaskAsync(url).ConfigureAwait(false);
}
string line = csv.Split('\n')[0];
string price = line.Split(',')[1];
double result;
if (double.TryParse(price, out result))
return result;
return null;
}

help me with the new statement that will work apart from WebClient.

3 Replies

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

Amit Gupta9y ago
Got it !!

When you say ConfigureAwait(false), you are saying that the rest of that async method does not need the original context. ConfigureAwait is more of an optimization hint; it does not always mean that the continuation is run on a thread pool thread.

Use
csv = await client.DownloadStringTaskAsync(url);

or

csv = await client.DownloadStringTaskAsync(url).ConfigureAwait(true);
Hope this helps !
Ms_ Dev9y ago
While debugging line-by-line it goes out of scope after

csv = await client.DownloadStringTaskAsync(url).ConfigureAwait(false);

line. I dont know whats wrong with this line. Although by passing url in borwser everything works fine.
Amit Gupta9y ago
What is the issue? Can you share error details, just make sure that API URL you are building to be corrent.

Try pasting the URL directly on the browser and see, do I got the expected result.

WebClient will work in all your stuff perfectly!!

Check Reference
http://www.jarloo.com/yahoo_finance/

http://csharphelper.com/blog/2015/01/get-stock-prices-from-the-internet-in-c/

Do let me know, if it solves your problem