Skip to main content

Notifications

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

Direct write data into Business Central tables use ado

(0) ShareShare
ReportReport
Posted on by 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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    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 Profile Picture
    Suvarna 205 on at
    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 Profile Picture
    Suvarna 205 on at
    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.

    pastedimage1659075905819v1.png

    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)

    pastedimage1659076051924v2.png

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    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 Profile Picture
    Suvarna 205 on at
    RE: Direct write data into Business Central tables use ado

    Solved This issue ........... Thanks everyone

  • Suvarna Profile Picture
    Suvarna 205 on at
    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 Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    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 Profile Picture
    Suvarna 205 on at
    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 Profile Picture
    Lubenheimer 93 on at
    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 Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans