Notifications
Announcements
No record found.
Hi,
I have an XML file as well as an xsd file. How do I build a custom data entity using one of these two files? I just want to read the XML file into a temporary object/table, and join that table with a salesQuotationLine table with same primary key (itemId).
Thank you in advance,
TN.
That's not how it works. You build a data entity by selecting tables, field and so on in F&O and implement custom business logic if needed. No such a thing can generated from a data file.
If you want to import data that don't belong to any existing table, you can create a new one.
Nevertheless the best approach will be - as always - explaining your business requirement. Then we should be able to suggest a meaningful technical solution.
Then how to create that table using an XML/XSD file?
I am trying to create a sales quotation using an XML file, which has basic information like below.
We are reading it, get each item, match it to our inventory itemId, and use the length and weight field for each item in the XML file and assign them to length/ weight field for our corresponding inventory objects
2017-04-11T09:12:26 FabSuite 16.0r02 Test Test Test WY 12345 US Edward Test (307) 637-2222 info@test.com Puma Steel 1720 Pacific Ave Cheyenne Wy 82007 US Edward Carlson (307) 637-7177 info@pumasteel.com Puma Steel 1720 Pacific Ave Cheyenne WY 82007 US Edward Carlson (307) 637-7177 info@pumasteel.com 1 REX-TEST2 66a7d612-2c43-4c82-9673-5c4aa69ea98f 3 101.125 480.34 23B REX-TEST2 P_28010-T W W12X19 A992 2017-04-18T00:00:00 Destination Truck a491ea05-d1d4-4d75-8e7c-12c03d86e306 3 101.125 480.34 172B REX-TEST2 P_28010-T W W12X19 A992 2017-04-18T00:00:00 Destination Truck dfc41cff-c5c9-4b90-8268-510076dcb6a8 1 101.125 160.11 658B REX-TEST2 P_28010-T W W12X19 A992 2017-04-18T00:00:00 Destination Truck 0e3c3f9f-fbf3-4a08-853f-6e79852f4713 1 101.125 160.11 751B REX-TEST2 P_28010-T W W12X19 A992 2017-04-18T00:00:00 Destination Truck 8ecaeb3d-a7fe-4655-872f-c57e5e154f81 4 102 646 276B REX-TEST2 P_28010-T W W12X19 A992 2017-04-18T00:00:00 Destination Truck a8b8554c-1b12-4e04-b2bf-b32c91bba61e 1 102 161.5 850B REX-TEST2 P_28010-T W W12X19 A992 2017-04-18T00:00:00 Destination Truck
Thanks in advance,
TN
If your goal is sales quotations, you should use (implement if necessary) an entity for sales quotations. You shouldn't be creating any table.
Nevertheless the file doesn't have a format that can be imported to F&O. I suggest using XSLT to transform it to a format matching the entity. Then you can configure an import project in data management to use this transformation.
Hi Martin,
My requirement is to format a xml file based on schema in D365 data management.
Details - we are exporting data using an entity into xml format, now the other system for which the xml is exported requires it in xml but bit of formatting and not directly as how we get from data management export. I know there is some way to attach schema(in xslt) format for exporting data in xml file using data management but now sure how to achieve that. could you please help me with steps to do so.
Dev
You can configure XSLT transformations in "source to staging" mapping.
You can see an example here: XSLT transformation in Dynamics 365 for operation.
Thanks goshoom - this worked.
That's good to hear.
Please don't forget to mark the reply/replies answering the question. Use Did this answer your question? > Yes on the reply.
goshoom - I do not have enough permission on this post to mark answer as yes.
Aha, OK. I'll report this problem.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 646 Most Valuable Professional
André Arnaud de Cal... 529 Super User 2025 Season 2
Sohaib Cheema 285 User Group Leader
