I have a list of movies like this: [ { "title":"X", "genres":[ { "tag":"Horror" }, { "tag":"Thriller" }, { "tag":"Mystery" } ] }, { "title":"Zero Dark Thirty", "genres":[ { "tag":"Thriller" }, { "tag":"Drama" }, { "tag":"History" }, { "tag":"War" }…
I am trying to compare 2 security groups in AWS that are in 2 different accounts, using aws ec2 describe-security-groups. Even if the security groups are exactly the same, it's impossible for me to detect that because the json response…
I have a massive JSON output like this { "result": [ { "name": "Fields", "listFields": [ [ "apple" ], [ "Banana__c" ] ], "fields": [ { "name": "apple", "displayName": "Apple", "color": "red", "price": 20 }, { "name": "Banana__c", "displayName": "Banana",…
Given this json: {"data": [ { "account_id": "123", "account_status": "active", "name": "john doe", "email": "[email protected]", "product_access": [] }, { "account_id": "345", "account_status": "active", "name": "jane doe", "email": "[email protected]", "last_active": "2023-08-23T13:03:27.811473590Z", "product_access": [ { "name": "Product 1", "key": "product1", "url": "acme1.com"…
I have a container with an entrypoint that runs a long-lived service. ENTRYPOINT /entrypoint.sh The service outputs logs to stdout and stderr in an unstructured format: Informational message An error I need to wrap these logs in a JSON-structured format…
I've got the following (100GB+) JSON file which includes the following top level key: { "data": { "<userId1>": { "things": { "<thingId1>": { "subfield1": "blah1", "subfield3": "foobar", }, "<thingId2>": { "subfield2": "blah2" } } }, "<userId2>": { "things": { "<thingId1>":…
GitLab allows one to attach labels to issues. I would like to use jq to dig into the JSON representation of these labels. Here's the labels section of the JSON file for one issue: "labels": [ "AI::Assessed", "Pri::1 - High",…
I've got a file with these jsons: {"count":42,"day":"2023-06-22","id":"123"} {"count":12,"day":"2023-06-22","id":"456"} {"count":23,"day":"2023-06-23","id":"123"} {"count":44,"day":"2023-06-23","id":"789"} {"count":65,"day":"2023-06-21","id":"456"} Actually I don't care about the day and want to group my records by id and sum the count. Expected result: {"id":"123","count":65} {"id":"456","count":77} {"id":"789","count":44} How would I achieve…
Not sure if it is possible. I want multiply the "value" field with the "lvalue" field an put the result in a new field "calc" in the corresponding array entry. Given JSON: { "value": 5, "location": [{ "city": "San Fracisco",…
I have been using jq to successfully extract one JSON blob at a time from some relatively large files and write it out to a file of one JSON object per line for further processing. Here is an example of…