Monthly Organizational Reports API/Google Sheet

Riser
Comes here often

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.

3 REPLIES 3
Inderdeep
A model citizen

Re: Monthly Organizational Reports API/Google Sheet

@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
Inderdeep Singh
www.thenetworkdna.com
PhilipDAth
Kind of a big deal

Re: Monthly Organizational Reports API/Google Sheet

That is cool @Inderdeep !

Inderdeep
A model citizen

Re: Monthly Organizational Reports API/Google Sheet

Thank you sir !

 

Regards
Inderdeep Singh

www.thenetworkdna.com 

Regards
Inderdeep Singh
www.thenetworkdna.com
Welcome to the Meraki Community!
To start contributing, simply sign in with your Cisco account. If you don't yet have a Cisco account, you can sign up.