Export released products and linked data in 1 XML file

(0) Share

Report

Posted on by TejaswiniUL

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?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Community Member on at

Like (0)

Report

RE: Export released products and linked data in 1 XML file

Thank you so much Martin. Finally i have done that :)

Was this reply helpful? Yes No
Martin Dráb 235,934 Most Valuable Professional on at

Like (1)

Report

RE: Export released products and linked data in 1 XML file

Assuming that you're talking about AIF document services, every document is based on a query and the query obviously can use several tables. For example, AxdSalesOrder consists of more than ten tables (order header, lines, inventory dimensions, miscellaneous charges and so on). Data from all these tables can then be included in the response.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Export released products and linked data in 1 XML file

@Martin Dráb Can you please explain how to add data to the response in my operation? In my scenario i am exporting Case information using outbound port with CaseWebDetailService.Read operation. I want to export related tables data along with, particularly from CaseAssociation table and related items/products associated with case.
Or how to use Data Import Export Framework in this scenario.

any help is highly appreciated.

Thanks

Was this reply helpful? Yes No
TejaswiniUL on at

Like (0)

Report

RE: Export released products and linked data in 1 XML file

Thanks Martin

Was this reply helpful? Yes No
Verified answer

Martin Dráb 235,934 Most Valuable Professional on at

Like (0)

Report

RE: Export released products and linked data in 1 XML file

Yes, each service operation returns a single response. What you would need is adding more data to the response of your operation, not creating additional operations.

By the way, consider using the Data Import Export Framework instead of the Application Integration Framework.

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,284 on at

Like (0)

Report

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

Hi Tejaswini U,

If you need to add additional tables to standard document service you can easily add new data sources, please refer to technet article technet.microsoft.com/.../gg840400.aspx

Was this reply helpful? Yes No