jsonFieldExtractor: Extract fields from repeating JSON structures.

Provides a Knowledge Flow component that can be used to extract one or more fields from repeating blocks of JSON formatted text contained in the values of String attributes.The value of each string attribute in each instance is assumed to contain JSON blocks of the same structure. The user can specify a "path" to use for finding the field to extract. Each field extracted becomes a new attribute in the outgoing instances structure. The type of each attribute and its legal values (if nominal) can also be specified. Given the following "Alias" JSON structure:

{alias: [{firstname: "bob", lastname: "smith"}, {firstname: "fred", lastname: "jones"}]}

one would extract the lastname of the second element of the array with a path like:

$.alias[1].lastname

All available versions:
Latest
1.0.0