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…
I am trying to change one specific word in yaml file using sed command kind: Pod metadata: name: abc12 spec: containers: - image: ubuntu:latest name: Ubuntu imagePullPolicy: IfNotPresent - image: ngnix: latest name: Nginx imagePullPolicy: IfNotPresent ... Tried using the…
I have an json file containing 1 array of thousand documents. I need to convert file to csv format with specific values only. Each document can have another combination of fields or sub-documents or, (and this is what makes me…