AXForum  
Вернуться   AXForum > Microsoft Dynamics AX > DAX Blogs
DAX
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 12.01.2017, 17:11   #1  
Blog bot is offline
Blog bot
Участник
 
25,459 / 846 (79) +++++++
Регистрация: 28.10.2006
stoneridgesoftware: Working with the OData Endpoint in Dynamics 365 for Operations
Источник: https://stoneridgesoftware.com/worki...or-operations/
==============

*Please note: New Dynamics AX (AX7) has been renamed Dynamics 365 for Operations.

The OData endpoint is a new REST-based service that allows for integrating with Dynamics 365 for Operations. Below are some tips to help with using an OData client to authenticate and use methods to read and write data in the system.

Data Entities

Data Entities that are marked ‘Yes’ for the ‘Is Public’ property will be available as an OData endpoint. You can consume this OData endpoint in your external application such as a .Net application for integration scenarios.

In the screenshot below, I have created a custom data entity called CPRCustCreditRatingEntity. Note the Is Public, Public Collection Name and Public Entity Name properties:



When viewed using the Chrome browser, I can see my custom Data entity is available:





Tip: If using IE to view the OData endpoint, you might have to open the JSON results in a separate file download. Chrome will automatically show the JSON results in the browser.

Creating a OData Client Application

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 downloaded it and then 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. For example, mine is:

public const string MetadataDocumentUri = “https://usnconeboxax1aos.cloud.onebo...data/$metadata“;

Lastly, right click on the tt file and choose to ‘Run custom tool’. This will read the metadata and build a large class file (45+ MB). It may take several minutes to complete. You can explore the CS file when it completes.



Using the generated proxy classes

The generated proxy classes let you instantiate the data entity objects, set properties, and call methods to interact with the OData endpoint. The following is an example of reading a CustCreditRating record using a LINQ (System.Linq) query pattern:

//Get Single CustCreditRatingConsole.WriteLine("Get a single CustCreditRating instance...");CustCreditRating existCustCreditRating = GetCustCreditRating("USMF", "US-010");Console.WriteLine("Credit Rating for {0} is {1}. Press Enter.", existCustCreditRating.CustomerAccount, existCustCreditRating.CreditRating);Console.ReadLine();The GetCustCreditRating method:#region Get Single CustCreditRating private static CustCreditRating GetCustCreditRating(string targetAXLegalEntity, string customerAccount) { context.SendingRequest2 += new EventHandler(delegate (object sender, SendingRequest2EventArgs e) { var authenticationHeader = OAuthHelper.GetAuthenticationHeader(); e.RequestMessage.SetHeader(OAuthHelper.OAuthHeader, authenticationHeader); }); var custCreditRatingQuery = from entity in context.CustCreditRatings where entity.DataAreaId == targetAXLegalEntity && entity.CustomerAccount == customerAccount select entity; return (custCreditRatingQuery.Count() > 0) ? custCreditRatingQuery.First() : null; }#endregionThe following code is a complete example of creating multiple Customer records using the OData endpoint:using System;using AuthenticationUtility;using Microsoft.OData.Client;using CustomerOdataClient.Microsoft.Dynamics.DataEntities;namespace CustomerOdataClient{ class Program { private static string ODataEntityPath = ClientConfiguration.Default.ODataEndpointUri; private static Uri oDataUri = new Uri(ODataEntityPath, UriKind.Absolute); private static Resources context = new Resources(oDataUri); static void Main(string[] args) { Console.WriteLine("Set HTTP header..."); context.SendingRequest2 += new EventHandler(delegate (object sender, SendingRequest2EventArgs e) { var authenticationHeader = OAuthHelper.GetAuthenticationHeader(); e.RequestMessage.SetHeader(OAuthHelper.OAuthHeader, authenticationHeader); }); Console.WriteLine("Creating new customer using Data Entity OData..."); Customer myCustomer = new Customer(); DataServiceCollection customersCollection = new DataServiceCollection(context); customersCollection.Add(myCustomer); myCustomer.CustomerAccount = "US-X11111"; myCustomer.Name = "ABC Trees 111"; myCustomer.CustomerGroupId = "10"; myCustomer.SalesCurrencyCode = "USD"; myCustomer.CreditRating = "Excellent"; myCustomer.AddressCountryRegionId = "USA"; #region Create multiple customers Customer myCustomer2 = new Customer(); customersCollection.Add(myCustomer2); myCustomer2.CustomerAccount = "US-X22222"; myCustomer2.Name = "ABC Rains vb"; myCustomer2.CustomerGroupId = "10"; //myCustomer2.SalesCurrencyCode = "USD"; myCustomer2.CreditRating = "Excellent"; myCustomer2.AddressCountryRegionId = "USA"; #endregion DataServiceResponse response = null; try { response = context.SaveChanges(SaveChangesOptions.PostOnlySetProperties | SaveChangesOptions.BatchWithSingleChangeset); Console.WriteLine("created ok"); } catch (Exception ex) { Console.WriteLine(ex.Message + ex.InnerException); } Console.ReadLine(); } }}In the code above, two Customer objects are being created and passed into a DataServiceCollection named customersCollection. I am using the optional SaveChangesOptions.BatchWithSingleChangeset enum in the SaveChanges method. This means if one of the Customer objects fails validation then neither of the Customer objects are created. Since both Customers run under one batch in the HTTP call to the OData endpoint if one fails then they both do.

Lastly, the Resources object that has been instantiated as ‘context’, is using objects from the AuthenticationUtility project to help with authentication. This is a C# library project made of two classes to help in setting up the authentication to the OData endpoint and retrieving the authorization token. This AuthenticationUtility project can be found in Microsoft’s Dynamics AX Github repository at https://github.com/Microsoft/Dynamic...icationUtility.

Hopefully, this post can steer you in the right direction on how to successfully interact with the OData entities in Microsoft Dynamics 365 for Operations.





Источник: https://stoneridgesoftware.com/worki...or-operations/
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
Теги
d365fo, data entity, odata

 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
stoneridgesoftware: Dynamics 365 and Microsoft AppSource – What does it mean for clients? Blog bot DAX Blogs 0 14.07.2016 01:14
stoneridgesoftware: Working with Task Recorder and Task Guide in New Microsoft Dynamics AX Blog bot DAX Blogs 0 27.05.2016 00:16
stoneridgesoftware: How to use a View to Simplify Working with Query Classes in Dynamics AX Blog bot DAX Blogs 0 26.05.2016 18:11
NAV Team: Validating Single Sign-on with Office 365 and Microsoft Dynamics NAV 2013 R2 Blog bot Dynamics CRM: Blogs 0 19.12.2013 15:00
axinthefield: Dynamics AX Event IDs Blog bot DAX Blogs 0 01.03.2011 22:11
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 21:51.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.