Getting data out of scraperWiki. It uses the mcpher library and the test data and examples can be found in this Google DocumentThere is also a Google Apps script version of
There is a rest library entry to populate a google spreadsheet with public data available in scraperWiki. Here's how to find out whether there are any tables associated with each one.
Here's an example of a scraperwiki mashup that's been converted from VBA.
And here is how to get data to a particular worksheet from a given short Name.
For more information on scraperWiki and how this works, see the Excel version. Here's an example of data retrieved into Google Apps Script.
The code, and how to include it in your project can be found in the mcpher library , at this Gist, and below.
As an aside, here's an interesting way to combine these multiple APIS into one. For more like this, take a look at how the From VBA to Google Apps Script. In the meantime why not join our forum,follow the blog or follow me on twitter
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > From VBA to Google Apps Script >