Utilities

Create Object from JSON

json1
json2
json3

Activity converts either a String variable (eg. output from Read Text File), or data from an existing text file into either a Wizlink Data, or custom type variable, depending on chosen output parameter.

Wizlink Data Output requires a variable of type Wizlink Data. Custom Type Output requires a custom object variable that matches the structure of the JSON content. 

Only one type of output can be selected. 

json4
json7

Wizlink Data Output requires a variable of type Wizlink Data. This is the universal solution, the internal structure of resulting object will be an exact representation of the imported JSON data.

json5
json6

Custom Type Output requires a custom variable that exactly matches the structure of the JSON data you want to import. In the example above the simple JSON structure can be read into a Dictionary of Dictionaries (Dictionary<String,Dictionary<String,String>>)

In both cases, lastName of the employee can be accessed by [name of variable]("employees")("lastName")

Parameter NameParameter TypeIn/OutDescription
Alternative Scenario If FailedBooleanInputcheckbox; default is "on"
Display NameLiteralInputchanges display name of the activity
Exclude from Transaction CheckBooleanInputcheckbox; default is "off"
Content/File PathStringInputinput string or directory path to a file (file name and extension included)
Export from FileBooleanInputcheckbox; default is "off"
Custom Type Output-Outputtype of output object (all but WizlinkData)
ResultBooleanOutputreturns a Boolean value. True if no error in activity, otherwise will return False
Result CodeInt32OutputResult Code will return 0 if there is no error in activity, otherwise in most cases it will return 1, the extended result code will show only in several chosen activities
Wizlink Data OutputWizlinkDataOutputtype of output object