Differences

This shows you the differences between two versions of the page.

--- transformations:parsejson [2025/02/07 01:48] – craigt
+++ transformations:parsejson [2026/09/22 07:15] (current) – Added advanced options, parsing modes roberto
@@ Line 11: / Line 11: @@
 ^Setting^Description^
 | Column  | The column containing the source JSON to be parsed.  |
-| JSON Path<sup>*</sup>  | The path to the JSON node from which parsing starts. [[https://support.smartbear.com/alertsite/docs/monitors/api/endpoint/jsonpath.html|Learn more about the path syntax.]]|
+| JSONPath<sup>*</sup>  | The path to the JSON node from which parsing starts. [[https://support.smartbear.com/alertsite/docs/monitors/api/endpoint/jsonpath.html|Learn more about the path syntax.]]|
-| Column names  |Select the method to be used to name columns in the result dataset.   |
+| Column names  |Select the method to be used to name columns in the result dataset.\\ Options: //Property name//, //Full JSON path//|
-| Don't delete original column  | When checked, the column with parsed JSON(s) will be kept in the result dataset.  |
 | Properties  | Select which properties to parse.  One property corresponds to one column in the result dataset.\\  Options:  //Parse all properties// or //Parse selected properties// (and select which properties to parse).  |
 <sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
+\\
+====Advanced options====
+^ Setting  ^ Description  ^
+|Don't delete original column|When checked, the column with parsed JSON(s) will be kept in the result dataset.|
+|Parsing mode|Select how nested JSON objects and arrays are turned into rows and columns.  Options:  //Dense//, //Sparse// (see "Parsing modes" below).|
+\\
+===Parsing modes===
+^Mode ^Description ^
+|Dense|Default option. Properties of nested objects are placed in the same row as their parent's properties, and a new row is created only for each array item.|
+|Sparse|Each nested object gets its own row, and an empty column is added for each array, so the result has more rows and more empty cells.|
 \\