Direct write data into Business Central tables use ado

(0) Share

Report

Posted on by Ming Chen

190

Hi there,

Is it possible (Although I know not recommended) for external system to write data directly into BC tables (not though API)?

-Regards,

Ming

All responses (16)

Answers (0)

Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: Direct write data into Business Central tables use ado

Hi Suvarna

You need to use the apply to each function in Power Automate after you have fetched the records from the SQL table.

I hope this reference can help you further:

docs.microsoft.com/.../apply-to-each
Suvarna 205 on at

Like (0)

Report

RE: Direct write data into Business Central tables use ado

Hi Inge,

I have created power automate flow to create sales order. This is working. Now I am working on Sales Lines. I am able to do for single line item. But what about multiple line items? Please help
Suvarna 205 on at

Like (0)

Report

RE: Direct write data into Business Central tables use ado

Hi Inge,

I am using power automate flow to insert data in sales orders. For normal it's working. If I use SQL query with filter condition then it's giving error.

I can use condition also in flow. But I want to add 19 values in condition and not able to add Add row after 10(may be)
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: Direct write data into Business Central tables use ado

Hi Suvarna ,

Please indicate what solution you ended up using, that will help other forum users reading this thread.
Suvarna 205 on at

Like (0)

Report

RE: Direct write data into Business Central tables use ado

Solved This issue ........... Thanks everyone
Suvarna 205 on at

Like (0)

Report

RE: Direct write data into Business Central tables use ado

Hi,

Thanks for reply. Since I am very new in Business Central programming part, need help. Can Someone really guide me to write API to insert Sales Order in Business Central. Input will be from SQL data multiple tables. How to do it?

OR

Write API to insert Sales Order in Business Central from website data. I know only website address / url address. I know sql data behind this website. There are multiple tables need to collect data and insert into sales order.

I tried with Power Platform flow. I can user query or table. But stucked in sales order no, document type, status like columns.

Please help....
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: Direct write data into Business Central tables use ado

[quote user="Suvarna"]
Hi Marco,

Other application is website app where booking are done by another users. I want to import that bookings as a sales order in business central.
[/quote]
Then the best practice will be to use a Business Central API to create and process the data in Business Central.

Or if the web app have an API you can pull date from the Web app from AL code and have it created and processed in Business Central.
Suvarna 205 on at

Like (0)

Report

RE: Direct write data into Business Central tables use ado

Hi Marco,

Other application is website app where booking are done by another users. I want to import that bookings as a sales order in business central.
Lubenheimer 93 on at

Like (0)

Report

RE: Direct write data into Business Central tables use ado

Hi,

which other app is it? Maybe there is a 3rd party extension for this, or out of the box (shopify).

Otherwise like all the others said, there are api that are capable of doing this.

But once again: Never ever write directly into the database! You wont have fun with this!

Regards,

Marco
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: Direct write data into Business Central tables use ado

Just to add to the other answers you got here about importing sales orders into Business Central.

There is a standard API for this that you should use or customize if it does not fully cover your needs.

Here is a link to the doc for the standard api:

docs.microsoft.com/.../dynamics_salesorder