Databases
StackOverflow2013
Postsdbo
POAuthentication required even with public Google Fusion Tables?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAuthentication required even with public Google Fusion Tables?
    primarykey
    data
    text
    <p>The <a href="http://code.google.com/apis/fusiontables/docs/developers_guide.html" rel="nofollow noreferrer">Google Fusion Tables documentation</a> claims that you don't need to authenticate to retrive data from public Fusion Tables. </p> <p>However, I'm trying to access a public Google Fusion Table with the following code, and getting an authentication error (<code>Uncaught syntax error</code> in line 1 of a file called <code>ServiceLogin</code>.)</p> <pre><code>function getData(table) { var queryUrlHead = 'http://www.google.com/fusiontables/api/query?sql='; var queryUrlTail = '&amp;jsonCallback=?'; var query = "SELECT x, y, z FROM " + table + " LIMIT 5000"; var queryurl = encodeURI(queryUrlHead + query + queryUrlTail); var jqxhr = $.get(queryurl, dataHandler, "jsonp"); return jqxhr; } </code></pre> <p>I've also been looking at <a href="https://stackoverflow.com/questions/6181020/trouble-with-get-request-from-google-fusion-tables">this question</a>, which says that <a href="https://www.google.com/fusiontables/api/query?sql=SELECT%20Address%20FROM%20914142%20WHERE%20IsCustomer%20=%201" rel="nofollow noreferrer">this URL</a> is a public Fusion Table, but if I paste that URL into my browser I get asked for authentication. No matter how many times I authenticate and then retry the link in the browser, I get bounced back to login again. </p> <p>I'm using <a href="http://www.reddmetrics.com/2011/08/10/fusion-tables-javascript-query-maps.html" rel="nofollow noreferrer">this post as a guide</a>, but it doesn't mention the need for authentication anywhere: so what am I doing wrong? </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USRichard
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COI'm glad no-one tried to answer this. Turned out the table wasn't shared after all, or there was something weird going on with Google authentication - either way, works now.
      singulars
      1. POAuthentication required even with public Google Fusion Tables?
      1. USRichard
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload