About the JSON Tool
The JSON tool is designed to parse JSON data and convert it into a structured format for further analysis. This tool allows you to flatten nested structures and extract key information from JSON objects.
Configuration Options
Input Field:
Select the field that contains the JSON data you want to parse.
Path to the Target Property (optional):
If you need to extract specific data within a nested JSON structure, specify the path using the format (e.g.,
"..parent.fieldToFlatten").
Parse Options:
Flatten to Fields: This option converts the JSON structure into individual fields.
Explode to Rows: This option creates new rows based on each element within the JSON array or structure.
Keep the Original Field: Select this option if you want to retain the original JSON field while parsing.
Additional Notes
Ensure that the input JSON field is properly formatted; otherwise, parsing errors may occur.