Answered

Deleting all rows from a dataverse table via API?

Like (0) Share

Report

Posted on 25 May 2023 14:45:05 by ebonnett

Hi all, I am using C# and the Dataverse API to dynamically create tables based on the columns in an Excel spreadsheet. I'd like to be able to clear out all data in the table NOT using the Bulk Delete in the Admin site. Is there a way to do this?

Categories:

Tables

Entities

Microsoft Dataverse

All responses (4)

Answers (1)

ebonnett 35 on 26 May 2023 at 15:30:43

Like (1)

Report

Re: Deleting all rows from a dataverse table via API?

Leksie, thanks for the tip. I did not know that was an option. I'll check it out and report back, maybe I'll post a code snippet once I get it working so others may benefit.
Verified answer

Richard_S 34 on 26 May 2023 at 15:12:55

Like (0)

Report

Re: Deleting all rows from a dataverse table via API?

Hi @ebonnett,

you could call the bulkDelete action via the WebAPI I guess.
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/reference/bulkdelete?view=dataverse-latest
As per my understanding this is basically nothing else than what the bulk delete in the admin site does. Also I would think you need to pass it a query string of the records to be deleted.
Never used myself, but maybe that's what your looking for.
ebonnett 35 on 25 May 2023 at 17:56:10

Like (0)

Report

Re: Deleting all rows from a dataverse table via API?

Trying to delete all so I don't want to address one row at a time. Basically DELETE FROM <tablename>.
Drew Poggemann 9,278 Most Valuable Professional on 25 May 2023 at 16:16:30

Like (0)

Report

Re: Deleting all rows from a dataverse table via API?

Hi @ebonnett ,

Looking to use something like this or are you trying to do a delete all? https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/update-delete-entities-using-web-api