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

Delete Integration Record

(0) Share

Report

Posted on by JMartin

160

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!

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

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/.../

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,649 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
JMartin 160 on at

Like (0)

Report

I tried all this options but didn't work :(

Any other ideas? Like programming on AL?

Thanks!

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,649 Super User 2025 Season 2 on at

Like (0)

Report

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.

ZHU

Was this reply helpful? Yes No
JMartin 160 on at

Like (0)

Report

Thanks Mr. Zhu!

Record Deletion Tool doesn't work on BC19 and Data Administratio, like you say, is not there.

Was this reply helpful? Yes No
Suggested answer

Greg Enns 1,106 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
JMartin 160 on at

Like (0)

Report

Yup! I'm sure.

Any code example for deleting the records?

First time deleting records on AL.

Thanks! :)

Was this reply helpful? Yes No