I have the following json file : { "entry1":"", "entry2":"", "entry3":"value3", "entry4":"value4", "entry5":"", "entry6":" ", "entry7":"", "entry8":"false" } I know the key value pair of the entry3 but not the next one (entry4 and value) How can I do ?…
Consider the following json data, sourced from from Docker image nginx:1.25-bookworm: # docker pull nginx:1.25-bookworm # docker image inspect 81be38025439 | jq '.[].Config.Env' [ "PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin", "NGINX_VERSION=1.25.3", "NJS_VERSION=0.8.2", "PKG_RELEASE=1~bookworm" ] # I would like to be able to access '1.25.3' from…
I have a JSON file with the following code: { "fruits": [ { "name": "banana" }, { "name": "apple" } ], "vegetables": [ { "name": "tomato" }, { "name": "onion" } ] } I want to merge the second array…
I have a multilevel json like so: { "id": "id123", "details": { "prod": "prod123", "etype": "type1" }, "accounts": [ { "bankName": "bank123", "accountType": "account123", "openingBalance": "bal123", "fromDate": "2023-01-01", "toDate": "2023-01-01", "missingMonths": [], "transactions": [ { "dateTime": "2020-12-01", "description": "a very…
jq version jq-1.6 on Ubuntu 22.04.2 LTE Looking to convert large .json file to .csv json example: {"_id":{"$oid":"5200a366e36f237975000783"},"derived_form":{"$numberInt":"1"},"intransitive":true,"lemma":"badbad","phonetic":"bɐdbɐt","pos":"VERB","root":{"radicals":"b-d-b-d"},"sources":["Spagnol2011","Falzon2013"],"glosses":[{"gloss":"to fornicate","examples":[]},{"gloss":"to cough a lot","examples":[]}],"norm_freq":{"$numberDouble":"0.0"}} How do I convert to .csv: 5200a366e36f237975000783, badbad, bɐdbɐt, VERB, true, b-d-b-d, "to fornicate, to cough a lot"…
Using jq, I'd like to to flatten a (nested) array of objects to an array of strings. e.g. given the input { "message-id": 1, "result": { "info": { "id": 1, "name": "foobar", "route": [ { "nodeid": 1, "nodename": "name-1" },…
I'm having an hard time trying to grok jq for good. I want to change the result from list to array. Now this question was already addressed on these SO questions that say to just put brackets arount the query:…
I used the following long command to get a JSON value 7.3.9-win-x64.msi that I included below. $ cat json.txt | jq -r '.[] | .[] | .[] | .[].management | .[0].microsoft | .shell.associated.scripting.component.windows.powershell' For JSON code it is: { "PowerShell":…
I have the following json object: { "id":1, "activities":[ {"time":1659800397,"cities":["london","paris"],"type":1}, {"time":1659800411,"cities":["rome"], "type":2} ] } I would like to flatten it to the following tab separated structure, perhaps using jq id time cities type 1 1659800397 london 1 1 1659800397 paris…
I am processing a large json structure which is in foo.json at the completion of this filter jq '.[] | select(.entity_id|test("sensor.current.")) | { (.entity_id) : .state} ' foo.json having reduced the list of components with a select() I get: {…