How to auto schedule to export data & import data from configuration package

(0) Share

Report

Posted on by Manish Ratan

405

Hello Everyone,

How to auto schedule to export data & import data from configuration package in Business Central SaaS Version. Please advice if how can we do it through Power Automate. Or please advise me with best other solutions.

Thanks.

All responses (5)

Answers (0)

Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to auto schedule to export data & import data from configuration package

One way could be to create a report with an excel layout that you use to export the data to excel format.

Then you can run that report in a job schedule and have your report output stored to a Azure blob storage,
Manish Ratan 405 on at

Like (0)

Report

RE: How to auto schedule to export data & import data from configuration package

Thanks for the reply
Manish Ratan 405 on at

Like (0)

Report

RE: How to auto schedule to export data & import data from configuration package

Thanks for the reply.
Suggested answer

YUN ZHU 73,339 Super User 2024 Season 2 on at

Like (1)

Report

RE: How to auto schedule to export data & import data from configuration package

As far as I know, the configuration package does not have standard APIs, and it cannot be directly associated with Power Automate.
But as Nitin mentioned, there are many solutions, but all of them require BC to have APIs or Web Service.

Below is a very simple example of integration with OneDrive, I hope it can give you some hints.

https://yzhums.com/33436/

Thanks.

ZHU
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to auto schedule to export data & import data from configuration package

Hi,

You can create the Power Automate to import Data from SharePoint, Azure or OndDrive, Read those data and insert directly to Business central.

Below is the video which let your how to access azure blob storage in powerAutomate.

www.youtube.com/watch