Hey @DanaIrvine,
Thanks for following up here!
While it doesn’t look like we currently have the ability to pull lists/reporting in this way, I was able to find this Community Idea on Knowledge Base Reporting. While it doesn’t request the exact features you’re looking for, it does contain a large number of upvotes and has the attention of the Product team. For this, I strongly recommend upvoting the idea and expanding on how you see this functioning using your use case above!
For now, @danielsinewe’s suggestion would be the recommended method.
Shane, Senior Community Moderator