If I have an array such as this one: [ [ "AppA", "ServiceA", "SecretKey", "topSecretKeyA" ], [ "AppB", "ServiceB", "SecretKey", "topSecretKeyB" ], [ "AppC", "ServiceC", "SecretKey", "topSecretKeyC" ] ] How can I convert this to an object that looks like…
Suppose I have a JSON file like this: { "a": 1, "b": [1, 2], "c": [{ "x": 1 }, { "x": 2 }] } This is my JSON model. Then I have a text file like this: A is {.a}…
I am attempting to update certain properties of a JSON file based on a few conditions: The name of the attribute must contain the string "Description". The attribute's ismydata property must be true. The attribute's deprecatedVersion must have an empty…
I am new to jq and try to process a nested json file and convert it to csv format. The sample nested json file is composed of three levels as below: { level1-label: { level2-text1 : { level3-label1: value1, level3-label2:…
I've been trying this for a bit now. I want to loop through all the keys that I pulled out and now want to get the values by looping through those keys in bash. What I'm trying to do is…
Consider the following a snippet from my package.json "dependencies": { "@types/lodash.camelcase": "^4.3.6", "@types/lodash.kebabcase": "^4.1.6", "@types/lodash.lowercase": "^4.3.6", "@types/lodash.upperfirst": "^4.3.6", "@types/mime": "^2.0.3", "@types/swagger-jsdoc": "^6.0.1", "async": "^3.2.2", "aws-arn": "^1.0.1", } From this, I want to generate the following string - @types/lodash.camelcase@^4.3.6 @types/lodash.kebabcase@^4.1.6 @types/lodash.lowercase@^4.3.6…
I have a file "results.json" It looks like this { "applicationId" : "application", "scanId" : "scanId", "policyEvaluationResult" : { "alerts" : [ { "trigger" : { "policyId" : "pid1", "policyName" : "Security-High", "threatLevel" : 9, "policyViolationId" : "pvid1", }, "trigger"…
I have multiple json files in subfolders, each containing an array of objects with same keys, different values. example: file1.json: [ { "id": 1, "name": "John" }, { "id": 2, "name": "Mary" } ] file2.json: [ { "id": 1, "name":…
Running the below: $ echo '["lorem", "ipsum", "dolor"]' | jq '. | contains(["rem"])' returns true because "rem" is a substring of "lorem". I would like a whole word match, which would disqualify "rem" and only allow one of the three…
I am trying to convert the below json to a markdown table(GitHub docs(.md file)), however not able to do so. { "service_1":"abc-endpoint.vpce.amazonaws.com", "service_2":"def-endpoint.vpce.amazonaws.com", "service_3":"xyz-endpoint.vpce.amazonaws.com" } Command I tried: cat json_file | jq -r '{"NAME": "ENDPOINT_ID"} + . | to_entries[] |…