Json – JQ extract parent folder
I have an s3 route and I have to split it in bucket, prefix and key using JQ. "s3://bucket/folder1/folder2/folder3/key.txt" -> { bucket: bucket, prefix: folder1/folder2/folder3, key: key.txt }
Replace single backslash with double backslash so that json becomes parseable
I am using cURL inside bash to fetch json data from remote API. Also using jq to parse and loop through the json array to perform additional operations. The response looks like this: [ { "services": [ "HOM" ], "specialServiceId":…
Json – Replace a field with the index of values in an array in JQ
Given the following JSON file: { "quadrants": [ "Languages + Frameworks", "Tools", "Platforms", "Techniques" ], "entries": [ { "quadrant": "Languages + Frameworks" }, { "quadrant": "Platforms" }, { "quadrant": "Languages + Frameworks" } ] } How can the quadrant field…
Flatten and filter multi-dimension JSON with JQ
I have the following JSON test.json: [ { "status": { "+@state": "up" }, "address": { "+@addr": "10.10.10.1", "+@addrtype": "ipv4" }, "ports": { "port": [ { "+@protocol": "tcp", "+@portid": "80", "state": { "+@state": "open" } }, { "+@protocol": "tcp", "+@portid": "443",…
Json – How to map array of object to object key-value pairs in JQ?
Using JQ how do I convert array of objects to key-value pair object? Given the JSON: [ { "name": "foo", "id": "123" }, { "name": "bar", "id": "456" } ] Desired output: { "foo": "123", "bar": "456" }
How can I write a jq expression to convert nested array objects in JSON to a JSON schema?
I have a JSON structure like this: { "objectSchema": { "fields": { "fieldArray": [ { "a": "b", "c": "d" }, { "x": 1, "y": "z" }, { "x": 1, "y": "z" } ] } } } My current jq -…
How can i validate a json against a template in jq?
I am having a shell script . in my shell script i have a command that returns the following data as a json . { "remoteIds": [ { "remoteId": "[fd00:10:244:1:0:0:0:12]--(http://fd00-10-244-1--12.nspace.pod:8080)", "requestsReceived": 1 } } i want to validate the above…
Json – using a pipe symbol in a jq command throws an error
I am having a shell script file validation-example.sh , it has the followign content expected_template = '{ "remoteIds": [ { "remoteId": "", "requestsReceived": 1 }, { "remoteId": "", "requestsReceived": 1 }, { "remoteId": "", "requestsReceived": 1 }, { "remoteId": "",…
How to merge 2 json files using jq (deep merge and concat array)
With jq command, I want to merge multiple json files. But I have no idea how to achieve below expectation. thanks in advance a.json { "key1": { "key2": [ 1, 2 ] }, "key3": "aaa" } b.json { "key1": {…
Json – How to make a certain double cartesian product with jq?
Suppose I have this dataset: {"id": 99, "labeled_values": [["one", "green"], ["two", "red"], ["three", "blue"]], "flavors": ["hot", "cold"]} {"id": 100, "labeled_values": [["four", "green"], ["five", "red"]], "flavors": ["hot"]} and I would like this output (tab-separated): 99 one green hot 99 two red…