How to Import XML File to BC

julkifli33
julkifli33 Member Posts: 1,100
in NAV Three Tier
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

  • ShaiHulud
    ShaiHulud Member Posts: 228
    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

Categories