An Azure Function app that I use to analyze stream stats.
This ingests
csv
's
from Twitch's Stream Summary page and puts cleaned up rows into an Azure Storage Queue.
From there, I have a Logic App that takes those rows and puts them in an excel spreadsheet that is the backing of a PowerBI dashboard. The only reason I need the Logic App is because the Microsoft Graph bindings weren't working last I tried.
Two functions:
/NewTwitchDataFile
- A simple file upload page that accepts only thecsv
's from Twitch's Stream Summary page./AddTwitchDataFile
- The backend to/NewTwitchDataFile
that takes in thecsv
file, parses and cleans up the data and then adds each row of thecsv
data to an Azure Storage Queue.
- Figure out how to handle timezones...
When you download the
csv
's from Twitch, it downloads it relative to your timezone which means if you upload a file from Seattle or Miami, the time will be different. - Revisit Microsoft Graph bindings which weren't working last I tried (Mar 2019).
- Simplify code and cleaner UI... lol.