Skip to main content
Version: 5.3

JSON Write Transfer Object

With the JSON transfer object as a simple data exchange format, you can evaluate, change or create formatted texts or data in JSON. Create a JSON transfer object within the connection as described. A plug-in configuration is not necessary. You can configure the transfer object directly within the connection as described. The JSON expression is “JSONPath”.

Here you will find an overview of the most important JSONPath syntax elements compared to the XPath elements:

XPathJSONPathDescription
/$The parent object/element
.@Element in current context
/.or []Specification for child elements
//..Recursive descent
**Placeholder. All objects/elements regardless of their name are selected.
[][]Subscript operator for element collections.
[]?()Executes a filter (script) expression.

JSON Write Transfer Object

After double-clicking on the transfer object, set the following properties:

Data fieldsEnter the JSON items directly or select entries from the JSON tree and use the “arrow up” or “F+” button to add. The names of the items can be freely assigned and serve as help during project planning. The items can be written and read during a transfer.
JSON ParametersIf necessary, enter additional parameters for default values here. During the transfer, the placeholder “{parameter}” is replaced by the given value ($.some[0].value). If nothing was passed, the default value is used.
JSONThe JSON Tree is the standard JSON document during a transfer. This can be read and written to. You can click on the “Edit” button and enter your tree structure or you can create the JSON structure through the UI. The button “suggestions” searches the connection for already executed sessions and JSON files. If a JSON document was found, you can take it as template.
Fill values

select between different modi

  • Fill array values on all levels
  • Fill array values only within the same array.
  • Duplicate document when an array is written to the data field

A tree structure is defined in the editor of the JSON tree as follows:

{ 
"key":"value", 
"some":[
{"name":"one","value":1},
{"name":"two","value":2},
{"name":"three","value":3}
] 
}