Running the below: $ echo '["lorem", "ipsum", "dolor"]' | jq '. | contains(["rem"])' returns true because "rem" is a substring of "lorem". I would like a whole word match, which would disqualify "rem" and only allow one of the three…
I am trying to convert the below json to a markdown table(GitHub docs(.md file)), however not able to do so. { "service_1":"abc-endpoint.vpce.amazonaws.com", "service_2":"def-endpoint.vpce.amazonaws.com", "service_3":"xyz-endpoint.vpce.amazonaws.com" } Command I tried: cat json_file | jq -r '{"NAME": "ENDPOINT_ID"} + . | to_entries[] |…
I have spent the last 4 hours combing all over the internet for advice and ideas on how to capture a string of interest so that I can pipe it into a variable inside of a bash script for use…
I have similar file/data: $ echo "[{"my_var1":"valueA", "my_var2": "valueB"}]" {"my_var1":"valueA", "my_var2": "valueB"}] in my code I need to get value of "my_var2", easy: $ echo "[{"my_var1":"valueA", "my_var2": "valueB"}]" | jq -r '.[] .my_var2' # correct result: valueB ... but ...…
I am trying to extract the ranges from the below JSON output, { "zscaler.net": { "continent : EMEA": { "city : Amsterdam II": [ { "range": "165.225.240.0/23", "vpn": "ams2-2-vpn.zscaler.net", "gre": "165.225.240.12", "hostname": "ams2-2.sme.zscaler.net", "latitude": "52", "longitude": "5" }, { "range":…
EDIT: I have redone this question in its entirety as I discovered a flaw in my original: I CAN access ALL the data I need to get my output in a single call to the API. My API call results…
I have a file with an array of JSON: [ { "names": [ "name1" ], "id": "1" }, { "names": [ "name1", "name2" ], "id": "2" } ] and I would like to create a new file with each JSON…
My input data looks like this { "objects": [ { "statistics": [ { "dataType": 0, "value": 0.0, "id": 18 }, { "dataType": 1, "value": 0, "id": 89 }, { "dataType": 0, "value": 35.0, "id": 91 }, { "dataType": 0, "value":…
I'm going through a Kubernetes tutorial and am using jq to filter some of kubectl's exhaustive output. One task that's coming up is to show what images are deployed to what pods, using kubectl get pods. So far I have…
Hi I am having a kubernets audit log file with . The log file has data as json records. I would like to parse the filter out the records. The following is a sample couple of records in the file…