// grab your spreadsheet's ID / "key" from the URL to access your doc...
// e.g. everything after "key=" in the URL: https://docs.google.com/spreadsheet/ccc?key=0Ak-N8rbAmu7WdGRFdllybTBIaU1Ic0FxYklIbk1vYlE
// make sure stop as soon as you hit an ampersand, those are additional URL parameters we don't need
public static ListFeed GetSpreadsheet(string spreadsheetID)
{
// We need this fake certificate to trick Mono's security to use HTTPS... doesn't work in webplayer's security sandbox
InsecureSecurityCertificatePolicy.Instate();
var service = new SpreadsheetsService("UnityConnect");
var listQuery = new ListQuery("https://spreadsheets.google.com/feeds/list/" + spreadsheetID + "/default/public/values");
return(service.Query(listQuery));
}
// grab your spreadsheet's ID / "key" from the URL to access your doc...
// make sure stop as soon as you hit an ampersand, those are additional URL parameters we don't need
public static ListFeed GetSpreadsheet(string spreadsheetID, int gridId)
{
// We need this fake certificate to trick Mono's security to use HTTPS... doesn't work in webplayer's security sandbox
InsecureSecurityCertificatePolicy.Instate();
SpreadsheetsService service = new SpreadsheetsService("UnityConnect");
string url = "https://spreadsheets.google.com/feeds/list/" + spreadsheetID + "/" + gridId + "/public/values";
ListQuery listQuery = new ListQuery(url);
ListFeed feed = service.Query(listQuery);
return(feed);
}
public static SpreadsheetListFeed GetSpreadsheetContents(string spreadsheetID, string sheetID)
{
InsecureSecurityCertificatePolicy.Instate();
SpreadsheetListFeed listFeed = null;
string json = "";
string url = "https://spreadsheets.google.com/feeds/list/" + spreadsheetID + "/" + sheetID + "/public/basic?alt=json";
HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(url);
try {
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) {
using (StreamReader reader = new StreamReader(response.GetResponseStream())) {
json = reader.ReadToEnd();
}
}
// Debug.Log(string.Format("Response from {0}\n{1}", url, json));
listFeed = JsonMapper.ToObject <SpreadsheetListFeed>(json);
}catch (Exception e) {
Debug.LogWarning("Failed to read spreadsheet: " + spreadsheetID + " " + e.Message);
listFeed = null;
}
return(listFeed);
}
