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:

Business Central

Business Central

Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 73,378 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,093 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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,064 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans