Hi Everyone
We are going through all our notifications and enrolment rules.
I was just wondering, rather than looking at each one individually, is there a way of exporting their contents to a CSV or other file?
I have had a look through the menus and custom reports and have not found anything. I assume the answer is no but I thought I would ask as it will save us a lot of time.
Best answer by INoahGuy_Lrnlab
Hi
You can save the outputs of the API calls by copying and pasting into a generic notepad app, saving it as a .json file, then once its saved, you can use Excel tools to parse the .json file into a workable spreadsheet. Check out this how to guide from Microsoft: https://learn.microsoft.com/en-us/power-query/connectors/json.
Groups are an interesting question, they are found under the “Audiences” service in the drop down. To get all the groups, you can look at the call “Get All Audiences”, but remember its only going to show you so many results, so you’ll need to sort by page if you have lots.
For Reports, I’d check out the “Analytics” service from the drop down, then the “Report”, then “Get New Reports Available in the Platform”. That should provide the list, but the same pagination might also apply here.
The .json trick I mentioned above will also work for the responses you get from these calls too!
Good luck on the API journey!
Hi @caffeine11!
The way to get an export of all of your enrollment rules is through API :).
You’ll need to append /api-browser to your url, so: www.[company].docebosaas.com/api-browser or www.[companyacademy].com/api-browser.
This will take you to the available APIs in your platform.
To get the enrollment rules, on the left side of the screen, switch “learn” to “manage”, you’ll see the page reload. About 10 options down underneath “API reference” is “LegacyEnrollmentRules”.
The first option there is “Get a List of the Enrollment rules”.
Go ahead and click OAuth there, if you’re signed in already, just click continue, if you’re not, sign in.
Once you’re ready click try and it will return a list. If you have a lot of rules, its only going provide a list so long so you might have to change the page from nothing to “2” to see what else is there.
The response you’ll get will show you the name of the rule, the list of its criteria, the courses and/or groups/branches involved by ID, not the platform name.
Hope that helps!
I have run the report but how do I save this to a file? I cannot find a save option, or save to file option, or do you use the browser save option or copy/paste to another program?
We also want to do a similar audit of groups and reports, particularly which branches in our org structure they are referencing. However, I cannot seem to find an option for them in the api browser?
Hi
You can save the outputs of the API calls by copying and pasting into a generic notepad app, saving it as a .json file, then once its saved, you can use Excel tools to parse the .json file into a workable spreadsheet. Check out this how to guide from Microsoft: https://learn.microsoft.com/en-us/power-query/connectors/json.
Groups are an interesting question, they are found under the “Audiences” service in the drop down. To get all the groups, you can look at the call “Get All Audiences”, but remember its only going to show you so many results, so you’ll need to sort by page if you have lots.
For Reports, I’d check out the “Analytics” service from the drop down, then the “Report”, then “Get New Reports Available in the Platform”. That should provide the list, but the same pagination might also apply here.
The .json trick I mentioned above will also work for the responses you get from these calls too!
Good luck on the API journey!
Thanks for taking the time to reply with such a comprehensive answer. It gave me all the remaining info I needed to get moving on this.
Enter your email address or username and password below to log in to Docebo Community. No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
