網頁

2014年3月18日 星期二

Google Spreadsheets API

使用 Google Spreadsheets API 搭建在线应用


利用 Google 問卷(試算表)當小型資料庫__更新版__(一)製作資料庫



https://spreadsheets.google.com/feeds/list/0AikclfTTti-0dHlSSnRRR0w5eGFzRExRTWRjbWNLN0E/od6/public/values?alt=json-in-script


https://docs.google.com/spreadsheets/d/1vUKbIhXPdoct6HXrBlvYJWRtX4KiUIMy1ICMuWAOgp8/pubhtml

https://spreadsheets.google.com/feeds/list/1vUKbIhXPdoct6HXrBlvYJWRtX4KiUIMy1ICMuWAOgp8/od6/public/values?alt=json


Use a Google Spreadsheet as your JSON backend

Using the Google Spreadsheets Data API to build a Recommended Reading List - Code Words


 
       items.push('
  • '+entry.gsx$name.$t+'
  • ');


    JavaScript 存取 google spreadsheets 試算表



    https://docs.google.com/spreadsheet/pub?key=0Asp3dPzRohcndHE4dE0xNXFWWTI2d0dvN1g4VmRQOWc&single=true&gid=1&tq=select%20d&output=html
    https://spreadsheets.google.com/tq?tqx=out:html&key=0Asp3dPzRohcndHE4dE0xNXFWWTI2d0dvN1g4VmRQOWc&gid=1&tq=select%20D%20limit%205

    PS. 新版Google Sheets生成的key不能使用Google Sheets API的語法

    Query Language Reference (Version 0.7) Use the tool to encode or decode a query string:




    Getting JSON data from Google spreadsheets and using it in Google maps

     json 1000 limit 
    $.getJSON('https://spreadsheets.google.com/feeds/list//od6/public/values?alt=json', function(data) {
           
    for (var i = 0; i < data.feed.entry.length; i++) {
     
      var id = data.feed.entry[i].gsx$benchid.$t;
      var photo = data.feed.entry[i].gsx$photourl.$t;
      var caption = data.feed.entry[i].gsx$captionoptional.$t;
      var string = '' + caption + '
    '; var lat = data.feed.entry[i].gsx$lat.$t; var long = data.feed.entry[i].gsx$long.$t; createMarker(lat, long); createInfoWindow(id, string); };

    沒有留言:

    張貼留言

    注意:只有此網誌的成員可以留言。