Connect Airtable to Canvas API

[noahcoleman]

I'm trying to write a script in Airtable to search for submitted assignments in my Canvas class and update my data in Airtable. I'm testing with a manually-generated token, but I can't get the script to connect to the API. I keep getting a 401: Unauthorized error.

I'm not a very experienced coder, but I have been able to connect Airtable to another API in the past. I can post the code I'm using if that would help.

[robotcars]

@noahcoleman

Can you share the API endpoint you're trying to hit? If you provide code, exclude your API token, never share it.

Submissions endpoint (one of them) could be

https://canvas.instructure.com/doc/api/submissions.html#method.submissions_api.for_students

[noahcoleman]

@robotcars I'm trying to get to the endpoint you mentioned. Alternatively, I might go for the specific assignment submission so I don't have to parse through so many submissions.

Edit: I should probably mention that my role is teacher.

Code is below.

// URLS
const authenticate_url = 'https://ringling.instructure.com:443/api/v1/courses/4426/assignments/89449/submissions?include[]=user&grouped=false'

// HERE'S WHERE WE RUN THE CODE
await authenticate();

// FUNCTIONS
// Authenticate
async function authenticate() {
let response = await fetch(authenticate_url, {
        method: 'GET',
        authorization: `Bearer ${access_token}`,
        host: 'ringling.instructure.com'
    });
// let response = await fetch(authenticate_url)
    console.log("authentication response", response); 
}

[chriscas]

I'm not an expert with JS/Fetch, but I think you need to place the authorization inside of the header...  Try:

// URLS
const authenticate_url = 'https://ringling.instructure.com:443/api/v1/courses/4426/assignments/89449/submissions?include[]=user&grouped=false'

// HERE'S WHERE WE RUN THE CODE
await authenticate();

// FUNCTIONS
// Authenticate
async function authenticate() {
let response = await fetch(authenticate_url, {
        method: 'GET',
        headers: {
             'Authorization': 'Bearer ${access_token}',
        }
    });
// let response = await fetch(authenticate_url)
    console.log("authentication response", response); 
}