Integration With Dynamics 365 For operations using OData proxy generator.

In This blog post we are going to look at how to expose and consume data entities in the new OData v4 endpoint in Dynamics 365 for Operations.
We will mainly focus on three task
·       Customize/Use a data entity provided by Microsoft.
·       Register a new application in Azure Active Directory.
·       Implement an OData client to consume OData services, including creating a proxy library for the Microsoft AX OData endpoint.
We are going to create simple Inventory movement journal as an example  Using out of the box available entities  InventoryMovementJournalHeader and InventoryMovementJournalEntry.
Customize Microsoft provided data entity
To make data entity available on Odata endpoint its isPublic property must be set to true. So for any standard entity you must change this property if it’s not already set to yes to make it available  on endpoint. When you create any new entity make sure you set isPublic = true so that its available on oDATA endpoint. In my scenario I am going to use above mentioned entities.
 To validate that configurations are now exposed in OData visit following URL. Here I am using ReleasedProduct entity just to verify URL is working.
/data/ ReleasedProducts?cross-company=true


Create a new application in AAD
1.       To create new application you have to log in to Microsoft Azure portal. Once you log in click on Active Directory and then click Applications along the top.
2.       Near the bottom of the browser window, click Add, enter a Name for your application and select the radio button for Native Client Application. Then click the next arrow.
3.       Enter a Redirect URL of “http://MYOData” (don’t specify quotes) and click the tick to complete the wizard.
4.       On the top toolbar, click Configure. Scroll down until you see permissions to other applications. Click Add application.
5.       Select Microsoft Dynamics ERP in the list and click the tick to complete the wizard. The application will be added to the list of applications.
6.       In the Delegate Permissions list, select all the check boxes.
7.       Click the save icon in the toolbar at the bottom of the page, and the application details will be saved.
For more information visit this link
Create ODATA Client
As Visual Studio is unable to directly consume OData v4 services via service references, you will need to use a T4 template which will generate the C# proxy library. More information on this can be found here

Use the OData v4 Client Code Generator in your Visual Studio application to build the OData entity proxy classes. This can be downloaded and installed from with Visual Studio. Once it is installed, you can add the OData client to the application. In the following screenshots, I added it  to my C# Console application project:


This will create a file with an extension of tt which stands for Text Template. Update the MetadataDocumentUri string value in the tt file so it contains your OData metadata endpoint.

https://******************.dynamics.com/data/$metadata

Once you update URI save this file ,This will read the metadata and build a large class file.It may take several minutes to complete. The generated proxy classes let you instantiate the data entity objects, set properties, and call methods to interact with the OData endpoint.


Implementing Authentication helper
Create a new C# project and add class classConfiguration.cs. 
using System;

namespace AuthenticationUtility
{
    public partial class ClientConfiguration
    {
        public static ClientConfiguration Default { get { return ClientConfiguration.OneBox; } }

        public static ClientConfiguration OneBox = new ClientConfiguration()
        {
            ODataEndpointUri = "https://********dev6358751fc5bd9ac4aos.cloudax.dynamics.com/data",
            
            ActiveDirectoryResource = "https://**********dev6358751fc5bd9ac4aos.cloudax.dynamics.com",
            ActiveDirectoryTenant = "https://login.windows.net/TenatId
            ActiveDirectoryClientAppId = "Your Client Id",
            key = "Your Client Secrete",

    };

        public string ODataEndpointUri { get; set; }
        public string UserName { get; set; }
        public string Password { get; set; }
        public string ActiveDirectoryResource { get; set; }
        public String ActiveDirectoryTenant { get; set; }
        public String ActiveDirectoryClientAppId { get; set; }

        public string key { get; set; }

    }
}





    

  1. ODataEndpointUri -The web address for your deployment’s OData endpoint, as per LCS. 
    2. 

  2. Azure Active directory client ID - The client ID is obtained in step 13 in "Create a web service application in Active Directory".
    3. 

  3. Azure Active directory client secret - The client secret is obtained in step 13 in "Create a web service application in Active Directory".
    4. 

  4. Azure Active directory resource - The Azure AD directory resource depicts the Finance and Operations root URL. Note: Do not end this field with a forward slash character (/).
    5. 

  5. Azure Active directory tenant - The Azure AD directory tenant used with the Finance and Operations server: https://login.windows.net/your-AD-tenant-ID. 
    6. 


Create a Dynamics AX OData client

Add another class and name it as OAuthHelper. This class contains whole logic to deal with AAD Authentication. 






using Microsoft.IdentityModel.Clients.ActiveDirectory;
using System;
using System.Net;

namespace AuthenticationUtility
{
    public class OAuthHelper
    {
        
                
        /// The authentication header for the Web API call.
        public static string GetAuthenticationHeader()
        {

            var request = HttpWebRequest.Create(ClientConfiguration.Default.ODataEndpointUri);

            AuthenticationContext authenticationContext = new AuthenticationContext(ClientConfiguration.Default.ActiveDirectoryTenant);
            // Get token object
            var ar = authenticationContext.AcquireToken(ClientConfiguration.Default.ActiveDirectoryResource, new ClientCredential(ClientConfiguration.Default.ActiveDirectoryClientAppId, ClientConfiguration.Default.key));
            // Create and get JWT token
            return ar.CreateAuthorizationHeader();

        }

    }
}


More information about authentication can be found here. Authentication utility project is available on GitHub at this location



Now we will create console application, where in we will use entities InventoryMovementJournalHeader and InventoryMovementJournalEntry to create Movement journal.








