Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Get Business Central data thru API incrementally when Business Central source has deleted record

Hello 
I am using Microsoft Fabric (Dataflow gen2 and Notebook with pyspark) to connect to 365 Business central API successfully.  The idea is to extract data from source 365 Business central(accounts, customers, employee, etc. ) to target Fabric onelake. The initial Load process is implemented successfully in both two ways.  Now I want to implement incremental load. Here is the question/issue we noticed : 
  • If there are deleted records in source Business Central, how can we detect that thru API?
  • Or is there any soft delete flag in Business Central API/ tables, so we can refer that to manually delete the same records in our target Fabric onelake?
If we cannot find a way that auto-detect deleted records in the source Business Central data, INCREMENTAL load will never notice the deleted records. Then FULL refresh for all the tables have to be implemented, which does not make sense for us, especially for the tables have large volume data. 
 
Thanks a lot.
Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    Thanks for using Fabric Community.
    At this time, we are reaching out to the internal team to get some help on this .
    We will update you once we hear back from them.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous ,

      The best course of action is to open a support ticket and have our support team take a closer look at it: Link 

       

      After creating a Support ticket please provide the ticket number as it would help us to track for more information.

       

      Hope this helps. Please let us know if you have any other queries.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous ,

        We haven’t heard from you on the last response and was just checking back to see if you got a chance to open a support ticket.
        After creating a Support ticket please provide the ticket number as it would help us to track for more information.

        Thanks

  • ShahrukhHB's avatar
    ShahrukhHB
    Frequent Visitor
    1 year ago

    Hi

    If you don't mind may i know how you are doing this Connecting business central Pages thru API I want to use same approach.

     

    Thanks & Regards

    shahrukh

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      hello ,

      I am able to acquire data thru API but still dont know how to detect deleted records thru API.

      willing to provide any help. my email:[email protected]

      • ShahrukhHB's avatar
        ShahrukhHB
        Frequent Visitor
        1 year ago

        I am not able to send you mail on giving email id.

         

        [email protected]

         

        will you please help me to Provide details on Email how to connect Business Central API in Pyspark