I have a large jsonl file like so: # source.jsonl {"id": "y88979", "content": "content goes here"} {"id": "h93794", "content": "content goes here"} {"id": "k9489", "content": "content goes here"} {"id": "p48947", "content": "content goes here"} {"id": "i8408", "content": "content goes here"}…
My json file is as follows. This is a sample file. { "DocumentIncarnation": 1, "Events": [ ] } { "DocumentIncarnation": 2, "Events": [ { "EventId": "C7061BAC-AFDC-4513-B24B-AA5F13A16123", "EventStatus": "Scheduled", "EventType": "Freeze", "ResourceType": "VirtualMachine", "Resources": [ "WestNO_0", "WestNO_1" ], "NotBefore": "Mon, 11…
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":…