Small and medium business | Business Central, N...

Integration from SAAS Business Central

(0) Share

Report

Posted on by Romryan

Dear All,

I need to pick the transactions from Business Central running as SAAS and integrated them to another system that's onprem.
If Business Central was onPrem I would have used Sql queries in my integration application, but I am not sure on what approach am going to use to pull transactions from SAAS.
How do you do it? Kindly assist.

RomRyan

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Nitin Verma 21,794 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

you can publish the Web services in SaaS and consume them into your OnPrem version.

Thanks.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,163 Moderator on at

Like (0)

Report
Copy link

Link copied!

It depends a little of what your need is. If you want small volumes of data you should look at the Business Central API's that is available.

learn.microsoft.com/.../

If they do not cover your need you can also create custom API.

If you want larger data volumes if can be an option to transfer data from BC to Azure datalakes.

github.com/.../bc2adls

I hope this helps you further.

Was this reply helpful? Yes No
Romryan on at

Like (0)

Report
Copy link

Link copied!

I want each an every transaction that hits to general ledger entries. Which Websevice should I use?.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,163 Moderator on at

Like (0)

Report
Copy link

Link copied!

You should use this one:

learn.microsoft.com/.../dynamics_generalledgerentry

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,417 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi

if your system can make REST calls you can expose Web Services from BC and read the information you need:

learn.microsoft.com/.../api-overview

manually instead you could export the information via configuration packages that create excel files for you:

https://yzhums.com/4286/

THE alternative solution is to install an onpremis data gateway on your network:

learn.microsoft.com/.../service-gateway-onprem-indepth

and with a logic app allow BC to save the files in your onprem folder

regards

DAniele

Was this reply helpful? Yes No
Suggested answer

Amit 2,563 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Adding Info-

https://erpconsultors.com/create-json-file-in-al-for-d365-bc/

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report
Copy link

Link copied!

Hi, you can using APIs or Webservice.

For example,

Web Service:

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/web-services

API page:

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-api-pagetype

And Standard API: https://yzhums.com/6117/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No