0

YQL The current table 'yahoo.finance.quotes' has been blocked

Lately I have been receiving table locked message very often when running yql query. Sometimes this error starts coming back after 2-3 calls. I am sure I am no way close to hourly/daily limit of API calls.

Query:
http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20(%22BAC%22)&format=json&env=http://datatables.org/alltables.env&diagnostics=true
Result:
{"query":{"count":0,"created":"2012-03-24T17:55:25Z","lang":"en-US","diagnostics":{"publiclyCallable":"true","redirect":{"from":"http://datatables.org/alltables.env","status":"301","content":"http://www.datatables.org/alltables.env"},"url":[{"execution-start-time":"137","execution-stop-time":"441","execution-time":"304","proxy":"DEFAULT","content":"http://datatables.org/alltables.env"},{"execution-start-time":"459","execution-stop-time":"506","execution-time":"47","proxy":"DEFAULT","content":"http://www.datatables.org/yahoo/finance/yahoo.finance.quotes.xml"}],"javascript":{"name":"yahoo.finance.quotes","verb":"select","content":"com.yahoo.platforms.pipes.model.ModuleException: Error Codes: js.blocked.execute.request Message: \"The current table 'yahoo.finance.quotes' has been blocked. It exceeded the allotted quotas of either time or instructions\""},"user-time":"509","service-time":"351","build-version":"26062"},"results":null}}Is there any known issue with yql and yahoo.finance.quotes? I will appreciate any help on this.

by
15 Replies
    • Mar 24, 2012
    I just experienced the same thing happening. Mine was more than 2-3 calls, but it was OAuth signed, and no more than maybe 50 calls. This is very disruptive, what's going on?
    0
  • It started working for me wthin an hour this time. Sometimes it errors out for few hours. There seems to be a bug in yql query to Yahoo Finance tables. I have noticed that csv api works even when yql query returns error. I hope I don&#39;t have to switch to csv api due to this bug, yql is way cleaner approach &nbsp;<br><br><div class="quote "><div class="quotetop ">QUOTE<cite>( @ 24 Mar 2012 12:58 PM)</cite><blockquote class="quotemain">I just experienced the same thing happening. Mine was more than 2-3 calls, but it was OAuth signed, and no more than maybe 50 calls. This is very disruptive, what&#39;s going on?</blockquote></div></div>
    1
  • This is happening again today. YQL is such a great service and its frustrating to see it not working due to this bug. Is anyone from Yahoo available to look into this issue?
    0
  • I am experiencing the same issue. See my thread called &quot;Finance Data Rate Limit&quot;
    0
  • Habib,<br>Did you receive any information from the forum about this issue?<br><br><div class="quote "><div class="quotetop ">QUOTE<cite>(Habib @ 26 Mar 2012 11:02 AM)</cite><blockquote class="quotemain">I am experiencing the same issue. See my thread called &quot;Finance Data Rate Limit&quot;</blockquote></div></div>
    0
  • Habib,<br>Did you find any information from the forum about this issue?&nbsp;
    0
  • Happened again on 3/26/2012 @ 8:50pm.
    0
  • I am still waiting for an answer...<br><br><div class="quote "><div class="quotetop ">QUOTE<cite>(Dipen @ 26 Mar 2012 3:24 PM)</cite><blockquote class="quotemain">Habib,<br>Did you find any information from the forum about this issue?&nbsp;</blockquote></div></div>
    0
  • Guys,<br><br>This is a community contributed table and used by multiple people. We mark a table as abusive if it seems to be hogging our resources, or consistently taking more than 30s to execute (this could also be due to a slow downstream source). This particular table seems to be getting marked as abusive more times than others. We also remove our blocks after a while, hence the sporadic working of the table.<br><br>I would advise that you wait for official tables from Yahoo! Finance if your application needs a stabler data source.<br><br>Sriram
    2
  • Sriram,<br>Thanks for your reply and providing information on this blocking. Are you aware of any plans and/or timeline for official Yahoo! Finance tables?<br><br><br><div class="quote "><div class="quotetop ">QUOTE<cite>(Sriram @ 27 Mar 2012 3:56 PM)</cite><blockquote class="quotemain">Guys,<br><br>This is a community contributed table and used by multiple people. We mark a table as abusive if it seems to be hogging our resources, or consistently taking more than 30s to execute (this could also be due to a slow downstream source). This particular table seems to be getting marked as abusive more times than others. We also remove our blocks after a while, hence the sporadic working of the table.<br><br>I would advise that you wait for official tables from Yahoo! Finance if your application needs a stabler data source.<br><br>Sriram</blockquote></div></div>
    0
  • Is there any word on when an official Yahoo! Finance table will be available? Please let me know if there is one available.

    0
  • Any update on this Sriram, or someone from Yahoo?

    I'm getting the same problem in my app and will probably have to look at another data API if this is going to be an ongoing issue.

    0
  • I'm getting the same problem in my app. Can someone look into this?

    0
  • Hi Sriram, I'm not sure what means "community contributed table", but is there something users can do to have more stability? Cheers.

    0
  • Hi guys,

    http://www.datatables.org/ should explain what is meant by a community contributed table - these are essentially written by non-Yahoos, hosted on Github, and are not officially supported.

    I am not sure when or if any official Yahoo! Finance tables will be released.

    Thanks, Sriram

    1

Recent Posts

in YQL