I'm trying to select the SerialNumber of a specific AWS MFADevice for different profiles. This command returns the list of MFADevices for a certain profile: aws iam list-mfa-devices --profile xxx and this is a sample JSON output: { "MFADevices": […
Having the following json structure: { "outerDescription1": { "innerDescription1": { "otherProperties": 1, "items": [ "arrayItem1", "arrayItem2" ] } }, "outerDescription2": { "innerDescription2": { "otherProperties": 2, "items": [ "arrayItem3", "arrayItem4" ] } } } I would like to get the following…
Given the following JSON-object: { "meta": { "data1": { "keep": { "key": "value" } } }, "detail": { "data2": [ { "keep1": "keep1value", "keep2": "keep2value", "nokeep1": "abc" } ], "data3": [ { "keep1": "keep1value", "keep2": "keep2value", "nokeep2": { "abc": "def"…
I need to restructure some JSON files to clean up the data representation. Part of this restructuring includes grouping similar objects in a parent object rather than relying on a particular property of the object. We will have five "sections"…
I am trying to transform this JSON object: { "id_1": {}, "id_2": { "sys": "S", "details": [ { "detail": "S1", "index": 0 }, { "detail": " ", "index": 1 }, { "detail": " ", "index": 2 }, { "detail": "…
I have a very large json document (~100 GB) that I am trying to use jq to parse out specific objects that meet a given criteria. Because it is so large, I won't be able to read it into memory,…
I need to merge file1.json file2.json (could be more) into onefile.json. version is always the same value in all files. however vulnerabilities array and dependency_files array values different but there might be duplicate/which I want to remove if any after…
I am not sure if the operation name is proper here, but the example should show well my intention. This is exactly how unwind aggregation operation in Mongo or unnest in BigQuery behave. Having that json structure: [ { "root-array-a":…
i want to remove the duplicates from each array in this json: { "abc": [ "five" ], "pqr": [ "one", "one", "two", "two", "three", "three", "four", "four" ], "xyz": [ "one", "one", "two", "two", "four" ] } output I am…
I am trying to parse the JSON from aws ecr describe-images, and return a result with a specific image tag, matching a pattern, from the list. In particular I get an array with many of these entries: { "imageDetails": […