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:…
I want to add package dependencies to the package.json file by bash script using jq. Add new element to existing JSON array with jq Here is the test script with 5 steps: #!/bin/bash add_element_with_jq() { # step 1: Add a…
I'd like to get a list of all paths available in a JSON document. There are variations of this question like 'all paths matching a given pattern' or 'print paths plus value'. This question is about the paths, just to…
I have a logfile with entries like this: {"@timestamp":"2024-02-28T10:21:51.939Z", "log.level":"info", "msg": "done"} I want to convert this json into something like this: 2024-02-28T10:21:51.939Z - info - done This is the output I get from my shell commands: $ msg='{"@timestamp":"2024-02-28T10:21:51.939Z", "log.level":"info",…
I want to display some amount of seconds that correspond to dime duration rather than regular date in some human-readable form. say sth like: [ 30300, 120300, 296700, 31922700, 63458700 ] and what i would like to get [ "0d,…
I need to retrieve an object at a specific index from a massive JSON array. The array contains 2,000,000 objects and the file size is around 5GB. I've experimented with various approaches using jq in combination with Python, but performance…
I have a json file like this: { "arrays": [ { "name": "foo", "properties": [ { "type": "app", "url": "https://example.com", "checksum": "d6fd580fe890b826250aa5d5a88bcdb28839cff4d447ba51536cda4ceae89c4e" } ] } ] } I want to change the type to something else, delete the url and…