For some reason I just can't wrap my head around jq. I've been going around in circles for hours trying to accomplish what I think is not too difficult a task. With json consisting of two arrays as input, I…
Need help parsing the below nested Json. The end goal is to get the quota limits from GCP that have non-default values. Below is the sample data for one of the services (compute APIs for a given CPU type) I…
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…