X++ Code to read XML file in D365FO

-
X++ Code to read XML file in D365FO

Hi Guys,

The below code will help you to read an XML file from Local File Path and insert into Table.
        XmlDocument         xmlDocument;
        XMLParseError       xmlError;
        XmlNode             rootNode,bodyNode;
        XMLNodeList         tagsList;
        XmlNamedNodeMap     map;
        int                 j;
        RecordInsertList    recordInsertListCust;
        CustomerTableTmp    customerTabletmp;
        Str        fileName =@''D:Temp\customer.XML";
             
        xmlDocument = new XmlDocument();
        xmlDocument.load(fileName);
        xmlError  = xmlDocument.parseError();
        if(xmlError && xmlError.errorCode() != 0)
        {
            throw error(strFmt("XML Error: %1", xmlError.reason()));
        }
        rootNode = xmlDocument.documentElement();
        recordInsertListCust = new RecordInsertList(tableNum(CustomerTableTmp));
       if(rootnode.hasChildNodes())
        {
            tagsList = rootnode.childNodes();
            for(j = 0; j < tagsList.length(); j++)
            {
                bodyNode = tagsList.item(j);
                map= bodyNode.attributes();
                customerTabletmp.clear();
                customerTabletmp.Account    = map.nextNode().nodeValue();
                customerTabletmp.Address    = map.nextNode().nodeValue();         
                customerTabletmp.ContactPersonNo= map.nextNode().nodeValue();
                customerTabletmp.Country = map.nextNode().nodeValue();
                customerTabletmp.Currency = map.nextNode().nodeValue();
                customerTabletmp.CustomerGroup =map.nextNode().nodeValue();
                customerTabletmp.Discount =map.nextNode().nodeValue();
                customerTabletmp.Email =map.nextNode().nodeValue();
                customerTabletmp.GSTNo =map.nextNode().nodeValue();
                customerTabletmp.GSTType =map.nextNode().nodeValue();
                customerTabletmp.Name = map.nextNode().nodeValue();
                customerTabletmp.PANNumber =map.nextNode().nodeValue();
                customerTabletmp.State =map.nextNode().nodeValue();
                customerTabletmp.Imported = NoYes::No;
                recordInsertListCust.add(customerTabletmp);
            }
            recordInsertListCust.insertDatabase();
        }


Limitation:The way XML attribute and values are arranged in XML file,in the same order we need to insert to table. 




ThankYou.
















































Comments











Post a Comment



















Popular posts from this blog









x++ code to add hyperlink to a field in D365FO






-















 Here is a way to provide hyperlink for field.     1.Create an Extension class to the form as below.   [ExtensionOf(formStr(TestHistory))]  public final class  TestHistoryForm_Extension  {       }     2.Copy onPostRun form eventhandler and write code as below.            [FormEventHandler(formStr(TestHistory), FormEventType::PostRun)]       public static void TestHistory_OnPostRun(xFormRun sender, FormEventArgs e)       {           FormStringControl   formCtrl = sender.design().controlName(formControlStr(TestHistory,TestHistory_Voucher));           formCtrl .registerOverrideMethod(methodStr(FormStringControl, jumpRef), methodStr(TestHistoryForm_Extension, JumpRefId), sender);       }        3.write definition for JumpRefId method      public void jumpRefId(FormControl _formControl)       {           MenuFunction    menuFunction;         ...








Read more










x++ code to get Vendor Email Address based on Purpose in Dynamics 365 for Operations






-















 public static  Email   getVendorEmailAddress()      {                 VendTable  vendTable;          DirPartyLocation dirPartyLocation;          LogisticsElectronicAddress elecAddress;          LogisticsElectronicAddressRole elecAddressRole;          LogisticsLocationRole locRole;          Str vendNum;                vendNum='205181';//Vendor Number                    select firstonly  DirPartyLocation                      where dirPartyLocation.party ==  VendTable::find(vendNum).Party//Vendor Number              join   elecAddress                      where elecAddress.Location == dirPartyLocation.Loca...








Read more










x++ code to get Customer Address based on purpose in ax 2012






-















    static void  customerAddress(Args _args)  {      DirPartyPostalAddressView           dirPartyPostalAddrlocal;      DirPartyLocationRolesView           dirPartyLocationRoleslocal;      LogisticsLocationRole                   logisticsLocRole;        select firstOnly   * from dirPartyPostalAddrlocal order by RecId desc          exists join dirPartyLocationRoleslocal              where dirPartyLocationRoleslocal.Location   == dirPartyPostalAddrlocal.Location                  && dirPartyLocationRoleslocal.Party     ==     CustTable::find(_accountNum).Party//_dirpartyRecid                  //&& dirPartyPostalAddrlocal.IsPrimary == NoYes::No          exists j...








Read more