I’ve tried to work on something for this multiple times, but we are a large district so the amount of data we pull takes forever to do with the API. If you’re ok with your data being a couple hours behind, and if you’re willing to spend a few bucks, you could write what you need to BigQuery and then connect Looker to that.

OR - if you’re a smaller district, you can write to a Google Sheet and connect Looker to that. (We have too much data for our size to use this method.)
I think several districts on here have done something like this, but @calexander did a pretty nice writeup on it (credit where it’s due!)
 

Both of these can be done with Google Apps Script.

I’ve pitched the request numerous times for read-only access directly to the database for our site, where I can just write a SQL query or something directly in Looker or Power BI to get real-time data.

There’s a couple of idea posts around reporting as well that you could vote on.

 

https://community.incidentiq.com/ideas/save%2Dcustom%2Danalytic%2Dviews%2D525

Thank you @jclark We are a large district as well, and would most likely have to go the BigQuery route. I saw the post from @calexander which looks awesome! I just need to know how to set it up. 

Thank You,

@KMuston 137ad25 aldineisd Thank you for submitting your question to our community!

@jclark and @calexander are going to be your best helpers for API. @bclark and @curtis.bohlmeyer are other great resources! 

Thanks @Kathryn Carter