Microsoft Flow for AX7 integration – Part 3 – exporting data to a local file

Let’s continue our journey looking at how Microsoft Flow can be used to build integrations for Microsoft Dynamics 365 for Operations (also known as AX7).

This latest post gives examples of how to export data from Microsoft Dynamics 365 for Operations (AX7) into your local file system in JSON, XML, or CSV formats using Microsoft Flow. It assumes that the Microsoft Flow on-premises data gateway is already installed and configured – if not, refer to Part 2 of the series.

Scenario

  1. Based on recurring schedule (trigger),
  2. Query all customer records from AX (action),
  3. Transform the data into required format (action),
  4. Write the data into a file in the local file system (action).

Continue reading

Microsoft Flow for AX7 integration – Part 2 – importing data from a local file

In Part 1 of the series, I shared an example that shows how Microsoft Flow works in general and how it connects to Microsoft Dynamics 365 for Operations (also known as AX7). This part tries to explain the usage of the on-premises data gateway, to work with files on the local computer or a local network share. It also shows how to loop though the source data and run Microsoft Flow actions for every data record.

Scenario

  1. Whenever a JSON file appears in a source folder (trigger),
  2. Read the content of the file (action),
  3. Loop through all the data records to find customer records (loop),
  4. For every customer record, call AX via OData to create the customer in AX (action),
  5. After going through all the records, move the source file into an archive folder (action).

Continue reading

Microsoft Flow for AX7 integration – Part 1 – working with OData

I have just started to study the capabilities of Microsoft Flow in connection with Microsoft Dynamics 365 for Operations (also known as AX7). I have found quite a few features that are worth sharing. I will split my notes into a series of posts, each of them dealing with an example integration scenario. I start by introducing Flow and its general capabilities to handle AX7 data. Continue reading