Show TOC

ESP to JSON Stream Formatter Module ConfigurationLocate this document in the navigation structure

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.

This formatter is streaming based and can connect two stream-based transporters rather than row-based transporters.
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 the a 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 a stream, the second <Column/> element and its value are mapped to the second column of a stream, and so on.
SecondDateFormat

Type: string

(Advanced) The format string for SecondDate values.

For example, yyyy-MM-dd'T'HH:mm:ss is the default value.
MSDateFormat

Type: string

(Advanced) The format string for MsDate values.

For example, yyyy-MM-dd'T'HH:mm:ss.SSS is the default value.