Given the --data parameter of a curl statement: --data '{ "collection": [ "Library" ], "filter": "{'''target.endpointUID''':{'''$eq''': '''ABC123'''}}", "skip": 0, "limit": 16 }' I'd like to replace ABC123 with the variable I want to use but I cannot figure out the…
Below is a snippet of a MySQL Script mysql> SET @j1 = '[{"Documents": []}]'; mysql> SET @j2 = '{"rc":{"DisplayName":"Registration Certificate","Extension":"png"}}'; mysql> SET @path = '$[0].Documents[0]'; mysql> SELECT REPLACE(JSON_ARRAY_INSERT(@j1, @path, @j2), '\', ''); The output generated by above script is: [{"Documents":…
I have the following JSON { "Data": { "totalExecutionTime": "00:00:00.5544916", "totalCount": "33414", "Items": [ { "featureId": 100, "featureName": "Product", "id": 5903, "parentId": 0, "brand": "Normal", "order": 0, "createdDate": "2022-08-18T19:00:57.44", "modifiedDate": "2024-07-10T13:21:29.123", "Values": [ { "featureId": 100, "featureName": "Value", "seq": 0,…
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":…
I have a large dataset containing over 10 million JSON records. Could someone please advise on the most efficient method to insert these into a string column table? Currently, I am using clickhouse_driver, but it takes approximately one minute to…
I have a requirement in which I must have property that can bind it's value by "debtAmount" or "Amount" I did try to have annotation from above, and it works for debtAmount but value won't bind using "amount" I want…
[ { "id":"0001", "type":"donut", "name":"Cake", "ppu":0.55, "batters":{ "batter":[ { "id":"1001", "type":"Regular" }, { "id":"1002", "type":"Chocolate" } ] }, "topping":[ { "id":"5002", "type":"Glazed" } { "id":"5004", "type":"Maple" } ] }, { "id":"0002", "type":"donut", "name":"Raised", "ppu":0.55, "batters":{ "batter":[ { "id":"1001", "type":"Regular" }…
The frontend sends data in JSON format, but the backend receives empty data. this is the data frontend send. { "user": { "id": 0, "imgUrl": "default.jpg", "userName": "d", "password": "d", "email": "[email protected]" }, "verification": "d" } this is the data…
I am new to jolt transformation. what would be the jolt spec to transform my source json { "version": "123", "payload": { "details": { "payload_json": "{"FName":"rishi","LName":"dx","Id":"ABC123","aadharId":"XYZ22"}" } } } to target JSON { "firstName": "rishi", "lastName": "dx", "id": "ABC123", "officialIds":…
Please help me to provide JOLT spec for the below input JSON. tried multiple approach but still not working. there is an condition check on risk attribute if risk is "0" then risklevel low .if it is "1" then High…