By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| version() |
|---|
| 8.0.36 |
| Data |
|---|
| { "SucceededAt": "2022-01-18T07:54:50.5548083Z", "PerformanceDuration": "1463", "Latency": "91", "Result": ""Request Body: {\"request\":[{\"id\":[{\"value\":\"1\"}],\"roles\":{\"receiver\":{\"id\":[{\"value\":\"1115559991\"}]}},\"details\":{\"adjustmentAmount\":{\"value\":7800}}}]}, Response Body:{\"response\":[{\"id\":[{\"value\":\"1\"}],\"parts\":{\"specification\":{\"characteristicsValue\":[{\"characteristicName\":\"MSISDN\",\"value\":\"9998885556\"},{\"characteristicName\":\"ResponseCode\",\"value\":\"1000\"},{\"characteristicName\":\"ResponseDescription\",\"value\":\"Operation successfully.\"}]}}}]}"" } |
| json_value(Data, '$.Result') |
|---|
| "Request Body: {"request":[{"id":[{"value":"1"}],"roles":{"receiver":{"id":[{"value":"1115559991"}]}},"details":{"adjustmentAmount":{"value":7800}}}]}, Response Body:{"response":[{"id":[{"value":"1"}],"parts":{"specification":{"characteristicsValue":[{"characteristicName":"MSISDN","value":"9998885556"},{"characteristicName":"ResponseCode","value":"1000"},{"characteristicName":"ResponseDescription","value":"Operation successfully."}]}}}]}" |
| json_unquote(json_value(Data, '$.Result')) |
|---|
| Request Body: {"request":[{"id":[{"value":"1"}],"roles":{"receiver":{"id":[{"value":"1115559991"}]}},"details":{"adjustmentAmount":{"value":7800}}}]}, Response Body:{"response":[{"id":[{"value":"1"}],"parts":{"specification":{"characteristicsValue":[{"characteristicName":"MSISDN","value":"9998885556"},{"characteristicName":"ResponseCode","value":"1000"},{"characteristicName":"ResponseDescription","value":"Operation successfully."}]}}}]} |
| request | response |
|---|---|
| {"request":[{"id":[{"value":"1"}],"roles":{"receiver":{"id":[{"value":"1115559991"}]}},"details":{"adjustmentAmount":{"value":7800}}}]} | {"response":[{"id":[{"value":"1"}],"parts":{"specification":{"characteristicsValue":[{"characteristicName":"MSISDN","value":"9998885556"},{"characteristicName":"ResponseCode","value":"1000"},{"characteristicName":"ResponseDescription","value":"Operation successfully."}]}}}]} |