How to Import XML File to BC

julkifli33

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>

ShaiHulud

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.


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.

ShaiHulud

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.


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.

julkifli33

Hi @ShaiHulud thanks for the reply.
do you have any sample or reference how to use this?
Thanks.

RockWithNAV

Xmlport references you will find a lot on Internet, try yourself wont be that complicated.

julkifli33

@RockWithNAV
xmlport not successfull.
format doesnt supported.

@ShaiHulud
i managed to import this using your advise
thanks.