Moodle in English: How to retrieve the User Enrolment ID

How to retrieve the User Enrolment ID

by Carlos Chiarella - Wednesday, February 20, 2019, 10:54 PM

Hi all,

I hope that somebody can give us some ideas. My institution has a Moodle 3.5.3 version. We are trying to use the following method to update the dates of a user enrollment:

core_enrol_edit_user_enrolment

This method requires the User enrolment ID as a parameter although there is no method that we can use to retrieve that information.

We want to update the "Enrolment Ends" date field for a student. Are we doing doing something wrong? Can somebody give us some ideas?

Thanks for your help,

carlos

Re: How to retrieve the User Enrolment ID

by Mayank Tyagi - Wednesday, March 13, 2019, 2:09 AM

Hey Carlos,

Yes, you are on the right track. You can easily update the "Enrolment Ends" date field for your user. The webservice function core_enrol_edit_user_enrolment requires three required parameter - courseid, user enrolments id, enrol status and optional parameters like timestart and timeend (timestamp). You can easily find user enrolment id in Moodle's user_enrolment table. This requires a good knowledge of Mysql queries and Moodle's table. You can apply join of user_enrolments and enrol table.

After getting all required fields you can call webservice like

 http://localhost/moodle3.6.1/webservice/rest/server.php?wstoken=fd324bf337764cbe45fbdb7760d09604&wsfunction=core_enrol_edit_user_enrolment&moodlewsrestformat=json&courseid=4&ueid=1&status=0&timestart=1552410399&timeend=1555089582

If you want I will share the required query with you with the help of which you can get user enrolment id.

If you don't want to do this with webservice API function, you can also use moodle's core function update_user_enrol.

Regards,

Mayank Tyagi

Average of ratings: -

Re: How to retrieve the User Enrolment ID

by Carlos Chiarella - Monday, March 25, 2019, 11:15 PM

Thanks Mayank for the information. Let me explain what we want to achieve and please tell me if you have better ideas.

All of our enrolments are handle by Drupal. So Drupal will follow these steps:

1. call for a specific course the following web service method: core_enrol_get_enrooled_users

This method should return the user enrolment id. With this field, I think we will have enough information to call

2. core_enrol_edit_user_enrolment

Does that make sense? Thanks for your ideas.

Carlos

Average of ratings: -

Re: How to retrieve the User Enrolment ID

by Mayank Tyagi - Tuesday, March 26, 2019, 2:16 AM

Hey Carlos,

I don't think so this method will return enrolment id for the user. It will return enrolled users details like firstname, lastname, profile description and many other details related to users. The details return by this method are

[{"id":3,"username":"sooraj","firstname":"Sooraj","lastname":"Singh","fullname":"Sooraj Singh","email":"singhsooraj30zz@gmail.com","department":"","firstaccess":0,"lastaccess":0,"description":"","descriptionformat":1,"country":"IN","profileimageurlsmall":"http:\/\/localhost\/moodle3.6.1\/theme\/image.php\/academic\/core\/1551116448\/u\/f2","profileimageurl":"http:\/\/localhost\/moodle3.6.1\/theme\/image.php\/academic\/core\/1551116448\/u\/f1","groups":[],"roles":[{"roleid":5,"name":"","shortname":"student","sortorder":0}],"enrolledcourses":[{"id":4,"fullname":"dd","shortname":"45"}]}]

All these details are not required for calling core_enrol_edit_user_enrolment.

Thanks and Regards,

Mayank

Average of ratings: -

Re: How to retrieve the User Enrolment ID

by Carlos Chiarella - Thursday, May 9, 2019, 11:16 PM

Thanks Mayank. Sorry for my late response.

Average of ratings: -

Re: How to retrieve the User Enrolment ID

by Jo Ha - Monday, July 1, 2019, 1:55 PM

Hello,

I'm in a similiar situation as carlos - I want to change a user enrollment (role in course) via webservice.

Happily I found the core_enrol_edit_user_enrolment webservice function which allows that (well, at least i thought that from its name). But apparently that webservice requires some parameters, which you are not able to get via webservice... (But wouldn't that, if true, make the core_enrol_edit_user_enrolment webservice completly superfluous?)
And secondly, the core_enrol_edit_user_enrolment only allows changing enrolment status and time, correct?!

This leads me to following questions:

Is it possible to use the core_enrol_edit_user_enrolment webservice for changing the user enrollment in a course, or to be more precise, the role(s) a user is enrolled in a course.
(If 1) What webservice can be used to retrieve the information needed as parameters for core_enrol_edit_user_enrolment ?

Maybe I'm on the wrong track with the above, so my general question is:

What webservice to use for changeing a users role(s) in a course. I know courseid, userid and new roleid.

Thanks in advance.

Average of ratings: -

Re: How to retrieve the User Enrolment ID

by Mayank Tyagi - Wednesday, July 3, 2019, 3:30 AM

Hello,

No, the core_enrol_edit_user_enrolment is not for change user role in the enrolled course.
For assigning the role to a user you can use core_role_assign_roles.
What do you mean by changing the user role? Is it mean to unassign the current role of the user in that course and assign the new role?
Well as far in my knowledge there is no direct web service for this(unassign present role and assign new). You can do it in two steps:-
1) use core_role_unassign_roles to unassign current role.
2) use core_role_assign_roles to assign new role.
If you don't want to use these web service you can make your own web service for this functionality.

Regards
Mayank

Average of ratings: -

Web services

How to retrieve the User Enrolment ID