A JSON Section data group takes Json data from either a Json base data group (ApiJson) or from a text value created using a function, typically a field in another data group.

The Root option lets you navigate down from the Json to the position in the Json from which data is required. The root is expressed with dot notation and using indexes for arrays. So Manufacturers[0].Products[0].Price would get the first manufacturer's first product's price, within the Json. There are more complex ways in which this can be used, see https://www.newtonsoft.com/json/help/html/SelectToken.htm for more details.

Data is returned in the form of a flattened Json file, in which the field names are dot notation representations of the root to a value. If the Json at the root (or top) is an array, each element will be one row in the resulting data. Otherwise a single row will be returned. The columns in the row(s) are the flattened Json values