JSON Magic
a Postman Visualization for the Meraki API Collection
We just made some nice updates to the Postman collection, enabling a simpler way to view, transform and export the data.
What does it do?
Allows Postman users to select "Visualize" and have their complex JSON turn into a beautiful spreadsheet.
Who's it for?
Anybody who has a Meraki API key, a free copy of Postman, and would like to easily generate their own reports using hundreds of API operations.
How do I get it?
Just use the Meraki Postman Collection.
Quick Start Guide
- Collect Data:
- Send a Postman API request using the Meraki Postman Collection.
- Visualize Data:
- Select the Visualize button in the response toolbar to display the data in table format
- Transform Data:
- Click the Transform JSON button to write a custom expression to manipulate the data.
- Copy CSV:
- You can easily copy the CSV table into your clipboard and then paste it into a spreadsheet for further analysis.
Example JSONata Expressions
Here's a quick look at what you can do with JSONata expressions.
Source Data
[
{
"occurredAt": "2024-07-12T08:14:47Z",
"alertTypeId": "motion_alert",
"device": {
"name": "Home - Front Door",
"serial": "Q2FV-PF2X-XXXX",
"model": "MV12WE"
},
"alertData": {
"imageUrl": "https://example.s3.eu-central-1.amazonaws.com/sp/vf/..."
}
}
]
Basic Transformations
Extract Device Names:
$.device.name
Output:
["Home - Front Door"]
Extract Unique Device Models:
$.device.model ~> $distinct
Output:
["MV12WE"]
Filter Alerts by a Specific Type:
$[alertTypeId="motion_alert"]
Output:
[
{
"occurredAt": "2024-07-12T08:14:47Z",
"alertTypeId": "motion_alert",
...
}
]Count the Number of Alerts:
$count($)
Output:
1
- Summarize Alerts by Destination Type:
{
"email": $count($.destinations.email),
"push": $count($.destinations.push),
"sms": $count($.destinations.sms),
"webhook": $count($.destinations.webhook)
}Output:{
"email": 1,
"push": 1,
"sms": 1,
"webhook": 1
}
Get the Meraki Postman Collection to easily interact with the API and quickly generate reports.
