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. |