Databases
StackOverflow2013
Postsdbo
POGoogle apps script update fusion table from spreadsheet script
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POGoogle apps script update fusion table from spreadsheet script
    primarykey
    data
    text
    <p>I would like to create an apps script in a google docs spreadsheet that will periodically copy rows from the sheet and insert them into a fusion table. Below I've pasted my best attempt, but it should be noted that I really want it to be posting a 2 column range, not that pair of values. That is just a placeholder.</p> <p>This link here describes how to talk to fusion tables <a href="http://code.google.com/apis/fusiontables/docs/developers_guide.html#Inserting" rel="nofollow">http://code.google.com/apis/fusiontables/docs/developers_guide.html#Inserting</a> </p> <p>But I dont understand how to write the script to achieve this. I've messed around with it a bunch and I think I have these problems </p> <p>-I'm not forming the post request correctly -I'm missing some sort of authentication step.</p> <p>I am a total newb and what I have here is copy pasted. A few resources that looked helpful:</p> <p>This guy seems to have figured out how to write an app script to send post requests <a href="http://blog.vivekhaldar.com/post/428652690/google-apps-script-spreadsheets-mashup-hub" rel="nofollow">http://blog.vivekhaldar.com/post/428652690/google-apps-script-spreadsheets-mashup-hub</a> </p> <p>This seems to be important</p> <pre><code>http://code.google.com/googleapps/appsscript/class_urlfetchapp.html </code></pre> <p>these people seem to be doing somthing very similiar, but I cant figure out how to make it work</p> <pre><code>http://groups.google.com/group/fusion-tables-users-group/browse_thread/thread/99db4db33e405f01 function deet() { var advancedArgs = { method: "post", payload: "?sql=" + "INSERT INTO 1299801(Text, Number) VALUES ('Blue Shoes', 50)", headers: {"Authorization": "Basic &lt;base64 encoding of your username:passwd"}}; var response = UrlFetchApp.fetch( "https://www.google.com/fusiontables/api/query",advancedArgs); } </code></pre> <p>Thanks in advance!</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USEric Koleda
    1. USmax
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POGoogle apps script update fusion table from spreadsheet script
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POGoogle apps script update fusion table from spreadsheet script
      1. USadrienne
      1. VTFavorite
    3. VO
      singulars
      1. POGoogle apps script update fusion table from spreadsheet script
      1. USuser77115
      1. VTFavorite
    1. CODoes all the answers below don't help ?
      singulars
      1. POGoogle apps script update fusion table from spreadsheet script
      1. USDino
 

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