public class ODataAXConnector
    {
        private LogMessage logMessageHandler;

        private AXODataContext context;

        public ODataAXConnector(LogMessage logMessageHandler, bool enableCrossCompany)
        {
            this.logMessageHandler = logMessageHandler;

            this.context = new AXODataContext(enableCrossCompany);
        }

        public void CreateJournal(string JournalId, string targetAXLegalEntity)
        {
            // Check if journal exists
            if(!IsJournalExists(JournalId))
            {
                
                InventoryMovementJournalHeader jourHeader = new InventoryMovementJournalHeader();
                DataServiceCollection JournalCollection = new DataServiceCollection(context);
                JournalCollection.Add(jourHeader);
                jourHeader.JournalNumber = JournalId;
                jourHeader.JournalNameId = "IMov";

                                
                    InventoryMovementJournalEntry jourLines = new InventoryMovementJournalEntry();
                    DataServiceCollection JournalneCollection = new DataServiceCollection(context);
                    JournalneCollection.Add(jourLines);

                    

                        jourLines.LineNumber = number;
                        jourLines.JournalNumber = JournalId;
                        jourLines.JournalNameId = "IMov";
                        jourLines.ItemNumber = "1000";
                        jourLines.InventoryQuantity = 1;
                        jourLines.InventorySiteId = "1";
                        jourLines.InventoryWarehouseId = "13";
                        jourLines.OffsetMainAccountIdDisplayValue = "600150"; 
                    
                    context.SaveChanges(SaveChangesOptions.PostOnlySetProperties | SaveChangesOptions.BatchWithSingleChangeset);
                    
                                
            }

            logMessageHandler(string.Format("Created Journal  '{0}' in company '{1}'.", JournalId, targetAXLegalEntity));
           
        }

        private bool IsJournalExists(string JournalId)
        {
            bool exist = false;

            var query = from entity in context.InventoryMovementJournalHeaders
                        where entity.JournalNumber == JournalId
                        select entity;
            if (query.Count() > 0)
                exist = true;
            else
                exist = false;
            return exist;
        }

        
    }







In the above code objects are created for each entity and passed to different  datacollection for journal header and journal lines.  I used the SaveChangesOptions.BatchWithSingleChangeset enum in the SaveChanges method this ensures that if any of the object fails validations during saving data none of the record is created ,so it’s kind of running transaction with in a loop. 

  Note the context object used in isJournalExist method (an instance of AXODataContext) provides collections for each data entity which is exposed in the Dynamics AX OData endpoint. You can use regular LINQ style queries on these collections, and the underlying DataServiceContext object handles building the OData JOSN request which in the above example will simply return a response with the resulting count. I.e. because Count() is invoked on the query, the resulting generated JOSN request is an aggregate query; no need to fetch all the data just to count it!



In screenshot below you can see output of the above code

Journal Header:

 



Journal Lines:

 



 Hope this  article helps you in right direction to create integration with Dynamics 365 for operations using data entities.

 







































Location:
los angeles
















Comments











Post a Comment



















Popular posts from this blog









Running runnable class through URL in Dynamics 365 for Operations





















  Hi Everyone ,   There are multiple ways you can run Runnable class. One way is we can attach it to Menu item and add it to any form and execute it using menu item.   Another way is set it up you project as startup object and runnable class as startup object in Visual Studio and run it from Visual studio.   Another way of running it is from your browser (IE/Chrome).   https:// URL> /?cmp= &mi=SysClassRunner&cls=   Parameters:   Cmp  = Your company name e.g USMF   Cls = Your Runnable class name e.g. ShowInvoicedOrderCount   https://usnconeboxax1aos.cloud.onebox.dynamics.com/?cmp=USMF&mi=SysClassRunner&cls=ShowInvoicedOrderCount   Whenever you want to quickly verify anything this way is very useful and you don’t have to spent time seeing while visual studio opens diagnostic tool and load other windows.   








Read more










D365FO Use of FileUpload control to Read CSV file




















Image







  In Dynamics Ax implementation very often we get requirement to upload data using csv files. Although  in Dynamics 365 for operations it can be easily done using data entities and data packages, in this blog we will see how can we use new FileUpload control and design classes to read, download files.   In   Dynamics 365 for operations  application runs on cloud and the client is in web , so Microsoft has introduce new process to read files using Azure blob. When we upload file, that file gets uploaded to Azure blob and we have to read that file from Azure blob to retrieve data.    Design classes:    There are two main types of classes that developers can work with for the file upload control:      Upload strategy class  – This      class lets developers control various parameters that should be enforced      for uploaded files, such as the types of files that a user can upload and      the maximum size of a file. It also lets developers determine where and how ...








Read more










D365FO Send Report as email attachment





















  Hi All ,  Usually in any implementation project we get request to send Report as a attachment in email.  Below is code going to help you to send  report as an email attachment.  In the below code I am saving report in report archive(DocuRef table ) reading it from DocuRef table  in to bytes and converting it in to memory stream. The memory stream is further I am going to use to  send an email with Subject and body using SysMailerMessageBuilder class. You can use following methods of this class  setSubject - To set Subject of the email.  setBody -  To Set email body .  setFrom - To set sender of the email.  sendInteractive - To send interactively.  sendNonInteractive - TO send non interactively            Args                                    args;         SalesInvoiceContract                    salesInvoiceContract;         CustInvoiceJour                         custInvoiceJourLocal;         SRSPrintDestinationSettings             SRSPri...








Read more