Given this JSON data in the file data.json: [ { "id": 1, "entityType": "cat" }, { "id": 2, "entityType": "dog" }, { "id": 3, "entityType": "bird" }, { "id": 4, "entityType": "cat" } ] How would return an array sorted…
I want to transform this JSON { "property": "value", "array1": [ { "name": "A", "propertyA1": "1", "propertyA2": "2" }, { "name": "B", "propertyB1": "1", "array2": [ { "name": "C", "propertyC1": "1", "propertyC2": "2" } ] } ] } into that…
I have a CSV containing two "columns" 'User id' and 'email' example: User id,email 1234-1234-1234,[email protected] 321-1235-44432,[email protected] 322136231345,[email protected] And a JSON looking like this: [{ "externalId": "100000", "watchers": ["[email protected]", "[email protected]", "[email protected]"] }, { "externalId": "100002", "watchers": ["[email protected]", "[email protected]"] } ] What…
I have a template JSON file like this: [ { "fields": [ { "name": "body_t", "value": "TEST" } ], "id": "abc123" } ] I need to replace the "value" of the "body_t" (which is set to TEST in the template).…
Let's say I have this json: [ { "first": 12355, "second": "abc" }, { "first": 89010, "second": "def" }, { "first": 23423, "second": "hij" }, { "first": 23456, "second": "klm" }, { "first": 11111, "second": "nop" } ] And I…
I used to be a jq masochist, but I discovered mlr, which seems to offer the opportunity for more (yet different) pain. I found a nice web site that allows me to issue curl commands without API keys, etc., to…
Here are the 2 items in one array: { "SysID": "12345", "Name": "abc" } { "SysID": "12345", "Name": "def" } { "SysID": "23456", "Name": "hij" } { "SysID": "23456", "Name": "klm" } { "SysID": "23456", "Name": "nop" } I would…
I have a JSON similar to the following: File: my_data.json { "hosts": { "1.2.3.4": { "name": "name4", "env": "test", "options": "" }, "1.2.3.5": { "name": "name5", "env": "prod", "options": "opt1,opt2" }, "1.2.3.6": { "name": "name6", "env": "qa", "options": "" },…
I tried this for 2 days but can't figure it out in any way. This is my JSON: { "items": [ { "name":"itemA", "bins":[ { "bin_id":"b1", "count":"11" }, { "bin_id":"b2", "count":"22" } ] }, { "name":"itemB", "bins":[ { "bin_id":"b5", "count":"55"…
I'm currently practicing converting plain text to csv, and them csv to json. I need to do the conversion only with jq and basic Linux commands. I didn't have any major problems converting plain text to csv, but further conversion…