Hello,
I have a JSON like as below:
Sample response body :
{
"id": 36,
"organization_id": 3,
"name": "Test Name",
"organization_customer_id": null,
"test_serial": [
"ABCDRRRTTT"
],
"remaining_activations": 1
}
I have to design the JSON like as below and the READ:
p_json_resp is defined as CLOB
l_json json;
l_json := json_parser.parser (p_json_resp);
How to get the COUNT of the JSON above
In the below not able to frame it out to get the COUNT
FOR i IN 1 .. json_ext.get_json_list (l_json, '').COUNT