pfx-api:integrate

Upserts objects.

Properties

Option

Type

Default

Description

Option

Type

Default

Description

typedId

string

 

Defines typedId of the Pricefx entity.

mapper

string

 

Defines a mapper name which is a Spring bean or definition in the header or property.

objectType

object

 

Defines the object type. Possible values are listed at Type Codes.

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.

pricingParameterId

string

 

Defines the Price Parameter ID.

connection

string

 

Defines 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 an expression value (groovy, simple, constant).

enableNullFields

Boolean

false

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

pricingParameterName

string

 

Defines the pricing parameter name for lookup table values.

filter

string

 

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

condition

string

 

If an existing record in Pricefx does not match this condition, the update will not be done. 

businessKeys

string

 

Defines the business key.

truncate

Boolean

false

Defines if truncate should be used for the import command.

deDuplicate

Boolean

true

Defines if deDuplicate should used for the import command.

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.

Examples

<route id="importExportedCarsToCarsSync"> <from uri="file:{{data.directory}}/export/px/cars/?delete=true"/> <to uri="pfx-csv:unmarshal?skipHeaderRecord=true"/> <to uri="pfx-api:integrate?objectType=LTV&amp;mapper=pricingParameterValueMapper&amp;pricingParameterName=ExchangeRate"/> </route>

IntegrationManager version 5.8.0