News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Automation API configu...

Small and medium business | Business Central, N...

Suggested answer

Automation API configurationPackage with Excel

(1) Share

Report

Report

Posted on by Community member

2

Hello,

with https://learn.microsoft.com/de-de/dynamics365/business-central/dev-itpro/administration/resources/dynamics_configurationpackage we can create configurationPackage.

Is there a way to import a .xlsx file with data over the rest-api ?

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central

Dynamics 365 Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (0)

Report

Automation API configurationPackage with Excel

Hi, unfortunately, the standard automate apis can't do that. This can only get the Configuration Package Header data.

For example,

Source code: https://github.com/microsoft/ALAppExtensions/blob/main/Apps/W1/APIV1/app/src/pages/APIV1AutConfigPackages.Page.al

If you need to import Execl directly, you need to create a custom API, and I don't think it is that simple.

Hope this can give you some hints.

Thanks.

ZHU
gdrenteria 12,338 Most Valuable Professional on at

Like (0)

Report

Automation API configurationPackage with Excel

Hi

I do not identify a direct way to import via API via Excel to BC.

Here I leave you a couple of options to import data via Excel to BC in addition to configurationPackage

https://learn.microsoft.com/en-us/dynamics365/business-central/across-work-with-excel#edit-in-excel

https://yzhums.com/4223/

Best regards

Gerardo

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans