Create Xml using X++ - D365 FnO

 class My_XMLCreate

{

    /// <summary>

    /// Runs the class with the specified arguments.

    /// </summary>

    /// <param name = "_args">The specified arguments.</param>

    public static void main(Args _args)

    {

        XmlDocument xdoc;

        XmlElement  xElement;

        XmlElement  xTable, xNodeAccount, xNodeName;

        MainAccount mainAccount;


        #define.filename(@'C:\Temp\accounts.xml');


        xdoc = XmlDocument::newBlank();

        xElement =xdoc.createElement('xml');

        xdoc.appendChild(xElement);


        while select RecId, mainAccountId, Name from mainAccount

        {

            xTable = xdoc.createElement(tableStr(MainAccount));

            xTable.setAttribute(fieldStr(MainAccount, RecId), int642Str(mainAccount.RecId));

            xElement.appendChild(xTable);

            

            xNodeAccount = xdoc.createElement(fieldStr(MainAccount, MainAccountId));

            xNodeAccount.appendChild(xdoc.createTextNode(MainAccount.MainAccountId));

            xTable.appendChild(xNodeAccount);

            

            xNodeName = xdoc.createElement(fieldStr(MainAccount, Name));

            xNodeName.appendChild(xdoc.createTextNode(mainAccount.Name));

            xTable.appendChild(xNodeName);

        }


        xdoc.save(#filename);

        Info(strFmt("File %1 created", #filename));



    }


}

Comments

Post a Comment

Popular posts from this blog

Azure BLOB storage with Dynamics 365 FnO X++

Image
Part-1: Azure BLOB storage with Dynamics 365 for operations 25 May 2020|Azure and Dynamics With the introduction of cloud based applications, Dynamics has opened doors for seamless integration with Azure services. This blog is created to portray one such example of how Azure capability can be utilized within Dynamics 365 for Operations. Lets consider a common scenario where Dynamics 365 for Operations needs exchange of files between different applications. This can be a file produced by your .Net application (or) it can be a file produced by you production system,etc,. In Dynamics AX 2012 this situation was handled by creating common folder and sharing in network path where different applications can place their files. Upon introduction of D365, local paths were not accessible by Dynamics production URL so we need to rely on common internet service for accessing the file. One of the convenient way to handle this situation is by using  Microsoft Azure BLOB storage  as the centra
Read more

Send Email from Ax / D365 FnO using X++

 static void SendEmail(Args _args) { SysEmailParameters parameters = SysEmailParameters::find(); SMTPRelayServerName relayServer; SMTPPortNumber portNumber; SMTPUserName userName; SMTPPassword password; Str1260 subject,body; InteropPermission interopPermission; SysMailer mailer; System.Exception e; ; if (parameters.SMTPRelayServerName) relayServer = parameters.SMTPRelayServerName; else relayServer = parameters.SMTPServerIPAddress; portNumber = parameters.SMTPPortNumber; userName = parameters.SMTPUserName; password = SysEmailParameters::password(); subject = "Subject line for the email"; body = "<B>Body of the email</B>"; CodeAccessPermission::revertAssert(); try { interopPermission = new InteropPermission(InteropKind::ComInterop); interopPermission.assert(); mailer = new SysMailer(); mailer.SMTPRelayServer(relayServer,portNumber,userName,password, parameters.NTLM); //instantiate email mailer.fromaddress("ax.notification@mycompany.com"); mailer.
Read more

Import Files from Blob storage using X++ - D365 FnO

 using Microsoft.WindowsAzure.Storage;  Using Microsoft.WindowsAzure.Storage.Blob;  class RunnableClassBlobStorageDownload  {      ///       /// Runs the class with the specified arguments.     ///       ///  The specified arguments.      public static void main(Args _args)      {          CloudBlobDirectory  cloudBlobDirectory;          CloudBlobClient  cloudBlobClient;          CloudBlobContainer  cloudBlobContainer;          CloudStorageAccount  cloudStorageAccount;          cloudStorageAccount  = CloudStorageAccount::Parse("Azure Blob Connection String");          cloudBlobClient = cloudStorageAccount.CreateCloudBlobClient();          cloudBlobContainer  = cloudBlobClient.GetContainerReference("files"); //           System.Collections.IEnumerable lstEnumarable =   cloudBlobContainer.ListBlobs(null, false, 0, null, null);          System.Collections.IEnumerator lstEnumarator = lstEnumarable.GetEnumerator();          List filenames = new List(Types::String);      
Read more