FAQ Database Discussion Community


unauthorized_Client while refreshing google access token

curl,google-fusion-tables,access-token
I want to upload a csv file to fusion table using curl. I created client id and secret using developer console. Then I generated access token using google playground link. using the generated access token, I could successfully import data in fusion table from csv file. Now, the problem is...

Can't SELECT DISTINCT via Google Fusion Tables REST API

sql,google-apps-script,google-fusion-tables
In my Fusion Table, my State Abbr. column contains many duplicate values; and I only want to list the different values. So I tried querying the table with SELECT DISTINCT 'State Abbr. FROM <table_id>' But I got the error below; so, I guess that it doesn't like SELECT DISTINCT Invalid...

How can I Write Where Query in Fusion Tables

mysql,google-fusion-tables
I want to select all the coordinates(latlong) where user_id(a Number) = 1 from the fusion table.. I tried using var tableid = "1WjowbI77j1WFcn3IEtbwBymhVZh8jfmP_dg1epd9"; var key = "AIzaSyCALoSz00ZY3zTL1D_xUTD9GMb3T1ocBdU"; var query = "SELECT * FROM "+tableid+"&key="+key+" WHERE user_id=1"; var url = "https://www.googleapis.com/fusiontables/v2/query?sql="+query didn't work.. Errors : GET...

How to compare innerHTML string?

