Share
ReportHi there,
Is it possible (Although I know not recommended) for external system to write data directly into BC tables (not though API)?
-Regards,
Ming
Categories:
You’re offline. This is a read only version of the page.
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
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:
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)
Hi Suvarna ,
Please indicate what solution you ended up using, that will help other forum users reading this thread.
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....
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.
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
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:
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,570
Super User 2024 Season 2
#2
Martin Dráb
228,683
Most Valuable Professional
#3
nmaenpaa
101,148
All responses (
Answers (