I am a Data Analyst also in a similar situation and need a way for constant updates.
Currently using Python for this.
I remember that there was a mention (in another post here) about a Streaming API component which could fulfill this req.
Links to relevant posts I found -
But, I do believe that this feature has not been added to the API layer yet. Please do perform you independent investigation to confirm this and also push for the feature itself.
Umesh Sai Gurram