pfx-api:truncate

 

Properties

Option

Type

Default

Description

Option

Type

Default

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.

typedId

string

 

Defines typedId of the Pricefx entity, e.g. 181.CFS.

targetName

string

 

Defines the target name.

sql

string

 

Optional parameter which can be used instead of the PfxApiConfigurationfilter link. Accepts an SQL-like syntax to define a filter logic. For example: 'SELECT a WHERE b 1 ORDER BY a ASC'

The FROM clause has to be omitted – it has no meaning in the filter API.

incrementalDate

date

 

 

connection

string

 

Defines a connection to Pricefx. This is an optional parameter and if it is omitted, the connection is taken from the Spring bean named pricefx.

sortBy

string

 

Defines the sorting. It overrides sortBy from a filter. Allows expression value (groovy, simple, constant).

enableNullFields

Boolean

false

Defines if during fetch null fields should be returned via REST API back to a client. 

filter

string

 

Defines the name of a filter used by the fetch or delete commands.

systemFilter

string

 

 

customFilterExpression

string

 

Defines a custom filter expression. It allows for more advanced filtering, for example customFilterExpression=attribute1>attribute2 filters all rows where the value in the attribute1 column is greater than values in the attribute2 column.

This method takes the exchange body.

Examples

<route> <from uri="direct:start"/> <setBody> <constant>data</constant> </setBody> <to uri="pfx-api:truncate?targetName=DMDS.Prices&amp;connection=pricefx"/> <to uri="mock:end"/> </route>

IntegrationManager version 5.8.0