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"…
a potentially huge json-lines file with objects of known structure is to be converted to csv with headers. example {"name":"name_0","value_a":"value_a_0","value_b":"val_b_0"} {"name":"name_1","value_a":"value_a_1","value_b":"val_b_1"} {"name":"name_2","value_a":"value_a_2","value_b":"val_b_2"} {"name":"name_3","value_a":"value_a_3","value_b":"val_b_3"} {"name":"name_4","value_a":"value_a_4","value_b":"val_b_4"} expected output "name","value_a","value_b" "name_0","value_a_0","val_b_0" "name_1","value_a_1","val_b_1" "name_2","value_a_2","val_b_2" "name_3","value_a_3","val_b_3" "name_4","value_a_4","val_b_4" currently tried (if (input_line_number == 1 ) then…
I have the following JSON: { "query": "rest ec", "elected_facts_mapping": { "AWS": { "ECS": { "attachments": [ "restart_ecs" ], "text": [ "Great!" ] } } }, "top_facts_mapping": { "AWS": { "ECS": { "attachments": [ "restart_ecs" ], "text": [ "Great!" ]…
I've 2 files: changes.csv and sample.json. My csv file is like following: header "a", "b" "a11","b1" "a22","b2" "a33","b3" and the json file is like: [ {"a":"a1","b":"b1"}, {"a":"a2","b":"b2"}, {"a":"a3","b":"b3"}, {"a":"a4","b":"b4"} ] I need to write a jq command, which make changes…