0

YQL Failing with datatables.org env

When I try to use env=http://datatables.org/alltables.env I get the following error some of the time.

CODEBOX
{
"error": {
"lang": "en-US",
"diagnostics": {
"publiclyCallable": "true",
"warning": "Cannot load an external table environment file from http://datatables.org/alltables.env"
},
"description": "No definition found for Table yahoo.finance.quotes"
}
}


This seems to be on Yahoos end because I am not seeing the datatables.org env file ever become unavailable.

You can easiiy reproduce this by going to this page on the console and clicking test a couple of times. I consistently have it fail in the first four tries.

by
22 Replies
  • are you seeing this error on the console or when using the REST endpoint?

    e.g. hhttp://query.yahooapis.com/v1/public/yql?q=SELECT%20*%20FROM%20yahoo.finance.quotes%20where%20symbol%20IN%20('AMZN')&diagnostics=true&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys


    Also use store://datatables.org/alltableswithkeys as your env value.

    e.g. env=store://datatables.org/alltableswithkeys

    store:// is our YQL store version of datatables.
    0
  • I get this error using both the console and the api. I have switched to using the store://datatables.org/alltableswithkeys env but it is still failing about as often.
    0
  • Thanks, we're taking a look.

    -P
    0
  • issue is resolved.


    thanks -paul
    0
  • Looks like this is still a problem - as trying the query from the console app returns the same error this evening.
    0
  • QUOTE (Lance @ Jan 3 2011, 07:02 PM) <{POST_SNAPBACK}>
    Looks like this is still a problem - as trying the query from the console app returns the same error this evening.


    Seems www.datatables.org is down. Can somebody please take a look? The REST API and console queries both fail for stock quotes.
    0
  • www.datatables.org is currently down :a hopefully someone in Yahoo will take appropriate measures to take it in traffic
    0
  • Is yql set on sunset? at least the open tables?

    You can not expect that anyone will ever trust in yql.
    Whats going on?

    regards roman
    0
  • Still happening. Datatables.org doesn't resolve.
    0
  • Yes, currently datatables.org seems to be not reachable. In the meantime everyone may have a look into the github repo , to host it on your own server.
    0
  • QUOTE (M K @ Jan 4 2011, 09:03 AM) <{POST_SNAPBACK}>
    Yes, currently datatables.org seems to be not reachable. In the meantime everyone may have a look into the github repo , to host it on your own server.


    Can anyone elaborate as to what the directory/URI structure should look like in order to set this up locally?

    Thanks.
    0
  • datatables.org is experiencing DNS resolution issues and we are actively working on this. As a result, any community table won't work.

    You can still use and access the community tables by using the IP of datatables.org in your env. For example:

    Console:

    http://y.ahoo.it/tr2YoxO3

    REST endpoint:

    http://query.yahooapis.com/v1/public/yql?q...alltablesip.env


    Once the datatables.org domain resolves I would revert back to using the domain vs. IP in your env.


    Thanks -Paul
    0
  • datatables.org is back. Sorry for the downtime!

    -Paul
    0
  • QUOTE (Paul Donnelly @ Jan 4 2011, 12:04 PM) <{POST_SNAPBACK}>
    datatables.org is back. Sorry for the downtime!

    -Paul


    Thanks Paul.
    0
  • What was the reason for that?
    0
  • QUOTE (stachrom @ Jan 4 2011, 01:21 PM) <{POST_SNAPBACK}>
    What was the reason for that?


    the domain was transfered from one registrar to another..
    0
  • QUOTE (Paul Donnelly @ Jan 4 2011, 12:04 PM) <{POST_SNAPBACK}>
    datatables.org is back. Sorry for the downtime!

    -Paul


    Paul --

    Can you verify this please? I have not been able to make a request from my application since Wednesday night.

    Peace,
    Scott
    0
  • I'm having an issue with the yahoo.finance.options table. My query works fine in the yql console. However when I try to copy and paste the REST query into a URL I am getting a "bad request" error.

    Any help would be greatly appreciated.

    YQL:
    CODE
    SELECT * FROM yahoo.finance.options WHERE symbol='GOOG' AND expiration='2010-06'


    URL: [link]http://query.yahooapis.com/v1/public/yql?q=SELECT%20*%20FROM%20yahoo.finance.options%20WHERE%20symbol%3D'GOOG'%20AND%20expiration%3D'2010-06'&diagnostics=true&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys[/link]
    0
  • Does anyone know why I would be getting this message as of yesterday morning?

    <?xml version="1.0" encoding="UTF-8"?>
    <error xmlns:yahoo="http://www.yahooapis.com/v1/base.rng" yahoo:lang="en-US"><description>Could not load table yahoo.finance.quotes from http://www.datatables.org/yahoo/finance/ya...;</error>

    The following URL works through YQL but no longer works from my application

    "http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20(%22YHOO%22%2C%22AAPL%22%2C%22GOOG%22%2C%22MSFT%22)&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys"

    Any guidance would be much appreciated.

    Peace,
    Scott
    0
  • Scott,

    I'm getting the same when trying to use the yahoo.finance.options query. When I dug under the covers, I found that this query just scrapes the yahoo web site content. The problem I'm experiencing is that yahoo thinks that my request is a bot and blocks it. You may be experiencing the same issue.

    To reproduce, copy and paste the following url in your browser:
    YQL Xpath Query

    I get the following result back:
    CODE
    <?xml version="1.0" encoding="UTF-8"?>
    <query xmlns:yahoo="http://www.yahooapis.com/v1/base.rng" yahoo:count="0" yahoo:created="2011-01-28T20:14:54Z" yahoo:lang="en-US">
    <diagnostics>
    <publiclyCallable>true</publiclyCallable>
    <url error="Requesting a robots.txt restricted URL: http://finance.yahoo.com/q/op?s=C&amp;m=2011-02" execution-time="1" http-status-code="403" http-status-message="Forbidden" proxy="DEFAULT"><![CDATA[http://finance.yahoo.com/q/op?s=C&m=2011-02]]></url>
    <user-time>1</user-time>
    <service-time>1</service-time>
    <build-version>10970</build-version>
    </diagnostics>
    <results/>
    </query>
    <!-- total: 2 -->
    <!-- engine1.yql.mud.yahoo.com -->
    0
  • Thanks, but I'm not seeing that on a browser request. I get:

    <query yahoo:count="30" yahoo:created="2011-01-28T22:20:03Z" yahoo:lang="en-US">

    <diagnostics>
    <publiclyCallable>true</publiclyCallable>
    <url execution-time="300" proxy="DEFAULT">http://finance.yahoo.com/q/op?s=C&m=2011-02</url>
    <user-time>306</user-time>
    <service-time>300</service-time>
    <build-version>10970</build-version>
    </diagnostics>
    +
    <results>
    ...
    </results>
    </query>
    <!-- total: 310 -->
    <!-- engine1.yql.ac2.yahoo.com
    0
  • the problem is still there please fix it.. it's very unstable

    0

Recent Posts

in YQL