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,136 Super User 2025 Season 2 on at

Like (5)

Report

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,390 Super User 2025 Season 2 on at

Like (3)

Report

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

Thank you! I will check.

Was this reply helpful? Yes No
Suggested answer

Andrés Arias 4,188 Super User 2025 Season 2 on at

Like (3)

Report

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

Like (4)

Report

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 95,329 Super User 2025 Season 2 on at

Like (3)

Report

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

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,600 Super User 2025 Season 2 on at

Like (2)

Report

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