The JSON String to ESP formatter translates JSON strings to AepRecord objects. Set values for this formatter in the adapter configuration file.
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:
|
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. |