AX 2012 AIF Outbound - Released Product and Linked data in 1 XML file

684 views Asked by At

I'm on AX 2012 R3 CU10.

I need to export Items data (Released Products) in XML format. But also related data like:

  • Translations (Product > Languages > Translations)
  • Site Specific Order Settings for Sales, Purch and Invent (Manage inventory > - Order settings > Site specific order settings)
  • External Item Description (Sell > Related information > External item description)
  • Product Attributes Data (Product > Setup > Product attributes)
  • Document Handling (Product > Attachments > Attachments)
  • etc...

I can make an outbound port with a single Service Operation. That works fine.
However, adding multiple Service Operations to a single port seems to result in one XML file for each Service Operation.
I need a single XML per Released Product.

I have the impression that AIF is designed to handle only 1 single Service Operation per Outbound Port.
And that all the data that you want in a single XML output file, needs to be able to be queried by 1 single AOT Query node.

Does anyone know how to export the data I need in one single XML file?

1

There are 1 answers

3
Aliaksandr Maksimau On BEST ANSWER

To export all data that you need in one single file you should create new AIF document service. First, create an AOT query that contains the required information. The link below will help you find the tables that you need and create a query. How to: Create a Document Query [AX 2012]. Also you can use the following picture as a hint

Query sample

Then create AIF service using AIF Document Service Wizard. Please refer the link below for details How to: Create a Service by Using the AIF Document Service Wizard [AX 2012]