Due to the need to use specific SQL permissions, we are thinking about writing some SQL agent jobs that run a series of queries, compile that info and directly output the data in json format to a file.

Is there a method for that json file to be directly ingested in to site 24x7? 

If not, would something as basic as writing a powershell script that reads the json file and spits it back out work?