pfx-api:integrate, pfx:ppvIntegrate - Upsert Price Parameter Value

This component is used to load records into 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

Component ID

no

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

mapper

Name of the integrate mapper for converting the message body to the Pricefx format

yes

partitionPfxApi

 

no

 For PP tables the following objectTypes:

  • pfx-api:integrate use objectType=LTV

  • pfx-api:loaddata use objectType=MLTVn

If you set a different value, you can get this error “Not authorized for command: MATRIXLOOKUPTABLEVALUE_INTEGRATE”.

 

Example of usage:

<to uri="pfx-api:integrate?objectType=LTV&amp;mapper=rebateAgreementsMapper&amp;pricingParameterName=RebateAgreements"/> ... <to uri="pfx-api:integrate?objectType=LTV&mapper=rebateAgreementsMapper&pricingParameterId=35847"/> <pfx:integrateMapper id="rebateAgreementsMapper"> <pfx:body in="Agreement" out="key1"/> <pfx:body in="SalesOrganization" out="key2"/> <pfx:body in="Partner" out="key3"/> <pfx:body in="Type" out="attribute1"/> ... </pfx:integrateMapper>

Deprecated from 1.1.15

<pfx:csv-to-list id="LoadRebateAgreements" dataFormat="rebateAgreementsCsvDataFormat" batchSize="500"> <pfx:ppvIntegrate id="ppvIntegrateValues" pricingParameterId="35847" mapper="rebateAgreementsMapper"/> </pfx:csv-to-list> <pfx:integrateMapper id="rebateAgreementsMapper"> <pfx:body in="Agreement" out="key1"/> <pfx:body in="SalesOrganization" out="key2"/> <pfx:body in="Partner" out="key3"/> <pfx:body in="Type" out="attribute1"/> ... </pfx:integrateMapper>

IntegrationManager version 5.8.0