Retrieve list of users created between two dates via the API? (2019-01-24)
Original Post: Doug Costain, Moderator, January 24, 2019 at 2:35 PM
Posted on behalf of a customer
Is it possible to query our cloud site to return a list of user accounts created between two specified?
Kevin Baum, Moderator, January 30, 2019 at 4:08 PM
The API supports searching for users by first name, last name, email, or user name. We do not support searching by the date the user was created.
Mark Brewsala, Moderator, February 18, 2019 at 7:42 PM
I understand from internal communication that the goal here is to perform a bulk operation for newly-created users on some cadence (perhaps daily). There currently exists an indirect way that this might be accomplished.
There is a schedulable report called "Last Sign-In Time Per User" that reports both the UserAdded date (the date the user was created) as well as the last time the user signed in so long as the user signed in sometime between the start and end periods of the report. So requesting and consuming that report (which can be done programmatically) would reveal all the users who have signed in within some specified time range. That report could subsequently be filtered to only those users which were also added during that range.
Users which have never signed in within the report range would be absent from the report: but since the goal is to identify only new users and perform some setup action for them, it might be adequate to wait to perform that action until the user has signed in at least once.
You can learn more about these schedulable reports here: https://support.panopto.com/s/article/System-Usage-Report-Fields
Sample code exercising the report SOAP API in Python can be found here: https://github.com/Panopto/python-soap
In particular consider the example at examples/stats_report_example.py.