Import Price Lists Items from MS Dynamics to Pricefx

This template fetches Price List Items from MS Dynamics via REST API and imports them to Pricefx Product Master Extension table using a customer defined mapper.

ImportPLIFromMSD01.png


Connection between PlatformManager and MS Dynamics

For details see How to Create MS Dynamics Connection.

Installation

Go to PlatformManager > Marketplace, find Import Price Levels from MS Dynamics to Pricefx, select Deploy and then select a target integration instance and template version.

Configuration Steps

  1. Choose the MS Dynamics REST OAUTH2 connection to be used.

  2. Configure Integration Template parameters:

    • Cron expression for triggering import – Defines when this Integration Template should run. Example value: "0+0+*+*+*+?+*".

    • MS Dynamics API version – Version of the target MS Dynamics API. You should enter only the number without the usual "v" in the path. Example value: "9.1".

  3. Define a mapper to map Price List Items from MS Dynamics to Pricefx.

    • It must include a constant mapping the PX table name to the output “name”.

      mapper pricelist msd.jpg

Troubleshooting Tips

For details see How Data Import Works (MS Dynamics) – Accounts, Products, Price List Items.