Is there any way to determine how/when a particular user was enrolled in a particular course? I'm trying to determine whether a user was batch enrolled or SIS enrolled, and am not sure if this kind of metadata is available anywhere either via GUI or query.
Unsure sure if I'm missing something obvious or not...
If you use a specific DSK for your SIS enrolments then the membership DSK will tell you which integration it came form. You can get this easily with the REST API and as it is a GET you do not need to do any programming, simply put the URL in your browser. Something like:
.../learn/api/public/v1/courses/courseId:XML101/users/userName:dtest
This will also return the date/time the membership was created.
If you are logged in as an admin, to map the DSK IDs to something meaningful, you can use:
.../learn/api/public/v1/dataSources
So Peter Love , I am quite the novice with REST APIs, but you seem to be implying there are urls I can paste in my browser (while logged in to BB, I presume) that can then result in information. Our stage is on Q2 2018 CU4, and prod will be there 1/24/2019. Can I find a list of such REST API urls? We do use SIS for specific DSKs, if that makes a difference.
Thank you so much!
Yes, once you are logged into Learn, you can do any of the REST API GETs by putting the endpoint URL into the browser.
The list of endpoints is at: Explore APIs
BTW, to make interpreting the returned JSON easier, you might want to install one of the many JSON viewer extensions to your browser.
So, Peter, I found on your link the following API for getting course membership: /learn/api/public/v1/courses/{courseId}/users.
I appended our blackboard domain https://blah.gov/ to the front, and put a course ID (as found on the system admin courses tab) within the brackets. I logged in to my Q2 2018 stage environment as full system admin and got the error below. I hope this is within the scope of this discussion.
{"status":404,"message":"API is not found for the specified URL."}
I think you need to configure a rest instance even if you are using REST via the GUI.
No, this shouldn't be necessary. Works fine for me without configuring a REST API Integration.
Oh, dear, Peter, then that means it is user error. Sigh.
You do not leave the braces there.
I get the same error, which implies /learn/api/ may not exist. I will submit a ticket at some point and see what they say. Thank you for your assistance.
Can you post exactly what you are trying?
I would like to get a listing of users enrolled in a course, and when they were enrolled. There are a lot of occasions when I could have used it. I am a complete novice at API, and when I saw you could past it in as a url, it thought -possibly- that it might not be beyond my skill set. I see your url is not customized for your domain. I will try that.
Peter, your url (and I changed it to learndev) brought back this information. What does that tell you?
{"learn":{"major":3400,"minor":0,"patch":4,"build":"a1c490e"}}
It tells me that the REST API is working and your are on Learn 3400.0.4
Good morning:
There is a course id that you can see on the Sys Admin page.
There is also a course id in the address of every course. Look carefully in the address any page in a course. part of the address will be: course_id=_252642_1 . I think that is the id you need for these queries.
Or you can use any of:
courseId:CAFE101
externalId:CAFE101
uuid:57ee938625ec46afb2a3ce4d30e7b31c
Really interesting. How do you determine the userID from the usename?
If you need the user's id, just call the users endpoint with the userName:
/learn/api/public/v1/users/userName:dtest
And the returned JSON will include the user's id.
Hi Chris,
SIS enrolment is all logged - System Logs -> SIS Logs. Like all logs they tend to roll over quite quickly so you can only get the most recent. Restrict the search to your SIS integration to check for individual enrolments.
We recently had a similar situation (trying to work out if we had a problem with SIS integration or user intervention) where we had to go back 8 months and sent the request through to Behind the Blackboard to get the data.
Chris, if you are managed hosting and have ASR or OpenDB (or are self-hosted) then the course_users table has the enrollment date and the dsk primary key, so should tell you everything you need. Join users, course_main and data_source to make things more readable. Something like:
select u.username, cm.course_id, cu.enrollment_date, ds.batch_uid
from course_users cu
join course_main cm on cu.crsmain_pk1 = cm.pk1
join users u on cu.users_pk1 = u.pk1
join data_source ds on cu.data_src_pk1 = ds.pk1
where u.user_id = '{studentuserid}'
and cm.course_id = '{courseid}'
;
p.s. I haven't tested the above as I'm not connected at the moment. Also, should work for ASR but a better definition of tables may be required for OpenDB.
OpenDB or ASR query is what I do - simple and readily scriptable. A limitation is that you don't get up-to-the-moment data. With those three tables the query should be identical (other than different schema) for OpenDB and ASR. A practical solution to "I would like to get a listing of users enrolled in a course, and when they were enrolled."
Help
Privacy
Behind the Blackboard
Blackboard.com
Hi Chris,
What's your user integration method? You could check your Banner records if you don't want to get into the query. But the easiest way to do so would be a query. Do you have Open DB? You could also request a query to the Blackboard team and hey will be able to help you.