Delete records through data entity

(0) Share

Report

Posted on by vicky1234

hi,

Recently I came across a requirement where the client has asked to create an entity to create ,update as well as delete a record via the entity.
So my question is that is it even possible to delete a record via the entity. I mean does the std entities allow records to delete with the same entity.
I know that there is something related to truncate data however I am not sure if we need to mark some records to delete and others to create.

Thanks,

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Verified answer

nmaenpaa 101,172 Moderator on at

Like (1)

Report
Copy link

Link copied!

If the data entity is not Read only, deleting via data entity is possible when you use OData integration (for example Excel add-in).

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi VK,

Yes, it can be done!!!

Import data entity by keeping the BLANK for those fields which are required to delete.

Was this reply helpful? Yes No
vicky1234 68 on at

Like (0)

Report
Copy link

Link copied!

Thanks Murthy for the quick reply

what do you mean by keeping the blank fields....are you talking about the excel addin ->delete and publish.

I mean to ask if its possible via DMF , you create a project with the given entity and delete the records.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,633 Moderator on at

Like (1)

Report
Copy link

Link copied!

It depends on the records you want to delete. You can never delete posted transactions. Master data, config data, yes, as long as the data hasn't been used on a transaction. The way to use DMF to delete is to select 'Truncate entity data' in your import project. However, this action will delete ALL data in the tables related to the entity, so use with caution. More might be possible with a custom entity, that I'm not sure about.

Was this reply helpful? Yes No
vicky1234 68 on at

Like (0)

Report
Copy link

Link copied!

Thanks Frank,

I need to check how deleting multiple records can be achieved as well as creating with the same entity.

Offcourse both will be separate projects but again even I am not sure on this

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 305,196 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Vicky,

As mentioned above, using OData (e.g. Excel) can do a delete action. If you need to delete multiple records, you can delete multiple from Excel or e.g. provide a list and use Power Automate to delete the records. Technically, the records will be deleted one by one as the delete action using OData is per record.

Was this reply helpful? Yes No