0

YQL not returning any data or error

I'm testing a query in the YQL console that is a valid XML document (as far as I can tell) but the console will simply not give me any data or any indication that there was a problem trying to retrieve the data. The diagnostics section contains no helpful data, and there is not a results section at all. Even running the console in debug mode gives no extra information. If I save a copy of the live XML feed and upload it to my server as an XML file the YQL query works fine.

The feed in question is:
CODE
select * from xml where url='https://cop.vdem.virginia.gov/gis_feeds/GeoRSS2.ashx'


When I run it in the YQL console, here is the output I get:
CODE
<?xml version="1.0" encoding="UTF-8"?>
<query xmlns:yahoo="http://www.yahooapis.com/v1/base.rng" yahoo:count="0" yahoo:created="2010-05-16T04:53:48Z" yahoo:lang="en-US">
<diagnostics>
<publiclyCallable>true</publiclyCallable>
<url execution-time="78" proxy="DEFAULT"><![CDATA[https://cop.vdem.virginia.gov/gis_feeds/GeoRSS2.ashx]]></url>
<user-time>79</user-time>
<service-time>78</service-time>
<build-version>6319</build-version>
</diagnostics>
<results/>
</query>


I've seen other instances where robots.txt rules or other issues prevent the query from successfully executing, but the diagnostics section includes those types of errors. I'm at a loss on this one. Please help!

by
5 Replies
  • Try this query: select * from html where url='https://cop.vdem.virginia.gov/gis_feeds/GeoRSS2.ashx'
    You will get the reason.

    Thanks
    ~jimmi
    0
  • QUOTE (Jimmi K @ May 16 2010, 10:12 PM) <{POST_SNAPBACK}>
    Try this query: select * from html where url='https://cop.vdem.virginia.gov/gis_feeds/GeoRSS2.ashx'
    You will get the reason.

    Thanks, but I still don't understand why there is an error. The response is shown below:
    CODE
    <query xmlns:yahoo="http://www.yahooapis.com/v1/base.rng" yahoo:count="0" yahoo:created="2010-05-18T08:31:33Z" yahoo:lang="en-US">
    <diagnostics>
    <publiclyCallable>true</publiclyCallable>
    <forbidden>An error caused the engine to disallow robots for this domain</forbidden>
    <url execution-time="126" proxy="DEFAULT"><![CDATA[https://cop.vdem.virginia.gov/robots.txt]]></url>
    <user-time>128</user-time>
    <service-time>126</service-time>
    <build-version>6319</build-version>
    </diagnostics>
    <results/>
    </query>

    It makes reference to a robots.txt file issue but there is no robots.txt file. What "error" caused the engine to disallow robots?
    0
  • I am having a very similar problem. The following query was working just fine to grab Yahoo Stocks:

    CODE
    select * from csv where url='http://download.finance.yahoo.com/d/quotes.csv?s=^DJI,^GSPC,^IXIC,ATK,ALV,CPB,CAG,CVG,DAL,LZB,NOVL,NUS,NUE,OSTK,STR,Q,SKYW,WFC,
    ZION&f=nl1c1p2&e=.csv'


    Now I simply get no data back from YQL:

    CODE
    <?xml version="1.0" encoding="UTF-8"?>
    <query xmlns:yahoo="http://www.yahooapis.com/v1/base.rng" yahoo:count="0" yahoo:created="2010-06-17T04:23:14Z" yahoo:lang="en-US">
    <diagnostics>
    <publiclyCallable>true</publiclyCallable>
    <user-time>2</user-time>
    <service-time>0</service-time>
    <build-version>8367</build-version>
    </diagnostics>
    <results/>
    </query>


    As suggested above, I have tried changing my query to html instead of csv, but I don't get any error messages back. Has Yahoo changed YQL so that queries like this no longer work? The csv url is valid, as you can paste it into your browser and get a valid csv file back. I don't understand what's happening.
    0
  • I am also get no results back from my YQL/datatable queries anymore. I'm doing a google image search which returns json and then some extra processing is done, but I never get any results back (I do when I go to the URL in the browser):

    CODE
    <urls>
    <url>http://ajax.googleapis.com/ajax/services/search/images?v=1.0&amp;q={artist}%20{album}%20release&amp;imgsz=medium|large|xlarge&amp;rsz=large</url>
    </urls>
    <inputs>
    <key id="artist" type="xs:string" paramType="path" required="true"/>
    <key id="album" type="xs:string" paramType="path" required="true"/>
    <key id="minRatio" type="xs:string" paramType="variable" required="false" default=".84"/>
    </inputs>


    When I run request.get().response it returns as undefined. I haven't changed this code in months and it's decided to just stop working.
    0
  • In searching these forums for robots.txt issues I have seen a number of people having issues with YQL servers improperly reading robots.txt files or even giving robots.txt errors when there is not robots.txt file present.

    Is there someone from Yahoo that can comment on these issues and if they are being addressed? If I have to wonder every time I'm developing an application using YQL if it will fail (even intermittently) because of some issue like this (that I can't even work around) then what is the point? None of the threads dealing with these issues (at least that I have seen) have any resolution to the problem.

    Please help!!!
    0

Recent Posts

in YQL