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,547 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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 98,235 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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 2,055 Super User 2026 Season 1

#2

YUN ZHU 1,063 Super User 2026 Season 1

#3

Dhiren Nagar 1,014 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans