Objective: Trying to get a key's value from a json file using jq function. Input source is a file and need to fetch specific key value to use it in further process of the flow Input Json: [ { "accessTier":…
I have keys that sometimes looks like this docker/nginx:latest and sometimes looks like this docker/nginx@sha256:9560f8528a3cd I can extract the image name between the Repo name and tag using the following .image | match("(?<=\/)(.*)(?=\:)").captures[].string However how do I add multiple conditions…
I am using following command to fetch all release tags from mysql on docker hub : wget -q https://registry.hub.docker.com/v1/repositories/mysql/tags -O - | jq -r .[].name Output is: 5.7.38 5.7.38-debian 5.7.38-oracle 5.7.4 5.7.4-m14 5.7.5 5.7.5-m15 5.7.6 5.7.6-m16 5.7.7 5.7.7-rc 5.7.8 5.7.8-rc…
MongoDB upgraded their command-line interface (formerly mongo, now mongosh). Before, the mongo command output was in proper JSON, the kind jq could ingest. For example: { "abc" : "hello" } The new mongosh command now outputs stuff like: { abc:…
I have JSON example like this { "server1": { "dhcp-libs": "12:4.2.5-83.el7.centos.1", "perl-Time-Local": "1.2300-2.el7", "kbd-legacy": "1.15.5-15.el7", "perl-Scalar-List-Utils": "1.27-248.el7", "ncurses-base": "5.9-14.20130511.el7_4", "firewalld": "0.6.3-13.el7_9", "perl-threads": "1.87-4.el7", "aic94xx-firmware": "30-6.el7", "kpartx": "0.4.9-135.el7_9", "perl-Getopt-Long": "2.40-3.el7", "basesystem": "10.0-7.el7.centos", "rsyslog": "8.24.0-57.el7_9.1", "libtirpc": "0.2.4-0.16.el7", "python3-libs": "3.6.8-18.el7", "btrfs-progs": "4.9.1-1.el7", "ncurses-libs":…
I have a JSON result which I want to go through and send an alert, if one or several of the values in the JSON string is smashing thresholds. This bash command: for sat in `docker exec -i storagenode wget…
I'm scripting in bash to edit a json template to replace some field values with arguments to my script, and trying to use jq to do the editing. My code is not replacing the --arg with the value of the…
Executing the following jq command works fine on Mac OS Catalina (jq version 1.6) : echo $(jq '.paths | to_entries | map(select(.value[].tags | index("Tag123"))) | from_entries' custom.json) However executing it on CentOS (CentOS release 6.9 (Final)) (jq version 1.3) returns…
Given the following json: Full file here: https://pastebin.com/Hzt9bq2a { "name": "Visma Public", "domains": [ "accountsettings.connect.identity.stagaws.visma.com", "admin.stage.vismaonline.com", "api.home.stag.visma.com", "api.workbox.dk", "app.workbox.dk", "app.workbox.co.uk", "authz.workbox.dk", "connect.identity.stagaws.visma.com", "eaccounting.stage.vismaonline.com", "eaccountingprinting.stage.vismaonline.com", "http://myservices-api.stage.vismaonline.com/", "identity.stage.vismaonline.com", "myservices.stage.vismaonline.com" ] } How can I transform the data to the below. Which is,…
Overall aim: Parse a string in GMT as a time using jq and output both a formatted time and the difference of that time to "now". However, jqs (version 1.6, Debian testing) timezone handling seems very confused to me: $…