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.

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.

Thanks, we're taking a look.

-P

issue is resolved.


thanks -paul

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.

www.datatables.org is currently down :a hopefully someone in Yahoo will take appropriate measures to take it in traffic

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

Still happening. Datatables.org doesn't resolve.

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.

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

datatables.org is back. Sorry for the downtime!

-Paul

Thanks Paul.

What was the reason for that?

the domain was transfered from one registrar to another..

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:

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]

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

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:

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

Paul --

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

Peace,
Scott