Can you enable network debugging and see if the data is being returned from the downstream service?

http://developer.yahoo.com/yql/guide/yql-n...rk-logging.html

Same here, this is working from my home IP in the UK

http://query.yahooapis.com/v1/public/yql?q...amp;format=json

But for the past 24 hours my US servers return this -



Notably it also works as expected in the YQL Console



Giving me the diagnostics -

The guys at webfaction have just pointed out to me that the headers being returned from the request failing from their servers (that has been working for months) are -



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

Same issue:
http://developer.yahoo.net/forum/?showtopic=8288

My application also recently stopped receiving results. We've been using the following query for a while (replacing the url parameter).



From my dev host I receive results, the query above returns:



When the same is run from my production host (this is located at a different datacenter w/ a different IP) I get the following:


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.

Same problem: http://developer.yahoo.net/forum/index.php?showtopic=8297

Any update, Yahoo?

I'm also seeing this problem geographically scattered in my app. In my browser here in northeast US it's fine. In other regions, including out west and on an iphone it's failing.

I think it's fixed. Thanks, YQL team. But next time if you could give us some updates or an ETA that would be awesome.

I can confirm, it does seem to be working again.
Thanks YQL peeps.

Working great now thanks YDN techs. I'd better start to look at backing up results locally just in case from now on :)

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?

Looks like this exact same problem is happening again. YQL guys?

I'm getting this as well. I get results intermittently. I'm just in testing stages right now, but I'll get maybe one or two requests that will return results, and then nothing for a long time(hours).

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.

this issue is stillpresent

I'm getting this issue. In my case I'm getting empty result sets most of the time. Results only sporadically. My location is Brazil

I'm seeing this same issue.  My example YQL query is

select * from html where url="http://groups.google.com/group/sfrandon/msg/3e480d804c7069ee" and xpath='//div[@id="inbdy"]'

This works fine from the YQL console, but not when I ping the resulting REST url, where I'm getting an error:

http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20html%20where%20url%3D%22http%3A%2F%2Fgroups.google.com%2Fgroup%2Fsfrandon%2Fmsg%2F3e480d804c7069ee%22%20and%20xpath%3D'%2F%2Fdiv%5B%40id%3D%22inbdy%22%5D'&diagnostics=true

Should also note I've been using the above YQL query for the past few years and it's previously been working fine.  

Same Problem, some time from some PC, it's working fine, some time from some system it's not working at all.

Come on YQL guys, Its time to be as consistent as Google.

Same problem here. Could this please be solved?
 

<?xml version="1.0" encoding="UTF-8"?>
<query xmlns: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>
    <cache execution-start-time="1" execution-stop-time="1"
      execution-time="0" method="GET" type="MEMCACHED"><![CDATA[http://www.bhphotovideo.com/robots.txt]]></cache>
    <url error="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>
    <url
      error="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>
 

Dizzy,

That link works now. It could be that bhphoto was down for whatever reason or their robots.txt wasn't available and the result was cached.

Should be working now.

Thanks -Paul
YQL Team

The Query doesn't seem to be working, again...

$url='http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%3D%22'.$SSymbol.'%22&format=json&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys';

I'm seeing the same issue

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:

YQL console entry: select * from html where url="http://www.rccgna.org/RCCGEvents/Calendar.aspx" and xpath='//*[@id="gListEvents"]'

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.

Sorry my code didn't show in my previous post for some odd reason. Here is the rest of it:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />


    <title>RCCG NA Events</title>
</head>

<body>

<div id="gListEvents"> </div>
<script>
    function rccgnaCal(data){
      if(data.results){
        var cal = document.getElementById('gListEvents');
        cal.innerHTML = data.results[0];
      }
    }
</script>
<script src = "http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20html%20where%20url%3D'http%3A%2F%2Fwww.rccgna.org%2FRCCGEvents%2FCalendar.aspx'%20and%20xpath%3D'%2F%2F*%5B%40id%3D%22gListEvents%22%5D'&diagnostics=true&format=xml&callback=rccgnaCal">
</script>
</body>
</html>

Bisi,

The YQL html page can't read HTML that is dynamically rendered by Javascript. It's just parsing the HTML it gets from the server.

Thanks -Paul YQL Team

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.

Sincerely and humbly hungry for a solution.

This issue is present for me as well. No result from the REST query (copied directly from the console) but the console returns results.

http://query.yahooapis.com/v1/public/yql?q=use%20%22store%3A%2F%2FJ5I5lv7jQ6y8IWTnEOFtpX%22%20as%20market_combined%3B%20%0Aselect%20*%20from%20market_combined%20where%20password%3D%22wow%22%20and%20symbols%3D%22YAHOO~GOOG~PBY%22%20and%20show_raw%3D%22false%22%20and%20show_overview%3D%22false%22%20and%20show_current%3D%22false%22%20and%20show_historic%3D%22false%22%20and%20interval%3D%22d%22%20and%20start_year%3D%222011%22%20and%20start_month%3D%229%22%20and%20start_day%3D%2210%22%20and%20end_year%3D%222011%22%20and%20end_month%3D%229%22%20and%20end_day%3D%2211%22%3B

(This request has wrong password, but should return a response that indicates the password is wrong)

Ironically using "desc market_combined" does seem to return results, and other YQL REST queries do work.

All of these queries have worked for months, but today I suddenly notice that its not working...... whats up?

Hi Bisi,

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.