To get the top-level keys as a stream, you can use the built-in function keys[]. So one solution to your particular problem would be: jq -r ‘keys[] as $k | “\($k), \(.[$k] | .ip)”‘ keys produces the key names in sorted order; if you want them in the original order, use keys_unsorted. Another alternative, which … Read more
If your shell supports process substitution (Bash-style follows, see docs): diff <(jq –sort-keys . A.json) <(jq –sort-keys . B.json) Objects key order will be ignored, but array order will still matter. It is possible to work-around that, if desired, by sorting array values in some other way, or making them set-like (e.g. [“foo”, “bar”] → … Read more
jq has the fromjson builtin for this: jq ‘.c | fromjson | .id’ myFile.json fromjson was added in version 1.4.
You set values of an object using the = operator. |= on the other hand is used to update a value. It’s a subtle but important difference. The context of the filters changes. Since you are setting a property to a constant value, use the = operator. .shipping.local = false Just note that when setting … Read more
First, obtain an array containing all the different object property names in your object array input. Those will be the columns of your CSV: (map(keys) | add | unique) as $cols Then, for each object in the object array input, map the column names you obtained to the corresponding properties in the object. Those will … Read more
You can use jq ‘.[] | .login, .id’ to obtain each login followed by its id.
Since 1.4 this is now possible with the * operator. When given two objects, it will merge them recursively. For example, jq -s ‘.[0] * .[1]’ file1 file2 Important: Note the -s (–slurp) flag, which puts files in the same array. Would get you: { “value1”: 200, “timestamp”: 1382461861, “value”: { “aaa”: { “value1”: “v1”, … Read more
jq supports the normal Boolean operators and/or/not, so it would look like: .[] | select((.processedBarsVolume <= 5) and .processedBars > 0)
You can install any application/packages with brew on mac. If you want to know the exact command just search your package on https://brewinstall.org and you will get the set of commands needed to install that package. First open terminal and install brew ruby -e “$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)” < /dev/null 2> /dev/null Now Install jq brew … Read more
Consider also passing in the shell variable (EMAILID) as a jq variable (here also EMAILID, for the sake of illustration): projectID=$(jq -r –arg EMAILID “$EMAILID” ‘ .resource[] | select(.username==$EMAILID) | .id’ file.json) Postscript For the record, another possibility would be to use jq’s env function for accessing environment variables. For example, consider this sequence of … Read more