In Getting lists as a restquery I showed how to get JSON back by querying the scriptDB directly. Here's how to consume that in VBA. This example is general purpose - it can be used for any scriptdb, and will adapt as required. It uses Rest to Excel library and can be downloaded in the latest cDataSet.xlsm workbook.
As with all restlibrary examples, we need to create an entry in the restlibrary - it looks like this
It will ask for the name of the library (probably "blister") and the listName - in this case below "airlines", and produce something that starts like this.
Obviously this could be easily consumed by anything that can interpret JSON
All comments, suggestions, assistance, good lists are welcome as I develop this capability. You can get me on Google plus, Twitter or this forum.
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Things that have been deprecated > GAS lists and validation > Getting lists as a restquery >