| Argument | Category | Description |
|---|---|---|
| TextColumn | Required | Specifies the name of the input table column that contains the JSON string. |
| Nodes | Required | Specifies the parent/child pairs. All pairs must have the same format. You can specify a parent with multiple children with this syntax:parent_node/{child_node [,…]} |
| SearchPath | Optional | Specifies the path to find the direct value of the child. To reach the grandparent, include it in this path. When you include the path to grandparent, you can output all the siblings of the parent by including them in the Nodes argument. If anything from root is to be parsed, represent it as either '/' or an empty string. |
| Delimiter | Optional | Specifies the delimiter that separates multiple children with the same name and the same parent node in the JSON String. The default value is ',' (comma). The delimiter cannot include '#'.
|
| MaxItemNum | Optional | Specifies the maximum number of nodes with the same name to display in the output. The default value is 10. |
| NodeIDOutputColumn | Optional | Specifies the name of the column to use in the result schema to contain the identifier (from the input table) of the each node extracted. The default value is 'out_nodeid'. |
| ParentNodeOutputColumn | Optional | Specifies the name of column to use in the result schema to contain the tag name of the parent node extracted. The default value is 'out_parent_node'. |
| Accumulate | Optional | Specifies the names of the input table columns to copy to the output table. |
| ErrorHandler | Optional | Specifies whether the function continues processing when the input table contains bad data (for example, invalid UTF-8 characters) and adds an error column to the output table. The default value is 'false' (the function aborts). The name of the error column is output_column (if specified) or ERROR_HANDLER (by default). The error column contains the data from each specified input_column, separated by semicolons. If you specify no input_column, the error column is empty. |