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? |
---|---|---|
| Compoment ID | yes |
| Price parameter lookup table ID | no |
| Name of the price parameter lookup table; this name has to be unique and must exist | no |
| Filter of records in the table | yes |
Â
Example of usage
<to uri="pfx-api:fetch?filter=filterPricingParameterValues&objectType=LTV&pricingParameterName=ExchangeRate&batchedMode=true&batchSize=5000"/>
<split>
<simple>${body}</simple>
<to uri="pfx-api:fetch?filter=filterPricingParameterValues&pricingParameterName=ExchangeRate&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