JSONPath extract string "where" JSON file

Question

I'm trying to run JSONPath on the below json file and extract all the IP Addresses (ip_prefix:) where the region equals "region: "ap-southeast-1""

My xpath skills are rusty, my JSONPath skills are novice!

Show what you have tried and we can tell you what you are doing wrong. This page lists an example a lot like what you want: $..book[?(@.price<10)] "filter all books cheaper than 10" — Ruan Mendes
– Ruan Mendes, Commented Jul 9, 2015 at 21:30
Thanks, I got it working $.prefixes[?(@.region=="ap-southeast-2")].ip_prefix — user728584
– user728584, Commented Jul 9, 2015 at 21:53

Ruan Mendes · Accepted Answer · 2015-07-09 22:33:29Z

1

Fixed it with guidance from the blog post samples ...

$.prefixes[?(@.region=="ap-southeast-2")].ip_prefix

Ruan Mendes

92.7k31 gold badges161 silver badges225 bronze badges

answered Jul 9, 2015 at 21:54

user728584

2,1352 gold badges22 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1