How to export data from Business Central to a csv file with Power Automate (No customization) – JSON to csv

Today I would like to talk about how to export data from Business Central to a csv file with Power Automate in details.
Power Automate is a service that helps you create automated workflows (or flows) between apps and services, like Business Central. With Business Central, you’re given a license to Microsoft Power Automate

Source : Dynamics 365 Lab
Read more…

Dynamics 365 Business Central: How to export data from tables to CSV (comma-separated values) file

Today I would like to talk about how to export data from tables to CSV (comma-separated values) file.

A CSV (comma-separated values) file is a text file that has a specific format which allows data to be saved in a table structured format. Anyone familiar with spreadsheet programs has very likely encountered CSV files before, they’re easily consumed by Microsoft Excel, and countless other applications.

Source : Dynamics 365 Lab
Read more…

Export SQL data to CSV or XML File via Powershell

Sometimes it may be useful or necessary to use powershell to read data from SQL Server to export it to other formats This can also be used with older versions of Dynamics NAV which do not have access to the integrated powershell. Using standard powershell commands it is possible for example to read an SQL view and export it to CSV or XML file.

Source : Roberto Stefanetti Blog
Read more…