I have a python script that watches a socket and when data is received it writes JSON to stdout. This sample script below illustrates the behaviour, outputting new JSON every 3 seconds. import json, time def new_json(n): frame = {…
Given the following JSON structure { "data": [ { "id": "000000000014444A", "teams": [ "000000000011AE74" ] }, { "id": "000000000014434B", "teams": [ "000000000011AE74", "00000000001583CE", "000000000010B4D7" ] } ] } How can I use jq to structure the data as [ {…
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…