Hi.
I have this code snippet
declare
v_json varchar2(32000) := '{"@odata.context":"https://apistaging.payspace.com/odata/v1.1/43066/$metadata#OrganizationUnit","@odata.nextLink":"https://apistaging.payspace.com:443/odata/v1.1/43066/OrganizationUnit?$skip=200","value":[{"OrganizationUnitId":554661,"ParentOrganizationUnitId":554588,"UploadCode":"01261","Description":"01261 - CA Beverage Department","CostCentre":true,"OrganizationLevel":"Department","GroupGlKey":"01261","Budget":null,"Reference":null,"ManagerEmployeeNumber":null,"InactiveDate":null,"Address":null,"ActiveEmployees":0},{"OrganizationUnitId":554662,"ParentOrganizationUnitId":554588,"UploadCode":"01281","Description":"01281 - Financial Management","CostCentre":true,"OrganizationLevel":"Department","GroupGlKey":"01281","Budget":null,"Reference":null,"ManagerEmployeeNumber":null,"InactiveDate":null,"Address":null,"ActiveEmployees":0}]}';
begin
apex_json.parse (v_json);
dbms_output.put_line ('Value: ' || apex_json.get_varchar2 ('@odata.nextLink'));
end;
The code will not find the value of the key @odata.nextLink
If I remove the @ and . and make it “odatanextLink”then it will work. But I do note control over the json. I there an issue with @ and . in the json?