Parse JSON jq return only keys not values

Question

lets say I have this:

https://api.apis.guru/v2/specs/adyen.com/CheckoutService/64/openapi.json

and I want to grab:

/orders
/orders/cancel
/originKeys
/paymentLinks
/paymentLinks/{linkId}
/paymentMethods
/paymentMethods/balance
/paymentSession
/payments
/payments/details
/payments/result

I want to do that on an elegant way, just grabbing the paths, what I am doing is this ugly workaround, that doesn't work well with some apis:

curl -A "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:86.0) Gecko/20100101 Firefox/86.0" -ks "https://api.apis.guru/v2/specs/adyen.com/CheckoutService/64/openapi.json"  | jq -r '.paths' | grep "/" | grep "{" | egrep -iv "microsoft|amz|application/json|application/jwt|\*|text/xml|text/plain|application/|multipart/form-data|text/html" | cut -d "\"" -f 2

Can you provide a (Small!) representative JSON object and what you want to extract from it instead of expecting people to download a large random file? — Shawn, Mar 16 '21 at 12:24
Really easy for [tag:xidel]: `xidel -s "" -e '$json/map:keys(paths)'`. — Reino, Mar 16 '21 at 22:57

Shawn · Answer 1 · 2021-03-16T12:32:48.590

2

Using jq:

$ jq -r '.paths | keys | .[]' openapi.json
/orders
/orders/cancel
/originKeys
/paymentLinks
/paymentLinks/{linkId}
/paymentMethods
/paymentMethods/balance
/paymentSession
/payments
/payments/details
/payments/result

In your case, you'd want to pipe your curl output to jq instead of using a file, of course.

The import bits compared to your use of jq is piping the .paths array to keys and that to .[] to get one element per line instead of a JSON array, and -r to avoid printing each line as a JSON string complete with quote marks.

edited Mar 16 '21 at 12:32

answered Mar 16 '21 at 12:27

Shawn

47,241
3
26
60

Dude, that worked, really, epic man, I owe you one ;) – aDoN Mar 16 '21 at 14:22

Parse JSON jq return only keys not values

1 Answers1