There is also a Google Apps script version of Getting data out of scraperWiki. It uses the mcpher library and the test data and examples can be found in this Google Document
function testScraperWikiWhatWorks() { mcpher.swSeewhatworks ("scraperWiki"); }
And here is how to get data to a particular worksheet from a given short Name.
function testScraperWikiInput() { testScraperWikiData (mcpher.InputBox("shortname?")); } function testScraperWikiData(shortName) { mcpher.scraperWikiStuff (shortName, "scraperwikidata"); }
For more information on scraperWki and how this works, see the Excel version. Here’s an example of data retrieved into Google Apps Script.
Transitioning is covered more comprehensively in my book, Going Gas – from VBA to Apps script.
bruce mcpherson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Based on a work at http://www.mcpher.com. Permissions beyond the scope of this license may be available at code use guidelines