Input
The input table, json_parser_data_3, is the same as json_parser_data in JSONParser Example 1: Nondefault Values, except for a formatting error: The data column is missing a closing quotation mark and a colon after the menuitem field.
id | data |
---|---|
1 |
{"menu": { "id": "1", "value": "File", "popup": { "menuitem [ {"value": "New", "onclick": "CreateNewDoc()"}, {"value": "Open", "onclick": "OpenDoc()"}, {"value": "Close", "onclick": "CloseDoc()"} ] } }} |
SQL Call
SELECT * FROM JSONParser (
ON json_parser_data_3
USING
TextColumn ('data1')
Nodes ('menuitem/value')
ErrorHandler ('true; data1')
) AS dt ORDER BY 1, 2;
Output
out_nodeid | out_parent_node | menuitem:value | ERROR_HANDLER |
---|---|---|---|
0 |
{"menu": { "id": "1", "value": "File", "popup": { "menuitem [ {"value": "New", "onclick": "CreateNewDoc()"}, {"value": "Open", "onclick": "OpenDoc()"}, {"value": "Close", "onclick": "CloseDoc()"} ] } }}; |