X++ code to upload files from Dynamics 365 to Azure Blob Storage

using BlobStorage = Microsoft.WindowsAzure.Storage;

using Microsoft.Dynamics.AX.Framework.FileManagement;

using System.IO;

class RunnableClass3

{

    /// <summary>

    /// Runs the class with the specified arguments.

    /// </summary>

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

    public static void main(Args _args)

    {

        CommaStreamIo       io = CommaStreamIo::constructForWrite();

        CustTable           custTable;

        const str           connectionString = "DefaultEndpointsProtocol=https;AccountName=sarathbujala;AccountKey=6bCwPjV6Co3bIFgOTv6sQs+/rnXbcJbwe1gPfRofTH8zBXy0AteMv34xruT0pSrUu5V0ZxO8Li4X+AStVXATBQ==;EndpointSuffix=core.windows.net";

        const str           containerName = "sarathcontainer";

        const str           fileName = @"C:\Users\Administrator\Desktop\Mydetails.csv";

  

        BlobStorage.CloudStorageAccount storageAccount = BlobStorage.CloudStorageAccount::Parse(connectionString);

        BlobStorage.Blob.CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient();

        BlobStorage.Blob.CloudBlobContainer blobContainer = blobClient.GetContainerReference(containerName);

        blobContainer.CreateIfNotExistsAsync();

  

        io.writeExp(['CustomerName']);

  

        while select custTable

            where custTable.DataAreaId == 'USRT'

        {

            io.writeExp([custTable.AccountNum]);

        }

  

        BlobStorage.Blob.CloudBlockBlob blockBlob = blobContainer.GetBlockBlobReference(fileName);

  

        if(blockBlob && !blockBlob.Exists(null,null))

        {

            System.IO.Stream stream = iO.getStream();

            stream.Position = 0;

            System.IO.StreamReader reader = new System.IO.StreamReader(stream);

            str csvFileContent = reader.ReadToEnd();

            

            if(csvFileContent)

            {

                blockBlob.UploadText(csvFileContent,null,null,null,null);

                blockBlob.FetchAttributes(null,null,null);

                BlobStorage.Blob.BlobProperties blobProperties = blockBlob.Properties;

  

                if(blobProperties.Length != 0)

                {

                    info('File upload successful');

                }

            }

        }

        else

        {

            info('File already exits');

        }


    }


}

Comments

Post a Comment

Popular posts from this blog

How to Create a wizard in x++ d365

Image
 step1: Create a form and apply form pattern as wizard step2 : create a class and extend the class with SysWizard. code :            class BAS_WIzardScreen extends SysWizard {     #MACROLIB.AviFiles     FormName formname()     {         return formstr(BAS_WIzardForm);  // name of the wizard form     }     public void run()     {         info(strFmt("Thankyou"));     }     public void setupNavigation()     {     }     public boolean validate()     {         return true;     }     public static str description()     {         return "BASOFA WIZARD";  // title of the wizard     }     public static void main(Args _args)     {         BAS_WIzardScreen wizard = new BAS_WIz...
Read more

how to post trade agreement journals automatically using x++ code

  In Microsoft Dynamics AX, you can post trade agreement journals automatically using X++ code. Here are the steps to do so: Create a new job in X++. Write a code to fetch data from the trade agreement table. Create a journal header and journal lines based on the fetched data. Call the post() method of the journal header to post the journal. Repeat steps 2 to 4 for each trade agreement. Here's a sample code in X++: static void postTradeAgreementJournals(Args _args) { TradeAgreementTable tradeAgreementTable; GeneralJournalHeader generalJournalHeader; GeneralJournalLine generalJournalLine; // Fetch data from the Trade Agreement table select tradeAgreementTable where tradeAgreementTable.JournalPosting == NoYes::No; // Loop through each trade agreement while (tradeAgreementTable) { // Create a journal header generalJournalHeader = new GeneralJournalHeader(); generalJournalHeader.initValue(); generalJournalHeader.tra...
Read more

x++ code to submit and approve and reject the invent movement workflow in d365 F&O

 class Class1 {     public  void submitworkflow()     {         InventJournalTable journalTable;     WorkflowWorkItemTable   WorkflowWorkItemTable;    WorkflowVersionTable        workflowVersionTable;                journalTable = InventJournalTable::find('00446');               // submit to workflow         if (journalTable.WorkflowApprovalStatus == InventJournalWorkflowApprovalStatus::NotSubmitted)         {             Workflow::activateFromWorkflowType(workFlowTypeStr(InventJournalMovementTemplate), journalTable.RecId,                                     'Workflow submitted by button', false, Curuserid());         }    ...
Read more