Connecting meraki API to excel

[Mitchell_]

Hi 

Im having an issue with the meraki api connecting in excel as it used to in the spreadsheet that its on. (someone else developed it, has now left) 

(the spreadsheet basically took the data from the devices on a network and showed how much data was tranferred between clients in the past 31 days.)

It no longer connects to the meraki api . (the API key is stored in a text file on the desktop which excel reads it from).

can anyone give me any help 

thanks

[GIdenJoe]

Have you verified the key that is in use is still the correct key for your user?

You might wanna fire up Postman and fill in the key your app is using and see if it still takes it.

[Mitchell_]

So I have tried using different, revoking then and regenerating them to see if it was a key issue but I was still getting errors. 

[PhilipDAth]

If it is quite old, you might find it is still using the V0 API, and needs to be updated to use the V1 API.

https://developer.cisco.com/meraki/api-v1/ 

Impressive effort linking the Meraki API to Excel!

[Mitchell_]

Hi Phil thanks for the reply.

so I have tried using V0 and V1 and it gives me 2 different errors. 

V0 gives me a 404 error saying it can’t connect to meraki.api 

V1 gives me the authentication error 

Do you have any suggestions on what would be a better way to produce reports for meraki ?

[PhilipDAth]

I used the below in Excel - and it worked.  Give the below a go.  If it doesn't work - it must be your API key.

let
    Source = Json.Document(Web.Contents("https://api.meraki.com/api/v1/organizations",[Headers=[#"X-Cisco-Meraki-API-Key"="your-api-key"]]))
in
    Source

[Mitchell_]

Did you create this as a macro ? or did u use power query.

can you explain how u did it 

thanks 

[david_n_m_bond]

If you just need to dump Meraki data for your organization to Excel, DataMagic does this and is free for up to 100 devices. https://data.magicsuite.net/ .  You just need an API key.