| function getJSON(aUrl,sheetname) { | |
| //var sheetname = "test"; | |
| //var aUrl = "http://pipes.yahoo.com/pipes/pipe.run?_id=286bbb1d8d30f65b54173b3b752fa4d9&_render=json"; | |
| var response = UrlFetchApp.fetch(aUrl); // get feed | |
| var dataAll = JSON.parse(response.getContentText()); // | |
| var data = dataAll.value.items; | |
| for (i in data){ | |
| data[i].pubDate = new Date(data[i].pubDate); | |
| data[i].start = data[i].pubDate; | |
| } |
This page guides you through the process of obtaining an HTTPS certificate for your site. This is a real certificate, not a self-signed certificate, and works in all major browsers.
The CA which we'll use is StartSSL. They provide basic certificates for free, although will charge for other types, such as wildcard certificates.
A keypair can be generated with OpenSSL:
| 1,2012-01-02,New Year Day | |
| 2,2012-01-16,Martin Luther King Jr. Day | |
| 3,2012-02-20,Presidents Day (Washingtons Birthday) | |
| 4,2012-05-28,Memorial Day | |
| 5,2012-07-04,Independence Day | |
| 6,2012-09-03,Labor Day | |
| 7,2012-10-08,Columbus Day | |
| 8,2012-11-12,Veterans Day | |
| 9,2012-11-22,Thanksgiving Day | |
| 10,2012-12-25,Christmas Day |
Python syntax here : 2.7 - online REPL
Javascript ES6 via Babel transpilation - online REPL
import math