Shared publicly  - 
Louise Egan's profile photoBruce Mcpherson's profile photoMartin Hawksey's profile photo

I added these 3 API variations to the rest-excel library - downloadable here (last 3 tabs) cDataSet.xlsm | share - it will take the json data directly into Excel. Only problem is that the API seems to have a database connectivity problem at the moment so I cant test it. ....


{"code":"500","url":"\/stats\/licences\/all\/format.json","name":"Database connection "Postgres" is missing, or could not be created."}

When it's back up again, I'll make a GAS version too. Might be useful for general testing.
Thanks for this, we are looking into the API.  All feedback is extremely helpful.
your apps scripting skill put me to shame (at least now I've got some examples to work from ;)
it was the library code I was admiring :)
Add a comment...