Export Business Partners to XML
How do i export all data in Business Partners table into XML without using SQL statements? I tried exporting records one by one using getbykey method but is there any way to export all the records to a XML?Plz help.
Frank Moebius replied
No, I do not recommend to use only SQL (it may happen to be necessary, if you need to maximize performance).
There's a mechanism that you can run a query on the Business Partner table - e.g. "SELECT CardCode FROM OCRD" and connect the result (DI API's Recordset object) with the business object (Recordset property of the Browser sub-object of business obejcts) and export the business object data to XML (record by record).
The DI API samples which are shipped with the SDK + the new SDK E-learning etc. explain how it works in detail - or simply search for "DataBrowser Operations" in the SDK Helpcenter 2005. There you will find the sample code as well.
Regarding change of the table name from OCRD to sth else:
Of course this could (theoretically) become an issue, but I would see the risk as far below 1%