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…
Using the input given, I need to join the true "user" value from the tweets array with the id in the users array and display the users array object as part of the tweets array Input: { "tweets": [ {…
I am following this tutorial from Vault about creating your own certificate authority. I'd like to separate the response (change the output to API call using cURL to see the response) into two distinct files, one file possessing the certificate…