This is a variation on a question that's been asked before. I'm using an external data source in Terraform to ask it for a list of volume snapshots in AWS Dublin, and JQ in a templatefile to extract the snapshot…
I want to filter with jq the objects from json content of this fileA [ { "id": "bird", "content": { "key1": "a" } }, { "id": "dog", "content": { "key1": "b" } }, { "id": "cat", "content": { "key1": "c"…
I have 2 json files containing translations for my app: en-US.json: { "car": "car", "bike": "bike", "tree": "tree", } nl-NL.json: { "car": "auto", "bike": "fiets", "tree": "boom", "house": "huis" } As you can see, I have removed the house from…
How to dynamically update one JSON object and put it back into the original JSON objects variable? I have one variable with the following JSON data in it. test='[ { "Name": "James", "Mobile": 12345678, "Gender": "Male", "Boolean": true, "Pet": "cat"…
I want to extract an array of key-value pairs from the below JSON, that is generated by the following AWS CLI script. The array should contain the load balancer names. aws elbv2 describe-load-balancers | jq '.LoadBalancers[] | select(.LoadBalancerName | startswith("MY_LOAD_BALANCER_NAME"))'…
I have a json like this [{"version": 0.0,"Resources": [ {"TargetService": {"Type": "AWS::ECS::Service","Properties": {"TaskDefinition": "abc","LoadBalancerInfo": {"ContainerName": "def","ContainerPort": 8080}}}} ]}] My attempt is to replace TaskDefinition key value from "abc" to "123" and ContainerName key value from "def" to "456 in one…
I have an input like below which just has stageIds, along with their submit and completion time in unix time seconds [ { "stageId": 1, "submitTime_epoch_secs": 5, "completionTime_epoch_secs": 10 }, { "stageId": 2, "submitTime_epoch_secs": 15, "completionTime_epoch_secs": 17 }, { "stageId":…
I want to fetch some data from below JSON code: I'm able to get the output using below command but now I want to format it in such a way that my output will look like the expected output. Command:…
I'm trying to transform array to object by specific key. It works fine without using stream, but not possible when stream is applied. Data: [ { "id": "1", "userId": "fa51531d" } , { "id": "2", "userId": "a167869a" } ] I…
I want to parse a nested json to csv. The data looks similar to this. {"tables":[{"name":"PrimaryResult","columns":[{"name":"name","type":"string"},{"name":"id","type":"string"},{"name":"custom","type":"dynamic"}]"rows":[["Alpha","1","{"age":"23","number":"xyz"}]]]} I want csv file as: name id age number alpha 1 23 xyz I tried: jq -r ".tables | .[] | .columns | map(.name)|@csv"…