Hi. Is tiny.cc/InstConAPI still available or available elsewhere ? When I type that address into my browser (Chrome, latest updates) I get a page that starts with .."Sorry, we weren't able to locate that URL"
Would you mind sharing, I cant seem to find it on GitHub or anywhere else for that matter!
In my Google sheet I've been simplifying the construction of the parameters, as it's so easy to make a typo.
I'll be happy to share it with you and the community if it's of any use ….
You should be able to download the sheet from here: ImportJSONSheet - ambiently fork for Canvas Community - Google Sheets
IMMEDIATELY TAKE A COPY OF THE SHEET AND USE THAT COPY OR YOU MAY LEAVE IMPORTANT DATA IN IT FOR EVERYONE TO SEE AND USE - SUCH AS YOUR ACCESS TOKEN - AND THAT WOULD BE BAD FOR YOUR STUDENTS, YOUR INSTITUTION ... AND YOUR CAREER !
Let me know if that doesn't work or you have any issues using it.
... and don't forget to take that copy - and use that copy not the original !
We got this working. The formula is populating the spreadsheet with data from Canvas. However, the data is limited to just 100 rows. We've searched for a solution but haven't found one. Anyone experience this issue and find a fix?
We're using the "per_page=10000" argument.