jq Questions

Convert a single JSON to multiple jsons by taking one of the key values? – Amazon Web Sevices

February 5, 2023
Sai Kumar
2 Answers

I currently have one json file as follows in terms of formatting: { "Comment":"json data", "Changes":[ { "Action":"DELETE", "ResourceRecordSet":{ "Name":"record1", "Type":"CNAME", "SetIdentifier":"record1-ap-northeast", "GeoLocation":{ "CountryCode":"JP" }, "TTL":60, "ResourceRecords":[ { "Value":"record1" } ], "HealthCheckId":"ID" } }, { "Action":"DELETE", "ResourceRecordSet":{ "Name":"record2", "Type":"CNAME", "SetIdentifier":"record2-ap-south",…

VIEW QUESTION

jq: How to create output in a tabular format from a JSON array

February 4, 2023
Logan Palanisamy
2 Answers

I have JSON as given below. [ { "users": [ { "name": "alfred", "points": 10 }, { "name": "alice", "points": 11 }, { "name": "emma", "points": 33 } ], "house": "red" }, { "users": [ { "name": "Logan", "points": 20…

VIEW QUESTION

Json – jq – get dict element based on key regex

February 3, 2023
iAmoric
2 Answers

I'm working with a JSON object having the following structure: { "key-foo-1.0": [ { "key1": "foo", "key2": "bar", "id": "01" }, { "key1": "foo", "key2": "bar", "id": "23" } ], "key-bar-1.0": [ { "key1": "foo", "key2": "bar", "id": "45" },…

VIEW QUESTION

Bash: Ignore key value pairs from a JSON that failed to parse using jq

February 2, 2023
Abhishek Chandran
4 Answers

I'm writing a bash script to read a JSON file and export the key-value pairs as environment variables. Though I could extract the key-value pairs, I'm struggling to skip those entries that failed to parse by jq. JSON (key3 should…

VIEW QUESTION

Json – Can this jq map be simplified?

February 1, 2023
Tom Morris
2 Answers

Given this JSON: { "key": "/books/OL1000072M", "source_records": [ "ia:daywithtroubadou00pern", "bwb:9780822519157", "marc:marc_loc_2016/BooksAll.2016.part25.utf8:103836014:1267" ] } Can the following jq code be simplified? jq -r '.key as $olid | .source_records | map([$olid, .])[] | @tsv' The use of variable assignment feels like cheating…

VIEW QUESTION

Terraform – /usr/local/bin/jq: Argument list too long – Amazon Web Sevices

February 1, 2023
Dave
2 Answers

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…

VIEW QUESTION

Json – Select objects from file A where value of path appear in file B in jq

February 1, 2023
B Jam
2 Answers

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"…

VIEW QUESTION

Json – Use jq to remove key/value pairs based on other file

February 1, 2023
Rogier
2 Answers

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…

VIEW QUESTION

How to dynamically update one json object and put it back into the original json objects?

January 31, 2023
devops-admin
2 Answers

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"…

VIEW QUESTION

Extract an array of key-value pairs using JQ and from pre-filtered JSON

January 31, 2023
Kerbol
2 Answers

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"))'…

VIEW QUESTION