Monthly Organizational Reports API/Google Sheet

[Riser]

Hi, devs,

Looking for an API to assist in pulling my monthly organizational reports. I need to link the reports to PowerBi for clear visualization. Any ideas will be appreciated.

[Inderdeep]

@Riser : I never tested this but i think you can do that with RESTAPI from the Meraki and get the data in JSON format

https://developer.cisco.com/meraki/mv-sense/#!rest-api/enable-api

And on other hand in PowerBi

according to the content in the link that the API Reponses in JSON, you can get the data by using "Get Data"-->"Other"-->"Web". And then extend JSON to a table in query editor.

eg. http://jsonplaceholder.typicode.com/posts/1/comments

You can replace it with a link like "http://[school].myschoolapp.com/api/academics/department/?t=[token returned from previous step]" in your link.

Regarding refreshing, you can publish it to Power BI Service and schedule refresh. Let me know if it resolves 

Regards
Inderdeep Singh

[PhilipDAth]

That is cool @Inderdeep !