The ESP to JSON Stream formatter translates AepRecord objects to JSON strings, and sends the JSON strings to next streaming output transporter that is configured in the adapter configuration file. Set values for this formatter in the adapter configuration file.
| XML Element | Description |
|---|---|
| ColsMapping |
(Required) Element containing the Column element. |
| Column |
Type: complextype (Required) Specify JSONPath expressions for the JSON data that you want to map to columns of an ESP stream. You can have multiple Column elements. For example, if you had the following JSON data about a
person,
{
"firstName": "John",
"lastName": "Smith",
"phoneNumbers": [
{
"type": "home",
"number": "212 555-1234"
},
{
"type": "fax",
"number": "646 555-4567"
}
],
"friends": [
["female1","female2","female3"],
["male1","male2","male3"]
]
}
you
could get the individual's first name by using the JSONPath
expression firstname. If you want the first phone number, specify
phoneNumbers[0].number as the JSONPath expression. Each JSONPath
expression must represent one record.The first <Column/> element and its value are mapped to the first column of an ESP stream, the second <Column/> element and its value are mapped to the second column of an ESP stream, and so on. |
| DateFormat |
Type: string (Advanced) The format string for date values. For example, yyyy-MM-dd'T'HH:mm:ss. |
| TimestampFormat |
Type: string (Advanced) Format string for timestamp values. For example, yyyy-MM-dd'T'HH:mm:ss.SSS. |