topic Re: Get Business Central data thru API incrementally when Business Central source has deleted record in Pipelines

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

Anonymous — Wed, 19 Jun 2024 05:47:53 GMT

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.

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

Anonymous — Thu, 20 Jun 2024 05:18:43 GMT

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.

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

Anonymous — Fri, 21 Jun 2024 10:08:56 GMT

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.

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

Anonymous — Mon, 24 Jun 2024 07:36:14 GMT

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

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

ShahrukhHB — Mon, 03 Mar 2025 01:57:29 GMT

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

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

Anonymous — Mon, 03 Mar 2025 02:09:10 GMT

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:414088710@qq.com

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

ShahrukhHB — Wed, 05 Mar 2025 01:48:43 GMT

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

shahrukh@hbbrands.com

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