With that line of code value=($(jq -r ‘.key1’ jsonFile)) you are assigning both values to an array. Note the outer parantheses () around the command. Thus you can access the values individually or echo the content of the entire array. $ echo “${value[@]}” aaaa bbbb $ echo “${value[0]}” aaaa $ echo “${value[1]}” bbbb Since you … Read more
Using the builtin function del: $ jq ‘del(.pages)’ myfile.json { “actions”: { “pages”: { “stuff”: “…” } } } Try it online at jqplay.org To remove all pages everywhere, instead of just the outer level, you would use something like $ jq ‘del(.. | .pages?)’ myfile.json { “actions”: {} } Try it online at jqplay.org
Something useful I found for shell scripts was: jq ‘.foo // empty’ Which returns the match if successful, and the empty string if unsuccessful. So in bash I use: addr=$(./xuez-cli getnetworkinfo | jq -r ‘.localaddresses[0].address // empty’) if [[ ! -z “$addr” ]]; then # do something fi Ref: https://github.com/stedolan/jq/issues/354#issuecomment-43147898 https://unix.stackexchange.com/questions/451479/jq-print-for-null-values
the simplest solution is the add filter: jq ‘[.duration] | add’ the [ brackets ] are needed around the value to sum because add sums the values of an array, not a stream. (for stream summation, you would need a more sophisticated solution, e.g. using reduce, as detailed in other answers.) depending on the exact … Read more
The usual way would be to use the @csv or @tsv operators to convert the result in the CSV or tab-delimited format. These operators need the result to be contained in an array. For your case also to have a single space delimit, we can do a simple join(” “) operation jq -r ‘[.Accounts[].Id]|join(” “)’
EDIT: After clarification in the comments, to retrieve the states of devices whose key begins with “dimmer”, use jq ‘[ .devices | to_entries[] | select(.key | startswith(“dimmer”)) | .value = .value.state ] | from_entries’ filename.json Output: { “dimmer1”: “off”, “dimmer2”: “off” } This works as follows: .devices selects the .devices attribute of the JSON object … Read more
The problem is that jq is still just outputting lines of text; you can’t necessarily preserve each array element as a single unit. That said, as long as a newline is not a valid character in any object, you can still output each object on a separate line. get_json_array | jq -c ‘.[]’ | while … Read more
jq is available in the yum repo so run the following sudo yum install jq will install jq on the instance
This one was a tricky one to craft. map ( with_entries(select(.key != “fields”)) + (.fields | with_entries(.value = .value[0])) ) Let’s break it down and explain the bits of it For every item in the array… map(…) Create a new object containing the values for all except the fields property. with_entries(select(.key != “fields”)) Combine that … Read more
Just in case if someone is looking for a different solution. This is how I installed in Cent OS 7 and it worked. Ensure you have sudo privilege. Installer solution yum install epel-release -y yum install jq -y jq –version output was jq-1.5 Reference