Export data from BC via API

(7) Share

Report

Posted on by borics.krisztian

Hello,

I'm developing a production information system in C# .NET. Currently I'm using Dapper for import data from BC. This component is running my SQL query for the data import. Is there a way to extract the data more elegantly? For example via API?

Thank you for your answer.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Sohail Ahmed 11,169 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!

Yes, using the Business Central APIs is a more elegant and supported way to extract data compared to direct SQL queries.

You can use the standard OData or REST APIs provided by BC to get data like items, sales, inventory, etc. It's more secure, upgrade-safe, and works well with C# and Dapper.

Also, you can create custom API pages if standard endpoints don’t fit your needs.

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,801 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi @borics.krisztian,

Yes, accessing data from MS D365 BC via APIs is a much more elegant, future-proof, and Microsoft recommended approach compared to direct access data.

Was this reply helpful? Yes No
borics.krisztian 79 on at

Like (4)

Report
Copy link

Link copied!

Thank you! I will check.

Was this reply helpful? Yes No
Suggested answer

Andrés Arias 5,166 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hello,

Yes, you can use the standard APIs provided by Business Central or be able to cutom API if needed.

https://learn.microsoft.com/es-es/dynamics365/business-central/dev-itpro/api-reference/v2.0/

I hope I can help.

Regards,

Andres

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

Like (4)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

API – Kauffmann @ Dynamics 365 Business Central

API – Stefano Demiliani

Standard API for Dynamics 365 Business Central SaaS (Get, Post, Patch, Delete and Basic query parameters – filter, orderby, select…) | Dynamics 365 Lab

Best Regards
Gerardo

Was this reply helpful? Yes No
Verified answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi, hope the following helps as well.

Dynamics 365 Business Central Blog Series: REST API web services (APIs)

https://yzhums.com/63801/

Thanks.

ZHU

Was this reply helpful? Yes No
borics.krisztian 79 on at

Like (3)

Report
Copy link

Link copied!

Hello Yun San,

Thank you, I haven't looked into it completely, but it seems like it's good for the cloud version.

Can I use on On prem system?

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,959 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Saurabh has posted couple of nice videos on API processing. I will suggest you to have a look along with the Microsoft link.

https://www.youtube.com/watch?v=0YzuTuGQhl8

Was this reply helpful? Yes No