I have the issue I have some files that have as content multiple key value pairs that I'd like to transform into multiple arrays. Let me illustrate what I mean with some produced examples. First the content of the files:…
When I group and add (read merge) objects based on a value I would like to have certain attributes be concatenated together instead of the default "object on the right wins" behavior. demo Put another way I would like the…
Sorry for a noob question. I got two json that I need to merge. And I'm not really sure what operation/function to use in jq, so please enlighten me. Thanks! color.json [{"id":1,"color":"red"},{"id":2,"color":"green"},{"id":3,"color":"blue"}] shape.json [ { "shape": "square", "color": { "id":…
I am jq from the terminal , to parse and filter the rest api using curl below the response { "result": [ { "fxid": "03e401a", "id": "123" }, { "fxid": "03e4099", "id": "567" }, { "fxid": "867", "id": "666" }…
I have a file containing a sequence of json objects. Using the jq tool, how can I get the first json object from that file? I have tried jq limit(1; .) input.jsonl but that limits the length of each individual…
This is a bit long, but I am at a loss how to glue together multiple jq queries to filter out nested objects in a multi-level structure. I am starting with JSON that looks like this. { "image": "test", "duration":…
I have a json like this { "outer1": { "outer2": { "outer3": { "key1": "value1", "key2": "value2" } }, "outer4": { "key1": "value1", "key2": "value2" } } } I want output to be [outer1.outer2.outer3] key1 = value1 key2 = value2…
I have following data.json to be modified , I want to change the state to "disabled" based on the filtered IP address range(eg "10.13*". I tried following command and I need to get whole json content as the out put,…
I have a question. Let's assume I had a json doc like this: { "counts": [ 17, 1014, 22, 9, 11 ], "values": [ "5", "10", "15", "20", "25" ] } and I wanted to get a result like this:…
I have some JSON with structure like { "columns": [ { "id": 123, "title": "column 1" }, { "id": 456, "title": "column 2" } ], "rows": [ { "cells": [ { "columnId": 123, "value": "foo" }, { "columnId": 456, "value":…