You’re offline. This is a read only version of the page.
64
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,
VK
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.
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.
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.
Hi VK,
Yes, it can be done!!!
Import data entity by keeping the BLANK for those fields which are required to delete.
#1
Martin Dráb
487
Most Valuable Professional
#2
Abhilash Warrier
310
#3
Saalim Ansari
286
Share
Report
All responses (
Answers (
