Share
ReportHi 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!
You’re offline. This is a read only version of the page.
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 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.
Hi, yes, although I personally don't recommend it, the final resort is to delete the data via the AL tool.
For example:
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.
Hope this also help.
Thanks.
ZHU
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
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
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.
All responses (
Answers (
