Greg On Dynamics Ax: AIF Pipeline Example

[Blog bot]

Источник: http://feedproxy.google.com/~r/GregO...3/fCRsZMW9KNg/
==============

In my last post (Top 5 AIF Development Tips and Tricks) I mentioned how you can use the AIF to transform external messages into the format that AX expects. This post elaborates upon that tip with a more detailed example.

Suppose you want to import currency exchange rates.

AX has an action for this out of the box – createListExchangeRates, and will happily accept a message similar to this:

Original>/DocPurpose> GBP 1.71 2009-09-21 2009-09-22 Thats all well and good if you have control over the schemas of any inbound messages.
Most likely this is not the case, say for example you want to import the exchange rates for the euro from the european central banks daily published list (http://www.ecb.europa.eu/stats/eurof...xref-daily.xml).

If you try and receive this it will fail on two counts:
1) It is not wrapped in an envelope (which is used by the AIF to identify the message sender and destiation) and
2) the format of the exchange rate does not match AX schema.

To solve problem 1) you can make use of the ’Wrap XML in AIF envlope’ program available from axaptapedia here:www.axaptapedia.com/AIFEnvelopeTool

To solve 2) you can use the pipeline to specify an XSLT to transform the message, the XSLT to perform the transformation for this example is:

After running the AIF inbound service upon last weeks exchange rates it results in the following data being created (US Dollar highlighted):
Exchange rates AX form







Источник: http://feedproxy.google.com/~r/GregO...3/fCRsZMW9KNg/