Python API Post request 404 error

Hey. I'm trying to loop through a csv file to enroll students into a course but I keep getting a 404 error. Can anyone give me some advice as to why? When I switch the request method to GET from POST I get a 200 status code. I've been staring at this for a while now so maybe I'm over looking something?

Column Headers from the CSV file:

record

course_id

user_id

role

status

___________________________________________________________

import numpy as np

import pandas as pd

import requests

import json

dataset = pd.read_csv("PATH_TO_CSV_FILE")

df = pd.DataFrame.from_records(dataset)

ndarray = df.to_numpy()

secret_token = [MY API KEY]

headers = {'Authorization' : 'Bearer ' + secret_token}

courseID = [MY COURSE ID NUMER]

url = "https://[MY INSTITUTION].instructure.com/api/v1/courses/" + str(courseID) + "/enrollments"

course = ""

for x in ndarray:

course = x[2]

print(course)

payload = {'enrollment[user_id]': course, 'enrollment[course_section_id]' : courseID}

r = requests.post(url,headers = headers, params = payload)

print(r.status_code)

Find more posts tagged with

API

python

Accepted answers

bertscjn1

Thanks everyone for their help. I was able to get it solved, and am posting my updated code for anyone that may have the same issue in the future. Turns out it was the "enrollment[course_section_id] " parameter that was throwing the error. According to the API documentation, this parameter is skipped over if the section ID is in the URL being passed. Since it is in my instance, then I could remove it. By removing it, I was successfully able to make the API call to bulk enroll users with specific roles in the course!

import requests
import json
import csv

csv_filename = '[PATH TO MY CSV FILE]'
with open(csv_filename) as f:
reader = csv.reader(f)
lst = list(reader)

secret_token = [MY API KEY]
headers = {'Authorization' : 'Bearer ' + secret_token}
courseID = [MY COURSE ID NUMER]
url = "https://[MY INSTITUTION].instructure.com/api/v1/courses/" + str(courseID) + "/enrollments"

for x in ndarray:
userID = x[2]
enrollmentType = x[3]
print(userID)
payload = {'enrollment[user_id]': userID, 'enrollment[type]': enrollmentType}
r = requests.post(url,headers = headers, data = payload)
print(r.status_code)

All comments

Chris

Hi @bertscjn,

I'm not familiar with numpy or pandas, so I can't quite decipher your whole code, but here are a couple things I note (some may be from copy/paste though):

With the way the indenting loooks right now, you're only making one single enrollment request, but I assume you're reading in a whole bunch of them, so something there needs to be changed.
A 404 error generally means there is an issue with the URL, so I'd maybe print your URL to make sure it looks valid
In your requests like, you have params = payload, but for a post I think it should be data = payload, though maybe params is meant to work too.

Maybe one of the above will help. If not, post back and I'm sure others will chime in with more suggestions.

-Chris

JamesSekcienski

@bertscjn

In your payload, you are using the variable a for the enrollment user ID, but I don't see the variable a defined.

As @chriscas mentioned, it also looks like your indentation is off at the end of your code since the payload, request, and print aren't indented under the for loop.

If you are still experiencing issues, it would also help to know more about the CSV file you are using (at least what the columns are).

bertscjn1

@JamesSekcienski , Thanks for the response and noticing I didn't declare my "a" variable. I meant to update that to "course" to reflect the course variable but didn't before posting. Sorry about that. However, doing so didn't help; neither indenting the "payload = ..." and "r = ...". I'm still getting the 404 error. My CSV file's column headers are:

record

course_id

user_id

role

status

@chriscas , Thanks for your response, too. I changed "params" to "data" but still got a 404 error. Also, printing the URL does look valid.

bertscjn1

import requests
import json
import csv

csv_filename = '[PATH TO MY CSV FILE]'
with open(csv_filename) as f:
reader = csv.reader(f)
lst = list(reader)

secret_token = [MY API KEY]
headers = {'Authorization' : 'Bearer ' + secret_token}
courseID = [MY COURSE ID NUMER]
url = "https://[MY INSTITUTION].instructure.com/api/v1/courses/" + str(courseID) + "/enrollments"

for x in ndarray:
userID = x[2]
enrollmentType = x[3]
print(userID)
payload = {'enrollment[user_id]': userID, 'enrollment[type]': enrollmentType}
r = requests.post(url,headers = headers, data = payload)
print(r.status_code)

Unanswered Questions

Falling SSL handshake when calling Canvas API
Hello, We use PeopleSoft and developed an integration for retrieving grades from the Canvas API. It was working fine in dev and production but has since broken. The SSL handshake is failing according to this stack trace from the server : Apparently this can happen if the required certificates are missing, can anyone tell…
UI for weekly progression idea
UI for weekly progression idea that rest in the Schedule tab of the **K-12 UI** of Canvas it's incomplete and I really would not take it and push it into instance but I am going to post it here because in the past people like @James && @robotcars || @Steve_25 have had terrific input in the past... maybe w/their eyes and…
add `desc` or `asc` to a few api calls that are already sorted by date\time\index such as `due_at`
A case for this argument: I live in thee K-12 realm which means we have way too many assignments... which means that at times a simple last 10 assignments of a course question(last 10 date wise) will take us 300 assignments to answer Solution for this example in particular: I would love to make this modified version of an…
Integrate a React App (Not Canvas) to be Canvas LMS SSO.
Hey Community: I want to ask first if Canvas LMS as a Identity provider is only supported with SAML? What other protocols are supported? My use case is that I have a React App hosted on cloud provider (AWS) and SpringBoot as a backend (Service provider). I want to integrate Canvas SSO as a Identity provider (IdP). I…
Why are instructions and quiz_settings null in the New Quizzes API?
I make requests to this endpoint: GET /api/quiz/v1/courses/:course_id/quizzes In the list I get back, sometimes instructions and quiz_settings are null. Why? How do I prevent this? Here is an example where quiz #3 does not have instructions nor settings: [ { "id": "2893842", "title": "In Class Exercise #2", "instructions":…