pfx-api:fetch, pfx:ppvFetch - Fetch Price Parameter Values

This component is used to fetch specified records from the price parameters table in Pricefx. The pricingParameterId attribute contains ID of the table which can be different in another partition. For this reason there is the attribute pricingParameterName which is used only if pricingParameterId is not used. The name of the table has to exist and be unique, otherwise the pricingParameterId is required.

Attributes

Description

Required?

Attributes

Description

Required?

id

Compoment ID

yes

pricingParameterId

Price parameter lookup table ID

no

pricingParameterName

Name of the price parameter lookup table; this name has to be unique and must exist

no

filter

Filter of records in the table

yes

 

Example of usage

<to uri="pfx-api:fetch?filter=filterPricingParameterValues&amp;objectType=LTV&amp;pricingParameterName=ExchangeRate&amp;batchedMode=true&amp;batchSize=5000"/> <split> <simple>${body}</simple> <to uri="pfx-api:fetch?filter=filterPricingParameterValues&amp;pricingParameterName=ExchangeRate&amp;objectType=LTV"/> <log message="${body}"/> </split>

 

<pfx:filter id="filterPricingParameterValues" resultFields="name,value"> <pfx:and/> </pfx:filter> <pfx:ppvFetch id="deletePricingParameterValues" pricingParameterId="31029" filter="filterPricingParameterValues"/>

IntegrationManager version 5.8.0