Starting with the following, I just want the .title, .url, .author.login, .reviews.author.login, .reviews.state and .mergedBy.login fields? I'm getting close with map({ title: .title, URL: .url, author: .author.login, reviews: .reviews, "merged by": .mergedBy.login}) but how do I also limit the fields…
Imagine we have two json objects: {"messages":["one"], "keyA": "valueA"} and {"messages":["two"], "keyB": "valueB"} I expect there's a way to merge these two objects while concatenating the array values, such that the resulting object would be: {"messages":["one","two"], "keyA": "valueA", "keyB": "valueB"}…
I am seeking the simultaneous iteration of two lists. Input object list: First Input Object List { "k11": "v111", "k12": "v112" } { "k11": "v121", "k12": "v122" } { "k11": "v131", "k12": "v132" } Second Input Object List { "k21":…
I need to run a script where I have an array of ids, and a json that contains elements with these ids and more data. I need to filter/select the values that matches the ones in the array. For some…
How can this be achieved? Those are inputs: ARRAY=["keyA", "keyC", "keyE"] JSON={ "keyA": "valueA", "keyB": "valueB", "keyC": "valueC", "keyD": "valueD", "keyE": "valueE", "keyF": "valueF" } So basing on what I have in ARRAY (keys) how can I output corresponding keys…
So it seems that I fell for contains function definition, since: yq -n '["hyper"]|contains(["pe"])' 'surprisingly' returns true. I don't know what usecase this have, still new to funcitolan world but it's clearly shown in docs as: jq 'contains(["baz", "bar"])' Input…
I have a JSON structure that looks like this, it's essentially a bash shell command stored in JSON. Is there a way in jq to map this data back to multiline string ? [ "newcert \n", " --cn server1.acme.com \n",…
When trying to minify a deeply nested JSON file (~10k deep) using jq I got a parse error: $ jq -c . <input.json >minified.json parse error: Exceeds depth limit for parsing at line 227263, column 355 How can I increase…
I am running an AWS cli command to retrieve all the groups that a user belongs to. The result from a iam list-groups-for-user --user-name "User1" | jq '.Groups[] | . += {name: "User1", groups: [.GroupName]} | {name, groups}' provides the…
I have some huge JSON files I need to profile so I can transform them into some tables. I found jq to be really useful in inspecting them, but there are going to be hundreds of these, and I'm pretty…