D365 F&O cloud to on prem file transfer using Azure blob storage

  D365 F&O → Azure Blob Container → On-Prem System (file transfer)


Scenario:

Files generated in Dynamics 365 Finance & Operations (D365 F&O) are uploaded to an Azure Blob Container, and an on-premises system later downloads them using AzCopy.

Architecture Flow






X++ Code — Upload to Azure Blob Storage:

using Microsoft.WindowsAzure.Storage;

using Microsoft.WindowsAzure.Storage.Blob;

using Microsoft.Dynamics.AX.Framework.FileManagement;

using BlobStorageAssembly = Microsoft.WindowsAzure.Storage;


public class InvoiceFileOnBlobStorage

{

    public static void main(Args _args)

    {

        str connectionString = CloudStorageAccount::Parse(

            "DefaultEndpointsProtocol=https;AccountName=azureContainerAccountName;"

            "AccountKey=7sU+VCk1sb1uCnWChsvwhxvRTY93mSnvhv7b+Aw==;"

            "EndpointSuffix=core.windows.net"

        );


        BlobStorageAssembly.CloudStorageAccount storageAcct =

            BlobStorageAssembly.CloudStorageAccount::Parse(connectionString);


        BlobStorageAssembly.Blob.CloudBlobClient blobClient =

            storageAcct.CreateCloudBlobClient();


        BlobStorageAssembly.Blob.CloudBlobContainer blobContainer =

            blobClient.GetContainerReference(blobStorageParameter.ContainerName);


        blobContainer.CreateIfNotExistsAsync();


        utcDateTime now = DateTimeUtil::utcNow();

    

        str fileName = strFmt("ExportFileName_%1.csv", formattedOutput);

        str agingFileName = strFmt("AgingReport_%1_as_on.pdf", formattedOutput);


        BlobStorageAssembly.Blob.CloudBlockBlob blockBlob =

            blobContainer.GetBlockBlobReference(fileName);


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

        {

            str fileContent = this.generateInvoiceFile(fileName); // Generate invoice content 


            if (fileContent)

            {

                // Upload invoice CSV

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


                // Upload aging report PDF

                BlobStorageAssembly.Blob.CloudBlockBlob blockBlob2 =

                    blobContainer.GetBlockBlobReference(agingFileName);


                System.Byte[] reportBytes = this::getSSRSByte(agingFileName);

                System.IO.MemoryStream stream = new System.IO.MemoryStream(reportBytes);


                if (stream)

                {

                    blockBlob2.UploadFromStream(stream, null, null, null);

                    info("Customer aging report uploaded successfully");

                }


                blockBlob2.FetchAttributes(null, null, null);

                blockBlob.FetchAttributes(null, null, null);


                BlobStorageAssembly.Blob.BlobProperties blobProperties = blockBlob.Properties;


                if (blobProperties.Length != 0)

                {

                    info("Invoice file uploaded successfully");

                }

            }

        }

        else

        {

            error("File already exists in blob container");

        }

    }


    public static System.Byte[] getSSRSByte(str _fileName)

    {

        SrsReportRunController controller = new SrsReportRunController();

        SRSPrintDestinationSettings settings;

        System.Byte[] reportBytes = new System.Byte[0]();

        SRSProxy srsProxy;

        System.IO.MemoryStream stream;

        SRSReportRunService srsReportRunService = new SrsReportRunService();

        Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportingService.ParameterValue[] parameterValueArray;

        Map reportParametersMap;

        SRSReportExecutionInfo executionInfo = new SRSReportExecutionInfo();


        // Configure SSRS controller

        controller.parmReportName(ssrsReportStr(CustAgingReport, DesignWithNoDetailAndNoTransactionCur));

        

        // Printer settings

        settings = controller.parmReportContract().parmPrintSettings();

        settings.printMediumType(SRSPrintMediumType::File);

        settings.fileName(_fileName + ".pdf");

        settings.fileFormat(SRSReportFileFormat::PDF);


        // Prepare and render report

        controller.parmReportContract().parmReportServerConfig(SRSConfiguration::getDefaultServerConfiguration());

        controller.parmReportContract().parmReportExecutionInfo(executionInfo);

        reportParametersMap = srsReportRunService.createParamMap(controller.parmReportContract());

        parameterValueArray = SrsReportRunUtil::getParameterValueArray(reportParametersMap);


        srsProxy = SRSProxy::construct(controller.parmReportContract().parmReportServerConfig());


        // Actual rendering to byte array

        reportBytes = srsProxy.renderReportToByteArray(

            controller.parmReportContract().parmReportPath(),

            parameterValueArray,

            settings.fileFormat(),

            settings.deviceInfo()

        );


        return reportBytes;

    }

}


Next Step (On-Prem Download via AzCopy)

Once uploaded, the on-prem system can download the files using an AzCopy command or script such as:

azcopy copy "https://<storageaccount>.blob.core.windows.net/<container>?<SAS_TOKEN>" "D:\InboundFiles" -

Comments

Post a Comment

Popular posts from this blog

Execute D365 F&O SSRS report with parameter and upload report output on Azure blob storage using X++

Image
 Execute D365 F&O SSRS report with parameter and upload report output on Azure blob storage using X++ Steps: 1. Create controller class and execute SSRS report with parameter 2. Create Azure storage on Azure 3. Create Azure storage containers and folder to store report output 4. Get Azure connection key to establish connection between D365 F&O and Azure storage 5. Convert SSRS report output into byte stream 6. Upload byte stream to azure storage How to create Azure storage, containers and folder and get Azure connection key? Login to https://portal.azure.com Go to Storage account --> Storage browser --> Blob containers How to get  Connection string ? Go to Storage account --> Security + networking --> Access Key --> Connection string Code: using Microsoft.WindowsAzure.Storage; Using Microsoft.WindowsAzure.Storage.Blob; using System.IO; public class ExampleUploadReportToBlobStorage {     public static void main(Args _args)     {  ...
Read more

Microsoft D365 F&O: Remove custom models from deployable package

Image
Sometime we deploy custom model to PROD/Sandbox and due to some reason needs to revert back custom model code. If we revert back code, code reverted back but model still exist in the  environment. the next time when we suppose to deploy new package, deployment would failed with following reason: "The selected package is missing the following modules that are currently deployed on your environment. You must create an all-in-one deployable package that contains all your code customizations and ISV solutions. More information can be found at the following link:  https://go.microsoft.com/fwlink/?linkid=2118104 . Missing module(s): [ Package1 ] ,[ Package2 ] [ Package3 ]’ (Activity Id: ‘12345XXXX’)" I will explain how to remove the custom models from your environment(PROD/Sandbox). Steps 1.  Create a deployable package from your VM(Visual studio) or download the build package 2.  Unzip the deployable package and open the deployable package folder. 3. Go to   \AX...
Read more

Generate Text/CSV/DAT file using X++ and upload on Azure blob storage

 Generate Text/CSV/DAT file using X++ and upload on Azure blob storage There are many scenario's where we want to wrap data inside the file and upload on blob storage. Following code use to generate file and upload on azure blob storage. `   public void processOperation(Contract _contract)     {         #OccRetryCount         #File         InventTrans          inventTrans;         Query                query;         QueryRun             queryRun;         str                  stringToWrite;         int                  recordCount = 0;         stringToWrite = "Customer Account Number|Invoice Amou...
Read more