The operator's input schema determines the set of fields that appear in the generated JSON output. The hierarchy of the fields in the schema matches that of the elements in the JSON. Fields containing null are optionally discarded and may not appear in the JSON output. The incoming schema is duplicated to the output schema and a new user defined field is added which contains the JSON output.
This section describes the properties you can set for a Tuple to JSON operator, using the various tabs of the Properties view in StreamBase Studio.
Output Field Name The name of the field to be created in the output schema that contains the JSON converted from the incoming tuple.
Tuple Field The field in the inbound tuple that contains the tuple to convert to JSON. Leave blank to convert the entire inbound tuple.
Enable Status Port If enabled, the status port is made available to receive output status messages.
Include Null Fields Include null fields in the JSON output.
Timestamps as long If enabled, timestamp fields are converted to a long value.
Timestamp Format The format to use when converting timestamp values to a string.
Encode Sub Type The type of transformation that should be used when there are sub-tuples to process.
Map — Converting to a map adds field names to the JSON output.
List — Converting to a list produces a compact JSON string but does not provide field names.
The operator has one input port and two output ports to communicate with the surrounding application.
TupleIn: The tuple to be converted to JSON. The TupleIn port can be any schema.