How to Import XML File to BC

julkifli33julkifli33 Member Posts: 984
Hi All..
how to import xml file to BC?
I am not familiar with XML port?
should we use XML Port? or use standard code?
anyone can share?

here is the sample file.
<supplier operation="add" id="V-000001" exportTime="2021-07-16T18:03:04">
<alias>VENDOR ABC</alias>
<company>Vendor ABC</company>
<addUser id="1">dcs Support1</addUser>
</supplier>

Best Answer

  • ShaiHuludShaiHulud Member Posts: 155
    Accepted Answer
    Check out Table 1235 "XML Buffer". It has some functions to read XML file into it and then you can filter the data using standard NAV/BC filtering as a regular record.
    h1y5wvdb3l8f.png

    When you read into an XML Buffer, my personal suggestion would be to show a page with the data, so you'd have a better idea how it's structured once it's read into NAV/BC.

Answers

Sign In or Register to comment.