I would like to produce a list of all unique key path from a given JSON, each one in a line. For example, from this input JSON: { "results":[ { "id":306, "name":"First Company", "branches":[ { "id":4191, "city":"San Francisco", "customers":[ {…
I would like to produce a list of all values from any given JSON. The special requirement is that for values in nested attributes, all the values of parent's attributes must be repeated in the line. No keys must be…
I'm using Instana to deliver view stats on my site, each daily file looks like this: { "items" : [ { "name" : "page1.htm", "earliestTimestamp" : 1675222177839, "cursor" : { "@class" : ".IngestionOffsetCursor", "ingestionTime" : 1675292168217, "offset" : 1 },…
Given this json: { "hits": [ { "country": "PT", "level": "H2", "id": "id1" }, { "country": "PT", "level": "H1", "id": "id2" }, { "country": "CZ", "level": "H2", "id": "id3" }, { "country": "IT", "level": "H2", "id": "id4" }, { "country":…
I have a non-standard format of JSON which is using some nested data with backslash escape characters. { "getFeedFromMyTeam": [ { "OpenedAt": 1693321311, "feedData": "{"keyOne":"my_data_one","keyTwo":"my_data_two"}", "feedId": "123456789", "recipients": [ { "receiverId": "johns", "receiverName": "John Smith" } ], "senderId": "janed", "senderName":…
Consider the following file.json where "x" is a known string. Two questions: I want to obtain a list of all the unique values in the child arrays. What I have is jq -r '.x[][] file.json | sort | uniq. Is…
I'm trying to integrate joining one array with multiple others into my jq command. This is a small example of my json document: { "items": [ { "metadata": { "name": "pod1" }, "spec": { "containers": [ { "name": "container1", "volumeMounts":…
I'd like to invert the keys and values of some data where the values are arrays, such that every unique element of the value arrays becomes a key in the output, whose value is an array containing every input key…
I have system that output multiple types of JSON file with data Is there any chance to implement above three conditions using JQ package? I am exploring map, arg and argjson command. But I am having tough time First JSON…
I have a json file in the format { "hello": [ { "name": "var1", "value": "1234" }, { "name": "var2", "value": "2356" }, { "name": "var3", "value": "2356" } ], "hi": [ { "name": "var1", "value": "3412" }, { "name":…