Input
The input table, json_parser_data_3, is the same as json_parser_data in JSONParser Example: 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 ;
Output
out_nodeid out_parent_node menuitem_value errorhandler ---------- --------------- -------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 0 NULL NULL {"menu": { "id": "1", "value": "File", "popup": { "menuitem [ {"value": "New", "onclick": "CreateNewDoc()"}, {"value": "Open", "onclick": "OpenDoc()"}, {"value": "Close", "onclick": "CloseDoc()"} ] }}};
Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.