example 1 example 2 example 3 example 4 example 5 example 6
Input { "friends": [ {"name": "Chris", "age": 23, "city": "New York"}, {"name": "Emily", "age": 19, "city": "Atlanta"}, {"name": "Joe", "age": 32, "city": "New York"}, {"name": "Kevin", "age": 19, "city": "Atlanta"}, {"name": "Michelle", "age": 27, "city": "Los Angeles"}, {"name": "Robert", "age": 45, "city": "Manhattan"}, {"name": "Sarah", "age": 31, "city": "New York"} ] }
Query Text JSON .friends | filter(.city == "New York") | sort(.age) | pick(.name, .age) [ "pipe", ["get", "friends"], ["filter", ["eq", ["get", "city"], "New York"]], ["sort", ["get", "age"]], ["pick", ["get", "name"], ["get", "age"]] ]
Output [ {"name": "Chris", "age": 23}, {"name": "Sarah", "age": 31}, {"name": "Joe", "age": 32} ]