I'm trying to get the launch template VersionNumber based on the deployment_version tag. aws ec2 describe-launch-template-versions --launch-template-id lt-1234 Will return something like { "LaunchTemplateVersions": [ { "LaunchTemplateId": "lt-1234", "LaunchTemplateName": "api", "VersionNumber": 16, "LaunchTemplateData": { "TagSpecifications": [ { "ResourceType": "instance", "Tags":…
I am doing a curl call to a server from a bash script. In the response I want to extract some data using jq. but, I am getting below error from jq jq: error (at <stdin>:1): Cannot index number with…
I have a json file list_values.json with array of json with an "origine" field : [ { "origine": "reason1", "identifiant": "1234_AAA" }, { "origine": "reason3", "identifiant": "5678_BBB" } ] I have mapping.json file with a list of predefined fields :…
The following json is extracted from a json file in CycloneDX format produced by Syft tool over a debian:bulleye-slim docker image. { "bomFormat": "CycloneDX", "components": [{ "name": "bsdutils", "version": "1:2.36.1-8+deb11u1", "purl": "pkg:deb/debian/bsdutils@1:2.36.1-8+deb11u1?arch=amd64&upstream=util-linux%402.36.1-8+deb11u1&distro=debian-11", "properties": [{ "name": "syft:metadata:source", "value": "util-linux" }, {…
I have the following CSV (truncated): "adfebb","a-f-A-M-F-R-Z","95-00123","C560","USAF" "ae0133","a-f-A-M-F-R-Z","97-00102","C560","USAF" I need the following JSON: { "adfebb":["a-f-A-M-F-R-Z","95-00123","C560","USAF"], "ae0133":["a-f-A-M-F-R-Z","97-00102","C560","USAF"] } I have been tinkering with jq and came close but I haven't managed to get it just right. What I currently have is:…
I have some json data, where i need to filter the output based on given date field from below json data i need to fetch only the block which satisfy my condition. I tried below but fetching all the fields…
Suppose we have the following JSON - {a:1,b:"x"}. I want to extract the properties a and b and assign them to the respective bash variables. Here is how I do it today: /c/Temp$ export $(jq -n '{a:1,b:"x"}' | sed -n…
I have a JSON structure like this: { "misc": { "color": "blue", "id": "yyyy-12345", "birthdate": "2020-12-25", "tools": [ { "type": "power", "name": "hammer" }, { "type": "manual", "name": "grinder" } ] }, "people": [ { "name": "bob", "profession": "analyst", "clients":…
For some reason I just can't wrap my head around jq. I've been going around in circles for hours trying to accomplish what I think is not too difficult a task. With json consisting of two arrays as input, I…
Need help parsing the below nested Json. The end goal is to get the quota limits from GCP that have non-default values. Below is the sample data for one of the services (compute APIs for a given CPU type) I…