By using this website, you agree to our Terms of Use (click here)
Hi all,
I'm sharing this because I lost an hour searching for the answer, and trying everything I could think of.
SHORTEST ANSWER:
XML Data Provider does NOT do what you think it does. It reads files created specifically for it that include a full data structure at the start.
It has no way of reading the full data structure of your XML file, to use anything like what most systems use for XML packets, you'll need to create custom data providers.
Full help article on this is here:
https://help-2019r2.acumatica.com/Wiki/ShowWiki.aspx?pageid=3fa49466-c99e-47ac-a32a-4d1a4bc2fe99
This answer is 100% in debt to the following Stack Overflow user, without them I would never have found the part of the wiki that details this:
https://stackoverflow.com/users/3708398/user3708398
Hi William,
The first time I tried using the XML Data Provider, documentation was not available and I had to decompile it to understand what it did. It's not clear to me if this can be used for anything useful, so I ended up creating my own data provider in C# to use for the different scenarios I had to deal with. It's not that hard and it gives you 100% control over the output.
Gabriel
Thanks for sharing your findings @will_howard
AcuSync (click here) might be worth looking into if you need something that does a better job of handling XML files. @aardolino would know better about how flexible they are in handling XML files.
Hi @will_howard nice to meet you. @timrodman thanks for thinking of us.
William - if you are looking to build an integration with XML, let me know if we can help. Happy Holidays!
Online Members
