SAW 17: Question on JSON parsing (dbo.sp_parse_json procedure)

[Stalker4]

Hi,

SAP SQL AnyWhere 17.0.10.

There is some JSON packet. I pass it to the procedure "sp_parse_json" for processing

declare cJSON long varchar;
call dbo.sp_parse_json('sql_array', cJSON);

I will get the parsed JSON package into the variable "sql_array".

Question: How do I check "sql_array" for the presence of a certain field in a JSON packet? JSON-package, whether this field is there or not ?

[PCollins]

.

[VolkerBarth]

A similar question has been discussed years ago in the separate SQL Anywhere Forum (y'know, the forum with easily searchable contents - whereas I now need to google via "sp_parse_json site:sqlanywhere-forum.sap.com" to find this - as a sample for PCCollin's hint to do error handling:
SQL Anywhere 17: sp_parse_json how to handle properties that are not passed when empty

[PCollins]

I couldn't face trying to find it 😉