Excel scripts to pull Canvas data

[bertscjn1]

Hey, community. I have a task where I'm trying to pull Canvas API data into Excel using the script editor. When testing the code out in VS Code, I'm able to get a response back with the proper JSON. However, when I try to do it in Excel's Code Editor, nothing returns. Has anyone successfully achieved such a thing, or have any pointers to share? 

Steps to get here: Excel (I'm using Excel for Mac) > Automate Tab > New Script

let secret = 'MY SECRET KEY';

fetch('https://MY-INSTITUTIONS-URL/api/v1/courses/COURSEID', {
  method: 'GET',
  headers: {
    authorization: ' Bearer ' + secret
  },
})
  .then(response => response.json())
  .then(response => console.log(response))

-Justin