XHR cross origin failure when initializing tabletop with a query

[ghost]

initialization such as:

Tabletop.init({
    key: "ABCD",
    query: "select B, C",
    simpleSheet: true,
    callback: callback
});

fails with the following error:

XMLHttpRequest cannot load https://spreadsheets.google.com/feeds/list/ABCD/oq7ao2t/public/values?alt=json&sq=select%20B,%20C. No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'https://4afe0e27c254af279a8d9135ef7dbe31d78cf487.googledrive.com' is therefore not allowed access. The response had HTTP status code 400.

[sidvishnoi]

with new spreadsheets "sq" parameter doesn't work - line 321.
alternative - i don't know yet

[hiteshchavda]

+1

[hugolpz]

Note: The solution I found is to use an old spreadsheet which work, fork it (create copy), then rename it for the mission of the day. It's ugly but working.

[freder]

fails for me, too:

Tabletop.init({ key: key/*, callback: main*//*, simpleSheet: true*/ });

[kirps]

I also had this issue and have no old spreadsheets left from which to fork... also seems incredibly fragile...

[sidvishnoi]

appears now to query sheet data, we have to use client side JSON parsing

[Jmuccigr]

I think I'm getting bit by this too. Seeing Invalid query parameter value for sq. on what I think are valid queries (though there's no query example in the readme, so I'm not 100%).

[vena]

it appears the URL parameter in google's query language is now "tq"

https://developers.google.com/chart/interactive/docs/querylanguage

replacing &sq= with &tq= at line 323 appears to work for my simple use case.

[hugolpz]

Can someone confirm Vena's solution ? => pull request.

[jsoma]

Just cleaning up issues: it's in as tq, but pretty sure it still doesn't work