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

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 24.12.2019, 20:14   #1  
Blog bot is offline
Blog bot
Участник
 
25,459 / 846 (79) +++++++
Регистрация: 28.10.2006
msdynamicsworld: How to use Power Automate to extract data from Microsoft Dynamics 365 Finance and Operations via Data management package REST API
Источник: https://msdynamicsworld.com/story/ho...perations-data
==============

In Microsoft Dynamics 365 Finance and Operations there are two APIs strategies that support file-based integration scenarios:
  1. Data management framework's package API
  2. Recurring integrations API
Both APIs support data import and data export scenarios, and both use batches. Batch data APIs are considered asynchronous integration patterns because when these APIs are called, data is imported or exported in batch mode. However, calls to these APIs are synchronous. For example, a call to the ExportToPackage API schedules a job to import only a specific data package. The scheduling job is quickly returned (synchronously), and the work is done later in a batch (asynchronously). Therefore, batch data APIs are categorized as asynchronous.

In this article, we will review how to leverage Power Automate and the Data Management package REST API to extract data from Dynamics 365 Finance. We will use the example of extracting “Customer groups” in Dynamics 365 Finance. However, any data entity that is exposed can be leveraged to export data from the system. Here are high level steps:
  1. The flow is triggered manually from Power Automate. However, it can be automated as well based on certain events that can be used with Power Automate.
  2. The request is submitted from Power Automate to Dynamics 365 Finance to extract the ‘Customer Group’ data. The entity is configurable and other entities can be used as well.
  3. A data project execution job is scheduled and run in Dynamics 365 Finance.
  4. Wait for the data project execution for a specific duration to see if the data project execution is completed successfully.
  5. Retrieve the package URL from the data project execution.
  6. Leverage Data Package URL to extract the file and store it on One Drive for Business (or another supported data storage service).
  7. From here the information can be retrieved and reviewed or shared with other systems.
If Power Automate steps are named appropriately, it can be sufficient to explain all the steps, screenshot below provide details:



<h2>Power Automate – Important steps in this flow


Источник: https://msdynamicsworld.com/story/ho...perations-data
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
msdynamicsworld: From the Microsoft Dynamics 365 for Finance and Operations/AX Blogs: Upgrade; Role assignment; Budgeting basics; D365 Finance and Supply Chain Management Blog bot DAX Blogs 0 30.11.2019 05:35
msdynamicsworld: From the Microsoft Dynamics 365 for Finance and Operations/AX Blogs: Rule offset; Demo users; Cycle count; Electronic reporting Blog bot DAX Blogs 0 30.08.2019 21:20
msdynamicsworld: MSDW Podcast: Data warehouses and Azure data lakes for Microsoft Dynamics 365 for Finance and Operations users, with Kirk Donahoe (https://axforum.info/story/msdw-podcast-data-warehouses-and-azure-data-lakes-microsoft-dynamics-365-fi Blog bot DAX Blogs 0 27.08.2019 04:20
powerobjects: How to Integrate Power BI with Dynamics 365 for Finance and Operations Blog bot Dynamics CRM: Blogs 0 26.06.2018 01:23
littleax: Data management package API in Microsoft Dynamics 365 for Finance and Operations Blog bot DAX Blogs 0 10.04.2018 15:11
Опции темы Поиск в этой теме
Поиск в этой теме:

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

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

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

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