JsonToDictionary

<< Fare clic per visualizzazione il sommario >>

Percorso:  I servizi di Jamio openwork > Rest Service >

JsonToDictionary

Service

Rest

 

Method

JsonToDictionary

 

Description

Converts a Json string in a Dataset.

 

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 dictionary.

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 dictionary.

List of string

 

valuesIfNull

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

Ex.: if valuesIfNull contains “first_name”, “”, “trim_user”, false; the returned Dictionary 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 dictionary nodes, otherwise false.

Bool

 

Output

Name

Description

Type

Optional

returnValue

A dataset.

Dataset

 

 

Remarks

The jsonFieldNames and dictionaryFieldNames lists must have the same number of elements.

As an example, if jsonFieldNames[0] = “pageid” and dictionaryFieldNames[0] = “PageNumber”, the “pageid” field in the Json structure will be returned as the “PageNumber” field in the dataset; fields not present in the jsonFieldNames list will retain their names in the returned dataset.