How can one track Canvas Media use without having the reports available from Canvas Studio?
Checking API endpoints and the Data 2 schema, there do not seem to be dedicated Canvas Media endpoints. Am I missing some?
A method I've considered is using the body field of the wiki_pages table, as this contains the html code of all canvas pages and links them back to courses.
By searching for pages that have markers of Canvas Media pages in the body and returning the numeric canvas course id and sis id I can narrow down to the course.
<code>
select sis_source_id, id from courses
Where wiki_pages.body contains ('data-media-type="video" src="https://uab.instructure.com/media_attachments_iframe/')
and wiki_pages.context_id= courses.id
</code>
From the course i can get the instructor.
Is there a better way that doesn't have me going through wiki pages?
