JSON Functions

json_extract_path_text(string json, string xpath)

Extracts JSON string from a JSON string based on json path specified and returns JSON string pointed to by xPath

Parameters:

• string –
• string –

Return type:

text

Example:

json_extract_path_text('{"test" : {"key" : "tajo"}}','$.test.key');
> tajo