JSON String to ESP Formatter Module Parameters

The JSON String to ESP formatter translates JSON strings to AepRecord objects. Set values for this formatter in the adapter configuration file.

This formatter is row based and can connect two row based transporters rather than streaming based transporters.
Parameter Description
ColumnMappings

(Required) Section containing the ColsMapping parameter.

ColsMapping

(Required) Section containing the Column parameter.

Column

Type: string

(Required) Specify a value for the JSON data that you wish to map to ESP columns. This value is matched by a pattern path expression. For example, [<Column>JSONPath expression</Column>].

The first <Column/> is mapped to the first column of an ESP row, the second <Column/> is mapped to the second column of an ESP row, and so on.

This parameter has two attributes:
  • streamname – Specify which stream to publish.
  • rootpath – Specify a rootpath for the JSON data. You can use one rootpath to publish more than one ESP row from one JSON data record.
DateFormat

Type: string

(Advanced) The format string for parsing date values. For example, yyyy-MM-dd'T'HH:mm:ss.

TimestampFormat

Type: string

(Advanced) Format string for parsing timestamp values. For example, yyyy-MM-dd'T'HH:mm:ss.SSS.