Input

Name

Description

Type

Optional

json

A string containing data in Json format.

String

fields

A list containing the names of the first-level fields to return in the Dictionary; a null or empty list implies that all fields are returned.

List of string

jsonFieldNames

A list containing the names of fields (regardless of the level) that have to be mapped to the corresponding fields specified in the dictionaryFieldNames list; a null or empty list implies that the field names in the Json structure will be used as keys in the returned dataset.

List of string

dictionaryFieldNames

A list containing the names of the dictionary keys corresponding to the field names specified in the jsonFieldNames list; a null or empty list implies that the field names in the Json structure will be used as keys in the returned dataset.

List of string

valuesIfNull

A Key/Value pair collection containing values to assign to the specified fields if their returned value is null.

Example: if valuesIfNull contains

“first_name”, “”

“trim_user”, false

the returned Dataset will have

any field named “first_name” (at any level) valued with “” instead of null

and any field named “trim_user” (at any level) valued with false instead of null.

Dataset

preserveTypes

true if json object types ("$types") must generate dataset nodes, otherwise false.

Boolean

Output

Name

Description

Type

Optional

returnValue

A dataset.

Dataset