Search code examples
sqlapiyahooyqlyahoo-api

YQL query failing


I am executing the follwing YQL on fantasysports table.

select * from fantasysports.games where use_login=1 and game_key in ('238', '223', 'mlb', 'nfl')

But it is failing by giving the following response

<?xml version="1.0" encoding="UTF-8"?>
<query xmlns:yahoo="http://www.yahooapis.com/v1/base.rng"
yahoo:count="0" yahoo:created="2014-08-05T05:47:43Z" yahoo:lang="en-US">
<diagnostics>
    <publiclyCallable>true</publiclyCallable>
    <url execution-start-time="1" execution-stop-time="520"
        execution-time="519" http-status-code="500" http-status-message="INKApi Error">
    <![CDATA[http://fantasysports.yahooapis.com/fantasy/v2/users;use_login=1/games;game_keys=238,223,mlb,nfl]]></url>
    <user-time>520</user-time>
    <service-time>519</service-time>
    <build-version>0.2.2666</build-version>
</diagnostics> 
<results/>

Queries executed on other tables are working fine.


Solution

  • This appears to be a bug on the Yahoo side of things. It's been logged on the YQL Forum and the last update was a developer 5 days ago (31st July 2014) saying it was being looked into