API Calls Made Simple- Curtis Rose

[awilliams]

With a simple-to-use Google Sheet, with only one plugin, anyone can make basic API calls without the need of assistance from a programmer or IT department. This easy-to-use form allows for customized reports that can be updated live as needed.

[padmaja_mandali]

Is the link tiny.cc/InstConAPI  still available. I get to the google sheet with the link but get viewer access only. I requested access. Is access to the google sheet on request basis only?Am I missing something ?

[brian_t_anders]

Padmaja,

You have to save a copy of the spreadsheet. The code you need will be in the copy of the script editor.

[Alexandre_Sch]

Wow! That looked nice! 

I saved the sheet and tried to populate the informations, but i'm receiving: 

"returned code 401. Truncated server response"  Not authenticated

=ImportJSON("https://XXXX.beta.instructure.com/api/v1/users/39?per_page=1000&acess_token=(this is a User access token or a account token, if it is a account, what is the URI that need to be set? ", "/sis_user_id", "noInherit, noHeaders")

Any help on how to make this work? 

Regards,
Alexandre Schneider.

[brian_t_anders]

alexandre.schneider@centrouniversitariofam.com‌

Can you try the request without the ...,"/sis_user_id", "noInherit, noHeaders"... part?

[audra_agnelly]

alexandre.schneider@centrouniversitariofam.com‌

I used the following value in the first cell and the sheet populated as expected:

=ImportJSON("https://XXXX.beta.instructure.com/api/v1/users/213220?per_page=10000&access_token=XXXXXXXXXXXXXX", "/sis_user_id", "noInherit, noHeaders"

The access token is your account token, in this case you'd also need to make sure you're using a token valid in Beta. Anyone can obtain a token, but your ability to run an API call is based on your user permissions. Are you a Canvas Admin at your institution with the ability to look up users? If not, you wouldn't be able to run this API call. Try pasting https://XXXXX.beta.instructure.com/api/v1/users/39 into your browser after logging into Canvas, does that return JSON data?

[Alexandre_Sch]

Hi Brian, yeah i tried that and still not working!

[Alexandre_Sch]

Hi Audra, how are you? Still did not tried to do it, will return as soon as i try what you mentioned. Regards!

[gsaito]

I'm a Canvas admin and I tried the following, but I'm getting an error (see image below).  Any suggestions?

=ImportJSON(https://paloaltou.beta.instructure.com/api/v1/users/1176?per_page=100&access_token=xxxx, "/sis_login_id,/email,/name", "noInherit, noHeaders")

[brian_t_anders]

gsaito@paloaltou.edu‌,

You need quotes between the URL request. E.g.:

=ImportJSON("https://paloaltou.beta.instructure.com/api/v1/users/1176?per_page=100&access_token=xxxx","/sis_login_id,/email,/name", "noInherit, noHeaders")

If that doesn't work, try it without the additional arguments, then narrow it down:

=ImportJSON("https://paloaltou.beta.instructure.com/api/v1/users/1176?per_page=100&access_token=xxxx")