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…
I have ideal JSON: { "environments":[ { "name":"test", "release":"2.0" }, { "name":"prod", "release":"1.0" }, ] } This file could be in any state: It can be empty file with just empty object { } It can have empty "environemnts" array…
There's a lot of discussion to convert JSON to CSV with jq, but can't find my situation. 2 points really blocking me : Get key and value of valuePerDay by row Sort valuePerDay keys to unsure values always in the…