Google Apps 脚本从电子表格脚本更新融合表

问题描述

我想在 google docs 电子表格中创建一个应用程序脚本，该脚本将定期从工作表中复制行并将它们插入到融合表中.下面我粘贴了我的最佳尝试，但应该注意的是，我真的希望它发布一个 2 列范围，而不是那对值.那只是一个占位符.

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.

这里的这个链接描述了如何与融合表交谈http://code.google.com/apis/fusiontables/docs/developers_guide.html#插入

This link here describes how to talk to fusion tables http://code.google.com/apis/fusiontables/docs/developers_guide.html#Inserting

但我不明白如何编写脚本来实现这一点.我已经搞砸了一堆，我想我有这些问题

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

-我没有正确形成发布请求- 我缺少某种身份验证步骤.

-I'm not forming the post request correctly -I'm missing some sort of authentication step.

我是个新手，我这里的东西是复制粘贴的.一些看起来很有帮助的资源:

I am a total newb and what I have here is copy pasted. A few resources that looked helpful:

这家伙似乎已经想出了如何编写应用程序脚本来发送发布请求http://blog.vivekhaldar.com/post/428652690/google-apps-script-spreadsheets-mashup-hub

This guy seems to have figured out how to write an app script to send post requests http://blog.vivekhaldar.com/post/428652690/google-apps-script-spreadsheets-mashup-hub

这似乎很重要

http://code.google.com/googleapps/appsscript/class_urlfetchapp.html

这些人似乎在做一些非常相似的事情，但我不知道如何使它起作用

these people seem to be doing somthing very similiar, but I cant figure out how to make it work

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 <base64 encoding of your username:passwd"}};
  var response = UrlFetchApp.fetch(
      "https://www.google.com/fusiontables/api/query",advancedArgs);

}

提前致谢！

推荐答案

这是一个更新版本John McGrath 通过 Google Fusion Tables 小组编写的脚本，用于在 Google 之间创建手动同步"电子表格和 Google Fusion Table.

Here's an updated version of a script that John McGrath via the Google Fusion Tables group authored to create a manual "sync" between a Google spreadsheet and a Google Fusion Table.

我根据自己的需要稍微修改了脚本，并添加了 API 密钥和作为原始版本的新的 Fusion Tables API 端点版本使用 SQL API 端点，该端点正在逐步淘汰.

I've modified the script a bit for my needs and have added use of an API key and the new Fusion Tables API endpoint as the original version used the SQL API endpoint, which is being phased out.

要使用，只需将您的 Fusion Table 的加密表 ID 添加到脚本的顶部...

To use, simply add your Fusion Table's encrypted table ID to the top of the script...

// Add the encrypted table ID of the fusion table here
var tableIDFusion = '17xnxY......';

并添加您的 api 密钥...

// key needed for fusion tables api
var fusionTablesAPIKey = '17xnxY......';

这篇关于Google Apps 脚本从电子表格脚本更新融合表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，WP2