web

You’re offline. This is a read only version of the page.

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Gerardo Rentería Ga... 25,219 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,449 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 3,064

#2

Jainam M. Kothari 1,568 Super User 2025 Season 2

#3

YUN ZHU 1,063 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans