How to use jq when the variable has special characters

json key special-characters jq
Jonny Gerold picture Jonny Gerold · May 4, 2016 · Viewed 8.3k times · Source

I'm trying to get the following to work & it's not, help me please:

curl -s 'https://cryptofresh.com/api/asset/markets?asset=MKR' | jq .OPEN.BTC

The variable in question includes a period, I tried just about everything to escape the period && also tried surrounding it in quotes; no go ; this is the variable I'm looking to pull from (I ran jq without any filters, and truncated the output here to show what I need. Thanks in advance future problem solver!

curl -s 'https://cryptofresh.com/api/asset/markets?asset=MKR' | jq
....
 "OPEN.BTC": {
"volume24": 0.932166,
"price": 0.09995,
"updated": "2016-05-04T03:03:29.000Z"
},
....

Answer

Jeff Mercado picture Jeff Mercado · May 4, 2016

When a key contains characters that are invalid for identifiers, you'll have to quote the name.

."OPEN.BTC"

Or for older versions of jq, use an index.

.["OPEN.BTC"]

Related questions

python JSON only get keys in first level

I have a very long and complicated json object but I only want to get the items/keys in the first level! Example: { "1": "a", "3": "b", "8": { "12": "c", "25": "d" } } I want to get 1,3,8 as result! I found this code: for key, value …

Read More
Which characters are valid/invalid in a JSON key name?

Are there any forbidden characters in key names, for JavaScript objects or JSON strings? Or characters that need to be escaped? To be more specific, I'd like to use "$", "-" and space in key names.

Read More
How to get key names from JSON using jq

curl http://testhost.test.com:8080/application/app/version | jq '.version' | jq '.[]' The above command outputs only the values as below: "[email protected]" "2323" "test" "02-03-2014-13:41" "application" How can I get the key names instead like …

Read More