javascript,google-maps,innerhtml,google-fusion-tables
Is it possible to get the results of "fusiontabledata" and "fusiontabledata2", compare both and generate a third "sidebar" showing only the duplicates? document.getElementById('sidebar_1').innerHTML = fusiontabledata; document.getElementById('sidebar_2').innerHTML = fusiontabledata2; function getData_From(response) { FTresponse = response; numRows = response.getDataTable().getNumberOfRows(); numCols = response.getDataTable().getNumberOfColumns(); fusiontabledata = "<table><tr>"; fusiontabledata += "</tr><tr>"; for (i =...

'500 Backend Error' on Google Fusion Table Insert Table

google-fusion-tables
I would like enable a user to create a new Fusion Table through my application. gapi.client.load('fusiontables', 'v2').then(function() { var request = gapi.client.fusiontables.table.insert({ 'columns' : [{ 'name': 'test' }], 'isExportable' : true, 'name' : 'Foobar', }); request.then(function(resp) { alert(resp) }, function(reason) { console.log(reason); alert('Error: ' + reason.result.error.message); }); }); Everything appears...

Toggle custom legend on google maps using a radio button

javascript,html,google-maps,google-maps-api-3,google-fusion-tables
I created a legend for a google map using the following code from Google Developers Website <title>Fusion Tables Layer Example: Legend</title> <link href="/apis/fusiontables/docs/samples/style/default.css" rel="stylesheet" type="text/css"> <script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"></script> <style type="text/css"> #legend { background: #FFF; padding: 10px; margin: 5px; font-size: 12px; font-family: Arial, sans-serif; } .color { border: 1px solid; height:...

import data from Google fusion table into Google spreadsheet

android,google-apps-script,google-spreadsheet,google-fusion-tables
I'm making a decent IT-inventory system using Google Drive. I wrote an Android app (using app inventor) that allows me to scan the barcode of a pc and add some comments to it. That data gets stored in a Google Fusion Table. (Date | PC-code | Task) Now I want...

Google Maps Fusion Table API SQL “LIKE” command not working

javascript,sql,google-maps,google-maps-api-3,google-fusion-tables
I'm using Google Maps API to pull data from a Fusion Table based on user input. I trying to use the "LIKE" command to create a more robust search feature, however anything other than simple where queries (like where x=y or x>y) seems to return every entry or no entry...

Write Query to Compare time in google fusion table

sql,google-fusion-tables
I want to get all the entries from google fusion table which satisfies the condition in a given date Time column > specific time https://www.googleapis.com/fusiontables/v2/query?sql=SELECT * FROM 1WjowbI77j1WFcn3IEtbwBymhVZh8jfmP_dg1epd9 WHERE Date = '2015-02-23' AND Time > '10:25:04'&key=AIzaSyCALoSz00ZY3zTL1D_xUTD9GMb3T1ocBdU But it gives me all the entries as result.. fusion table : https://www.google.com/fusiontables/data?docid=1WjowbI77j1WFcn3IEtbwBymhVZh8jfmP_dg1epd9&key=AIzaSyCALoSz00ZY3zTL1D_xUTD9GMb3T1ocBdU#rows:id=1...

Highlight country around the border from your search area only

javascript,google-maps-api-3,kml,google-fusion-tables
I have to make a KML file from the Dutch country. What I want to do is: I want to Highlight only the countries around the border from my search area. Example: As a user searches on 'Amsterdam'. There are like 9 (Zaandam, Amstelveen, Hooftdorp, Diemen, Duivendrecht, ......) other states...

Displaying Data from a Google Fusion Table in a Table

json,api,google-fusion-tables
I am new to google fusion tables and was on the google developer website looking at examples. I made my own fusion table and tried to sub it in and it did not work. Here is my fiddle: http://jsfiddle.net/Dansker/xzrc31gp/. I think it is not working because of this: "dataSourceUrl": "//www.google.com/fusiontables/gvizdata?tq=",...

Create links to map markers in map created with Fusion Table

javascript,google-maps,google-fusion-tables
A map is being created like so (also see code at end of post). What I'm trying to create is a list of links which would point to the markers on the map, in order to recenter the map and display infowindows when the links are followed. This question and...

Angular $http and Fusion Tables in IE9

javascript,angularjs,internet-explorer-9,google-fusion-tables
I am trying a simple get request to a google fusion table in my angular controller. $http.get(url) .success(function(data) { //Do stuff with data }) This works in firefox, chrome, safari and IE10+ however in IE9 (Which I am requried to support) the request fails to even send and the console...

Does Fusion drop columns?

csv,google-spreadsheet,google-fusion-tables
I've got a CSV file with approximately 300 columns. Here's a sample of the columns: The file is almost 100mb. I've imported it into fusion tables using their GUI import through the browser. Here's what it looks like after import: As you can see all the way to the right...

How to share a private google doc with an appengine app

google-app-engine,google-oauth,google-fusion-tables
I have a document (its actually a fusion table) stored in my private Google Drive. I would like to share the document with a web application running on google app engine. I would like to enter the link to the document into the app and have it read the document...

App Inventor 2 - UPDATE SQL: Fusion table

sql,sql-update,google-fusion-tables,app-inventor
I'm trying to update a single field in an fusion table using AppInventor. I have successfully obtained the rowid using a select query and stored this value and displayed in a label. I then want to update a field for this row using the rowid obtained but the rowid is...

How make a list in the Info Window of a Fusion Map from a comma separated list?

google-fusion-tables
Can a cell with comma separated information be turned into a list? I've got uneven amounts of data (companies) and would like to just have it display as a basic List when the flag is clicked on in the Fusion Map. Say I have: Location: Seminole County, FL Companies: Acme...

How to highlight multiple countries on Google Maps using fusion table

jquery,google-maps,google-fusion-tables
I am trying to highlight multiple countries on Google Maps, but I am a little bit confused about the query. It works on a single country, e.g., if I highlight Mexico it works, but when try to highlight Mexico and India it does not work. jsFiddle I have tried the...

How import all information of location history KML file on Fusion Table?

kml,google-fusion-tables,location-history
I exported the KML file from locationhistory of google maps. Thus, I try to create a Fusion Table using Google drive and importing this file. During the import I selected the row that contains column names. The columns created in fusion table are: description, name and geometry The Fusion Table...

Fusion Table with App Inventor: displaying map with location column

dictionary,geolocation,google-fusion-tables,app-inventor
I am using App Inventor 2 from MIT. I have a fusion table with location column of type location. Using the FusiontableControls component I am able to write into the table and view the table using the WebViewer component, I am able to view the URL of the Table and...