Postman Updated with JSON Magic visualization

DexterLabora — Fri, 12 Jul 2024 14:07:25 GMT

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.

(view in My Videos)

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.

Re: Postman Updated with JSON Magic visualization

Philip D'Ath — Sat, 13 Jul 2024 00:48:27 GMT