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: {…
I would like to find in a JSON file a specific value (without worrying about the key) at any level of my JSON file (I don't know in advance the exact tree) and display the parent keys. I have extracted…
I'm writing a script that receives a delimited list of non-jSON data jq. My goal is to transform that list to a JSON array. The actual data is delimited with commas, but I could easily translate that to delimit by…
I have a JSON with a lot of nested properties. Something like this: { "user": { "name": "Matias", "age": 12, }, "role": { "it": { "developer": true, "designer": false } } } And so on. I am trying to create…
I'd like to get the count of elements in an json array using jq (without the elements with "name": "current" in the snapshots array). { "name": "test1", "snapshots": [ { "description": "You are here!", "name": "current", "digest": "ccc", "running": 1…
I have an existing json file that I need to transform, but am having trouble with it. Here's an example of the structure: jq -r '.document.results.summary.run.[] | [.run_number, .cinfo] ' input.json [ "42", [ { "name": "Joe shmo", "state": "AZ",…
I'd like to use jq to recursively transform arbitrary JSON files: Input { "id": 123456, "name": "Test", "more": [1, 2, 3], "instance": { "id": 987654, "name": "Different" } } Output [ { "name" : "id", "type": "number", "value": 123456 },…
I have a JSON which looks like this { "orders": [ { "order": [ { "items": [ { "name": "Item 1", "id": [], "type": [ { "name": "Color", "value": [ { "value": "blue" } ] }, { "name": "model", "value":…
having input json like so [ { "k1": "o1k1", "k2": "o1k2", "k_opt1": "o1k_xxx" }, { "k1": "o2k1", "k2": "o2k2", "k_opt2": "o2k_yyy" } ] i would like to get array of arrays with object values, so: [ [ "o1k1", "o1k2", "o1k_xxx"…