I have a json value that can contain a single record or an array, I need to extract the ID field of these records and gather them in an array. The resulting element should be an array with 1 or…
I have over 1,000 JSON files representing game elements. This is a typical example: { "name": "Reeve Hunter", "edition": 3, "revision": "2021 v1", "keywords": [ "Circle", "Wolf Sworn", "Reeve of Orboros", "Solo" ], "point cost": 4, "field allowance": 2, "models":…
I have a JSON data structure the looks like this" { "cells": [ { "source": [ "# Get the files in a directory n", "ls -l n" ] }, { "source": [ "# Get the working directory n", "pwd n"…
Consider the following json: [ { "val": 1, "name": "a" }, { "val": 2, "name": "b" }, { "val": 3, "name": "c" } ] I want to pass an argument of space separated elements to jq and filter only these…
I'm trying to iterate over a JSON and add a field to each object in the JSON. I'm doing this in a Gitlab pipeline stage but I don't think is important. The JSON is this: { "service10": { "path_to_file" :…
I would like to convert json file in csv to a format we want. I would like to extract only specific variables from json and format it to csv. Current json file { "count": 86, "next": null, "previous": null, "results":…
How can I get the first x levels of depth of an object and remove the rest using jq ? I have the following example: { "Service1": { "Production": { "Location 1": { "b2d1": { "clusters": { "Datacenter2": [] },…
I would like to print {score: score_value, id: id_value}, by using jq from the following json script (only a small part is here for introduction), I tried jq '[score: .hits.hits[]._score, id: .hits.hits[]._id]' and also jq '{.hits.hits[]._score, .hits.hits[]._id}', but both have…
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"}…