Shared publicly  - 
1
Louise Egan's profile photoBruce Mcpherson's profile photoMartin Hawksey's profile photo
10 comments
 
Martin

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. ....

http://dashboardstaging.jorum.ac.uk/stats/licences/all/format.json

gives

{"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.
Bruce
 
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...