How to solve the '>' is an unexpected token. The expected token is '"' or '''. Line 1, position 50 this issue

Question

4.00/5 (1 vote)

See more:

Hi All,
i am trying to read xml data using c#,here ia m facing the issue is i am not able to read the data.
i am trying to implement getting yahoo stickers data from yahoo url and bind into table.
The data contains URL and read that data and bind to table.
i am using the below code

C#

string yahooURL = ConnectionStrings.yahooURL;
                       string symbolList = String.Join("%2C", Quotes.Select(w => "%22" + w.Symbol + "%22").ToArray());
                       string url = string.Format(yahooURL,symbolList);
                      XDocument doc = XDocument.Load(url);
                       XElement results = doc.Root.Element("results");
                       foreach (Quote quote in Quotes)
                       {
                           Watchlist objPC = new Watchlist();
                           XElement q = results.Elements("quote").First(w => w.Attribute("symbol").Value == quote.Symbol);
                           objPC.Symbol = quote.Symbol;
                           objPC.Name = q.Element("Name").Value;
                           objPC.Price = GetDecimal(q.Element("LastTradePriceOnly").Value);
                           objPC.Change = GetDecimal(q.Element("Change").Value);
                           objPC.ChangeInPercent = GetDecimal(q.Element("ChangeinPercent").Value);
                           objPC.Volume = GetDecimal(q.Element("Volume").Value);
                           objPC.DaysRange = q.Element("DaysRange").Value;
                           objPC.YearRange = q.Element("YearRange").Value;
                           objPC.MarketCapitalization = q.Element("MarketCapitalization").Value;
                           propClass.Add(objPC);
                       }

here i am getting the error is "C#

'>' is an unexpected token. The expected token is '"' or '''. Line 1, position 50.

the below line i am getting the error
C#

XDocument doc = XDocument.Load(url);

Any Body can Please share solution to me.

this is the url
http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20(%22FLWS%22)&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys[^]

What I have tried:

Here i am getting URL and that URL the xml data is coming,But i am not able to read the data.

Posted 22-Apr-16 0:03am

Ram349

Updated 27-Apr-16 1:00am

Patrice T

v3

Add a Solution

Comments

phil.o 22-Apr-16 6:08am

What is the value of the url variable when the exception is raised?

Ram349 22-Apr-16 6:18am

this is the url
http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20(%22FLWS%22)&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys

phil.o 22-Apr-16 6:42am

Apparently there is no yahoo.finance.quotes table to query; you can see that with their query tester: YQL Console.

Andy Lanng 22-Apr-16 6:55am

@Phil.io: there is but this forum changes an '&' into '&'

It rendered in the comment but when you edit the comment to get the full string it shows '&'

Ram349 22-Apr-16 7:01am

Hi Phil,
Thanks for replying to my post,I am getting the data but i am not able to read the data.Can u Please check the above URL

Andy Lanng 22-Apr-16 7:03am

This reply was to phil.io. My reply to you is below this one

Andy Lanng 22-Apr-16 6:56am

I tried and tested your code. It worked fine.

I suggest you catch any exception and output the returned xml. You may find that there is an occasional error message being returned. In most cases you can just retry but knowing the format of all exceptions is a better way to handle them if and when they are returned.

Ram349 22-Apr-16 7:41am

Hi Andy,
Thanks for replying to my post can you please any solution to me.

D-Kishore 26-Apr-16 23:56pm

The below code works fine in .net desktop applications. But the same code not working in .net we applications. its throwing "'>' is an unexpected token. The expected token is '"' or '''. Line 1, position 50".

try
{

string URL = "http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20(%22JPM%22%2C%22FLWS%22%2C%22FCTY%22%2C%22XXII%22%2C%22SRCE%22%2C%22FCCY%22%2C%22WUBA%22%2C%22DDD%22%2C%22AMRK%22%2C%22FLWS%22%2C%22FCTY%22)&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys";
XDocument doc = XDocument.Load(URL);
}
catch(Exception ex)
{
}

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Stephen Hewison · Answer 1 · 2016-04-22T04:46:00

Solution 1

I'd guess the issue is the comments at the end.

.Net like XML structures to have a single root node (Excluding the XML header).

Yours has 3 root nodes because of the comments.

Posted 22-Apr-16 4:46am

Stephen Hewison

Comments

Richard Deeming 22-Apr-16 10:55am

It doesn't have three root nodes; the XDocument class is quite happy with the document as-is.

It's more likely to be an issue with the URL. The server is probably returning an HTML error page, which can't be parsed as XML.

D-Kishore 25-Apr-16 1:09am

It was working fine with same code last month. This issue came suddenly. Is there any need to update the XML DLL references to the project.

D-Kishore 26-Apr-16 23:56pm

The below code works fine in .net desktop applications. But the same code not working in .net we applications. its throwing "'>' is an unexpected token. The expected token is '"' or '''. Line 1, position 50".

try
{

string URL = "http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20(%22JPM%22%2C%22FLWS%22%2C%22FCTY%22%2C%22XXII%22%2C%22SRCE%22%2C%22FCCY%22%2C%22WUBA%22%2C%22DDD%22%2C%22AMRK%22%2C%22FLWS%22%2C%22FCTY%22)&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys";
XDocument doc = XDocument.Load(URL);
}
catch(Exception ex)
{
}

D-Kishore · Answer 2 · 2016-04-26T23:05:00

Solution 2

Replace http with https. it works great

Posted 26-Apr-16 23:05pm

D-Kishore