Json – INNER JOIN in jq
Using the input given, I need to join the true "user" value from the tweets array with the id in the users array and display the users array object as part of the tweets array Input: { "tweets": [ {…
Can you separate distinct JSON attributes into two files using jq?
I am following this tutorial from Vault about creating your own certificate authority. I'd like to separate the response (change the output to API call using cURL to see the response) into two distinct files, one file possessing the certificate…
Json – How can I get a single result object in jq?
I have a JSON file like this: { "cases": [ {"id": "1", "count": 2, "ignore": "f"}, {"id": "2", "count": 7, "ignore": "o"}, {"id": "3", "count": 11, "ignore": "o"} ] } Doing jq '.cases[] | { "(.id)" : .count }' test.json…
jq command prints the json twice instead of only once
I need to set some new value using jq command in a JSON file. Here is an example of file.json { "Balise1": true, "Balise2": true, "OtherThingEnabled": false, "proxySettings": { "port": 0 }, "mailSettings": {}, "maxRunningActivitiesPerJob": 5, "maxRunningActivities": 5, } In…
Find all matching values in a JSON object whose corresponding keys are regex and match a provided string
I have a json string of the following type { "[A-Z]+": { "k": "test1", "c": "stg1" }, "[a-z]+": { "k": "test2", "c": "stg2" } } The objective is that given a string, if this string matches the regex pattern of…
Delete duplications in JSON file
I am trying to reedit json file to print only subgroups that has any attributes marked as "change": false. Json below: {"group":{ "subgroup1":{ "attributes":[ { "change":false, "name":"Name"}, { "change":false, "name":"SecondName"}, ], "id":1, "name":"MasterTest"}, "subgroup2":{ "attributes":[ { "change":true, "name":"Name" }, {…
convert a 3D JSON object into a "fake" 3D associative array in Bash
I have object in JSON that has the structure as shown below and I want to convert it into a "fake 3D" associative BASH array with the following structure: SHIPS[$mmsi:mmsi]=367513050 SHIPS[$mmsi:lat]=42.380329 ...etc In other words, I want the mmsi value…
dynamic use of jq json for http request
I have been trying to find a way to make sure I can pass the key and values of this json in this link dynamically into influxDB. I have the batch file that is below : The json file is…
Json – jq get values from complex object
I have an object that looks like this { "my_list": [ { "name": "an_image", "image": "an_image.com" }, { "name": "another_image", "image": "another_image.com" }, ...<more objects with image property> ], "foo": { "image": "foobar.io" }, "bar": { "image": "bar_image.io" }, ...<more…
having trouble converting csv to json using bash jq
I have one stream output stored in csv file, I need help converting csv to json: my csv looks like: cat output.csv "k","a1",1,"b1","c1","d1",1 "l","a2",2,"b2","c2","d2",2 "m","a3",3,"b3","c3","d3",3 "n","a4",4,"b4","c4","d4",4 "o","a5",5,"b5","c5","d5",5 Required output: note: I need key configuration to be added to json. {…