REST Queries Returning Empty Results

I'm using YQL for several sites to pull in data from their calendar page within our CMS. When I run the query in the console, everything works fine. But using the REST Query, I get an empty result set.

{"error":{"lang":"en-US","description":"Syntax error(s) [line 2:4 no viable alternative at character ':',line 3:4 no viable alternative at character ':',line 4:4 no viable alternative at character ':']"}}

That is when the following URL is called, which was formed by the YQL console itself last year.

I've been able to reproduce this all day yesterday and this morning. I checked the rate limiting and if I were exceeding limits the documentation indicates that I should receive an error indicating that. I assume since others are having similar issues that something else must be occurring.

Still getting this when trying to get Wiki titles (10 pages) through XPath, works in console, occasionally will return 1 or 2 results in the REST query but mostly nulls. My other queries using Yahoo services work fine, just when scraping content the feed goes mental. Any ideas when this will be dealt with?

Hello,<br><br>I just try the same since yesterday and randomly getting empty results like this:<br><br><span style="color:#8b8b8b;">&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;</span><br><span style="color:#8b8b8b;">&lt;query xmlns:yahoo=&quot;http://www.yahooapis.com/v1/base.rng&quot; yahoo:count=&quot;0&quot; yahoo:created=&quot;2011-10-19T20:52:34Z&quot; yahoo:lang=&quot;en-US&quot;&gt;&lt;results/&gt;&lt;/query&gt;&lt;!-- total: 5757 --&gt;</span><br><span style="color:#8b8b8b;">&lt;!-- engine2.yql.ch1.yahoo.com --&gt;</span><br><br>But after requesting it a few times it works and I get my expected results.<br>When I try the same request in the console it works all the time, so no issues here, only in the REST queries.<br><br>Query is: SELECT * from rss WHERE url=&quot;http://news.google.com/news?ned=us&q=lemurs&output=rss&quot;<br><br>I try this from a Javascript in Chrome Browser.

<?xmlversion="1.0"encoding="UTF-8"?><queryxmlns:yahoo="http://www.yahooapis.com/v1/base.rng"yahoo:count="0"yahoo:created="2012-11-03T17:23:30Z"yahoo:lang="en-US"><diagnostics><publiclyCallable>true</publiclyCallable><cacheexecution-start-time="1"execution-stop-time="1"execution-time="0"method="GET"type="MEMCACHED"><![CDATA[http://www.bhphotovideo.com/robots.txt]]></cache><urlerror="Connect Failure"execution-start-time="2"execution-stop-time="9"execution-time="7"proxy="DEFAULT"><![CDATA[http://www.bhphotovideo.com/robots.txt]]></url><forbidden>An error caused the engine to disallow robots for this domain</forbidden><urlerror="Redirected to a robots.txt restricted URL: http://www.bhphotovideo.com/c/product/870175-REG/Canon_EOS_Rebel_T4i_Digital.html"execution-start-time="1"execution-stop-time="9"execution-time="8"http-status-code="403"http-status-message="Forbidden"proxy="DEFAULT"><![CDATA[http://www.bhphotovideo.com/c/product/870175-REG/Canon_EOS_Rebel_T4i_Digital.html]]></url><user-time>9</user-time><service-time>15</service-time><build-version>31453</build-version></diagnostics><results/></query>

Now I know I am not going crazy as I see others have my problems. I scraped html content from a site with our church calendar using yql. However, all I am getting is nothing, null content with no errors. I tried the REST query in a web browser and still nothing. Please see my approach below:

The xpath was copied using firebug and pasted into the console. This is the code snippet I put in my mobile app (Titanium web view ):

<title>RCCG NA Events</title>

What am I doing wrong? Please help, I have tried without luck to solve this on my own for 2 months now. I also tried scraping from CNN just in case the issue if what my website and still no content returned.

Thx Paul for your response. However, I am not clear which part of my code above constitutes dynamic html rendering. All I am doing is following the YQL Reuse of HTML content example given at this URL: http://coding.smashingmagazine.com/2010/12/21/yql-using-web-content-for-non-programmers/

If there's another way to reuse my calendar content at the url given (copied within xpath). Please help me discover such. I am not trying to create another webpage in my mobile app but use the calendar content.

As Paul mentioned, the entire calendar on the page you're trying to scrape from is being generated by Javascript; it cannot be scraped unless the Javascript is executed. If you disable Javascript on the browser you use, you'll find that the calendar does not appear at all. Ideally the calendar should be created server-side if you want to scrape it.