Monthly Organizational Reports API/Google Sheet

Riser
Getting noticed

Monthly Organizational Reports API/Google Sheet

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.

2 REPLIES 2
Inderdeep
Kind of a big deal
Kind of a big deal

@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.

1.JPG2.JPG3.JPG4.JPG

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

 

Regards
Inderdeep Singh

 

Regards/Inder
Cisco IT Blogs awarded in 2020 & 2021
www.thenetworkdna.com

That is cool @Inderdeep !

Get notified when there are additional replies to this discussion.