Not quite getting it. I can produce multiple lines but cannot get multiple entries to combine. Looking to take Source JSON and output to CSV as shown: Source JSON: [{"State": "NewYork","Drivers": [ {"Car": "Jetta","Users": [{"Name": "Steve","Details": {"Location": "Home","Time": "9a-7p"}}]}, {"Car":…
My messages generator output $ ./messages.sh {"a":"v1"} {"b":"v2"} {"c":"v3"} ... Required output $ ./messages.sh | jq xxxxxx [{"a":"v1"},{"b":"v2"}] [{"c":"v3"},{"d":"v4"}] ...
I'm simply trying to replace an objects value in a json file with an array, using jq in a bash script. The json file (truncated) looks like this: { "objects": { "type": "foo", "host": "1.1.1.1", "port": "1234" } } I…
I have a json file input.json thus: { "foo":{ "prefix":"abc", "body":[1,2,3] }, "bar":{ "prefix":"def", "body":[4,5,6] } } I would like to sort it by the outer object names, with "bar" coming before "foo" in alphabetical order like so: { "bar":{…
I want to append some content by using shell script. I have a JSON file test.json as below. { "reference": "Json Test", "title": { "a": "Json Test" }, "components": [ { "reference": "Json Test", "type": "panel", "content": [ { "link":…
I have a bash $string containing the values: abc,def and a file.json looking like this: [ { "loc": "51.12345, 12.12345", "city": "CityName1" }, { "loc": "65.12345, 15.12345", "city": "CityName2" } ] I'm trying to update the city field with the…
I have a bootstrap script. After every time it runs, I want to keep track of its exit status in a JSON file. JSON file can have other fields too. Case 1: The very first time it runs, JSON file…
I am validating a json file, I need to validate in a field that if it is null, assign a default value, I can't find how to perform a validation with if conditional file.json { "timeout": 100 } jq -r…
I have two JSON files: $ jq . a.json b.json { "id": "ZGVhZGJlZWY=", "name": "first file", "version": 1, "description": "just a simple json file" } { "version": 2, "name": "fake name", "dependencies": [ 4, 2 ], "comment": "I'm just sitting…
Working with a nested arrays like this: [ { "value1": "Data1-0", "value2": "Data2-0", "nArray": [ {"nValue1": "nData1-0a","nValue2": "nData2-0a"}, {"nValue1": "nData1-0b","nValue2": "nData2-0a"}, {"nValue1": "nData1-0c","nValue2": "nData2-0a"} ], "value3": "Data3-0" }, { "value1": "Data1-1", "value2": "Data2-1", "nArray": [ {"nValue1": "nData1-1a","nValue2": "nData2-1a"}, {"nValue1": "nData1-1b","nValue2":…