Suppose I have this ndjson file: {"id": 99, "labeled_values": [["one", "green"], ["two", "red"], ["three", "blue"]]} {"id": 100, "labeled_values": [["four", "green"], ["five", "red"]]} How do I get the output below (tab-separated)? That is: id on every line, and the pairs of…
Suppose I have this ndjson: {"id": "one", "colors": [{"color": "blue"}, {"color": "red"}]} {"id": "two", "colors": [{"color": "green"}]} How do I get the output below? one blue one red two green Here is a failed attempt: $ cat tmp/test.json | jq…
I need to loop through a dictionary and append records to a json object file option.json the code I have is for K in "${!MYMAP[@]}"; do opt="{ "OptionName":"${K}", "Value":"${MYMAP[$K]}" }," echo $opt >> option.json done But this produce option.json as…
Here is my first input (recorded as bash var $services) It can contain multiple key based values. [ { "key": "movies-wikibase-jobrunner", "subPath": "LocalSettings.php", "cm": "movies-wikibase-jobrunner-localsettings-override-php" }, { "key": "movies-wikibase-jobrunner", "subPath": "jobrunner-entrypoint.sh", "cm": "movies-wikibase-jobrunner-jobrunner-entrypoint-sh" }, { "key": "movies-wikibase-wdqs-frontend", "subPath": "wdqs_front_index.html", "cm":…
Given test file: sample.json: { "host_config": { "host1.reg.fqdn.com": { "config1": "AAA", "config2": "000" }, "host2.reg.fqdn.com": { "config1": "BBB", "config2": "000" }, "host3.reg.fqdn.com": { "config1": "CCC", "config2": "000" } } } I need to update "config2" for each of the hostname…
I'm attempting to use windows cmder to execute jq commands for command-line JSON processor to transform and output existing JSON files I have saved. Given the the sample json [ { "firstName": "Doug", "accountNumber": "123456", "language": "en_US", "brand": "Tide", "country":…
I have this input data : { "list": { "1": { "attributes": { "content": [], "pageable": { "pageNumber": 0, "pageSize": 10 } } }, "2": { "attributes": { "content": [ { "id": "AZER" } ], "pageable": { "pageNumber": 0, "pageSize":…
cat * | jq '.cis[].properties.cloud_vm_display_name' | grep -v null "azuXXXXX" "azuXXXXX" "azuXXXXXX" "azuXXXXXX" Need to extract cloud VM name from multiple json files where the array number is different in every file. a = data1['cis'][0]['properties']['TenantsUses'][0] print(a) b = data1['cis'][]['properties']['cloud_vm_display_name'] File…
Say I have this JSON: { "lunch": { "time": "11 am", "food": { "is_pizza": true } }, "snacks": [ { "time": "2 pm", "food": { "is_pizza": true } }, { "time": "3:30 pm", "food": { "is_pizza": true } } ],…
I am running brew list --versions to get this list: user@mac ~ [1]> brew list --versions fish 3.7.0 ncurses 6.4 pcre2 10.43 syncthing 1.27.4 appcleaner 3.6.8 teamviewer 15.51.6 How can I put the output to a json object like this:…