Properties

Option	Type	Default	Description

Option	Type	Description
`outputTarget`	string	Defines output target for data in the exchange. It can be stored in the header, property or body.
`outputTargetName`	string	Defines output target name for the target type header and property. Put here the name of exchange header and name of exchange property.
`targetName`	string	Name of the target.
`maxRows`	integer	Defines maximum number of rows to be exported.
`suffix`	string
`filter`	string	Name of the filter.
`sql`	string	Optional parameter. Can be used instead of a regular table filter. Accepts SQL-like syntax to define a filter logic. Example: `'SELECT a WHERE b < 1 OR a <= 3 AND x > 1 ORDER BY a ASC'` The From clause has to be omitted – it has no meaning in filter API.
`sortBy`	string	Sort by. It overrides `sortBy` from the filter.
`connection`	string	Defines connection to Pricefx. This is an optional parameter and if it is not mentioned, the connection is taken from the Spring bean named pricefx.

This method takes the exchange body as input data.

Examples

<route>
    <from uri="direct:start"/>
    <to uri="pfx-api:datamartExport?targetName=DMDS.SegmentPrices&amp;suffix=Full&amp;maxRows=2500&amp;filter=myFilter"/>                
    <to uri="mock:end"/>
</route>