Announcements
Hi mates! :)
I want to delete all records from Integration Record (5151). This is an obsolete table.
How can I do it?
Thanks you so much!
Hi
1) See below article. it is related to on-prem but maybe give you some idea.
2) Maybe (I did not test this / test in Sandbox). Download the table in configuration package then delete all lines and leave only one line. Then select "Delete Table Records Before Processing" and then upload it back.
archerpoint.com/.../
By the way, did you find a method to disable this function? Looks like the following article is out dated.
docs.microsoft.com/.../disable-integration-records-integration-management
Hi, I think Microsoft will automatically clear the data after a certain period of time.
If you want to delete data right now, hope the following will help.
4 WAYS TO DELETE RECORDS FROM A TABLE
https://navinsights.net/2020/10/27/4-ways-to-delete-records-from-a-table/
Thanks.
ZHU
I tried all this options but didn't work :(
Any other ideas? Like programming on AL?
Thanks!
Hi, yes, although I personally don't recommend it, the final resort is to delete the data via the AL tool.
For example:
GitHub - wbrakowski/Record-Deletion-Tool: This tool can be used to remove transactional data from a company in Business Central.
Also you can try to use Data Administration page to clean data, but as far as I know, there is no Integration Record in it.
https://yzhums.com/15246/
Hope this also help.
Thanks Mr. Zhu!
Record Deletion Tool doesn't work on BC19 and Data Administratio, like you say, is not there.
I wouldn't try to delete until I was sure that the system wasn't creating new Integration Records anymore. If you've done that, then writing an AL codeunit which deletes all the records in this table (just a few lines of code), and then running that codeunit, is not difficult. Definitely test in a Sandbox first though.
Yup! I'm sure.
Any code example for deleting the records?
First time deleting records on AL.
Thanks! :)
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 551 Super User 2026 Season 2
YUN ZHU 372 Super User 2026 Season 2
Grigorios Mavrogeorgis 339 Super User 2026 Season 2
