I have the following dataset : { "data": { "system": [ { "login": "vault keystore password", "password": "123456" }, { "login": "vault keystore masked", "password": "MASK-789101112" }, { "login": "vault salt", "password": "toto" }, { "login": "vault iteration", "password": "10"…
There is JSON like below: { "data": [ { "a": 1, "d": 2, "c": 3, "b": 4 }, { "a": 5, "d": 6, "c": 7, "b": 8, "e": 9 } ] } I want to transform it to the table…
Say I'm getting an API response back that looks somewhat like this: { "results": [ { "name": "foobar", "description": "it's the foobar 1000 baby!" }, { "name": "another_thing", "description": "acme 1000 whizbang machine" } ] } I pipe this object…
I want to combine below mentioned 2 jq commands to work together in a single jq command. Command 1: jq -r '.objects[] | "(.name),(.uid),(.type),(."ipv4-address"),(."nat-settings"."ipv4-address"),(."nat-settings"."ipv6-address"),(."nat-settings"."install-on"),(."nat-settings".method)"' Command 2: jq -r '.objects[].groups[].name' I'm able to get output of commands when executed separately but…
I have a txt file with values obtained by calling the following command recursively: gsutil ls -r gs://bucket-test/** | while IFS= read -r key; do gsutil stat $key; done, it looks like this: gs://bucket-test/4e123978-8eed-43ae-f521-8fba54c704ea.zip: Creation time: Wed, 21 Dec 2022…
I have this sort of json: [ { "source": { "file": "test", "baz": "now" } }, { "source": { "dev": "foo" } }, { "source": { "bar": "bar" } } ] and I would like to get a list of…
It's not really append what I'm looking for but because I had future noobs in mind, I took the liberty of including it in the title. I am looking to search for/capture a line-ending " and a ] in the…
I have a problem where I'm receiving JSON that depending on the source, may have some data at root level or under another element. From this JSON I need to extract multiple elements into a nother, normalized JSON, with custom…
Let's say I have a few JSON objects in a Bash variable : json='{"key":"100"}{"key":"200"}{"key":"300"}' To select the object with key matching 100 I can do : printf '%sn' "$json" | jq 'select ( .key == "100" )' As @axiac pointed…
I have the following JSON input: { "a": { "a": "foo", "b": "bar" }, "b": { "a": [], "b": [] }, "c": {}, "d": [ "foo", "bar" ] } I want to recursively remove all the keys that point at…