No JSON errors.  If anything, its the way the data is stored in the "notes" field.   And its only now an issue because the newer API versions are now including the 'notes' field in the json.response.   I have a way to work around it.  Just means I have to run the reports for my team now.   And it does mean that Meraki Tools dynamic reports are useless to us now ... View more

Hi @John_on_API ,   Its not limited to GSheets.  We first ran across it when one of my team members ran the Postman collection and then tried to convert the JSON data to csv via an online conversion site.  The resulting csv was all messed up.  Initially we thought it was him since he has had issues with Postman in the past but several others ran it as well and we were getting similar results, even when using different conversion techniques.  After messing with the data for awhile I was able to trace it back to 'base url' v1 of the newer API versions including the "notes" field now (think the last time we ran this report, we were using API v1.3.4) and when data in that field included the \n because there were multiple lines of data for the notes.   So long story short, we found that if we wanted to get the JSON data to convert correctly to CSV, we had to change the 'base url' version to v0 so it would exclude the "notes" field. ... View more

Thanks @Badr-eddine, the filteredNetworks actually works and has the correct data after I fixed our environment.  One of my team members had set it to v0 as a work around to another issue we are fighting with the newer API versions (mentioned in another post).  Anyway, with it set to v0 it failed but works when I set it back to v1.   Really wish we can get this figured out without having to use the "test" to filter it further, otherwise I will be the only one to run this report for the team.  Plus as I mentioned earlier, it also affects Meraki Tools as well. ... View more

@Ryan_Miles  Interesting, unfortunately, not working for me.  I even tried putting wireless in quotes in the query string, still received the same results.  What version of the API are you running?  I'm using v1.36.0.   And as I previously mentioned, I get the same results from Postman and Meraki Tools.   cc @DexterLaBora  ... View more

only 'appliance'.   To be clear, we have a wide combination of Networks, both appliance, camera, switch, wireless or combination.    So any combination that includes 'wireless' is an acceptable response.  But, I'm also getting responses that are only 'appliance' which does not meet the search parameters. ... View more

So, I believe we found a bug in this version, it might have been in v1.35 as well but when running the Organization Networks report and if the Network Notes field has more than one line of text, it will cause the JSON to CVS conversion to jump several rows between the lines of text from the "Notes" field which throws the data in the columns off as well.   If you change the API version to v0, then the JSON output converts properly because v0 doesn't include the "notes" field.   Example v1 output for that field:  "notes": "10.182.0.0/16\nnew office",   I could run a find and replace on the JSON data before the conversion to remedy this but thats not something you can do when running the Meraki Tool for GSheets. ... View more

Hmm, so I just tried it using the Firefox browser and it's working. So it must be something with my Brave/Chrome browser.  I have Shields disabled and even reviewed the browser extensions to see what else could be interfering.  🤷‍ ... View more

@DexterLaBora thanks for the quick response.   Initially, I was trying to run the "Organization Networks" report but it would never populate the data into the sheet even though the JSON data was available.  We have over 200 Networks in one Org and ~40 in the other.  Since that did not work, I tried something simple, like trying to list all my Org's (3 Orgs).  But I got the same results, the JSON data was there but would not populate the sheet. ... View more

I really like the addon but its broken again.  Reports run (can see the JSON results in the addon column) but the data is not getting printed to the sheet.   Is there a fix for this?  My team struggle using Postman/API calls to pull the JSON data then having to convert to CVS/Excel. ... View more

@BrechtSchamp no, I have been running the script from the other discussion. It didn't look like the above script included 'vlan'.  We have multiple SSIDs and just need to filter on the employee vlan.  Can vlan and status be included in the script above? and if so, whats the wording? ... View more

@BrechtSchamp    I really could you user assistance since I am new to this (Postman/python).  I saw in another post of yours where you mentioned the "status" field.  I tried adding it to the python script my Rep send me a link to on github but I get an error 08: unable to write file.   Let me backup and tell you what our needs are.  We need to find out how many concurrent wireless users are online so we can know how to scale a new Cisco ISE deployment and order the correct license count.   I don't care if I can get the info from Postman or running a python script, I just need a way of determining how many users are on wireless.   Oh, and to give you an idea of our size, we have two Orgs and over 250 Networks. ... View more