Retrieve, update, and delete tables
Note
Unsure about entity vs. table? See Developers: Understand terminology in Microsoft Dataverse.
Learn how to retrieve, update, and delete a table definition. This topic uses the custom Bank Account table that was created in Create a custom table.
Retrieve and update a table
The following code sample retrieves a table definition by using the RetrieveEntityRequest message. It then updates the table to disable mail merge by setting the IsMailMergeEnabled property to false, and sets HasNotes to true in the UpdateEntityRequest to specify that the table should include a relationship to the Annotation table for the purpose of displaying notes.
RetrieveEntityRequest retrieveBankAccountEntityRequest = new RetrieveEntityRequest
{
EntityFilters = EntityFilters.Entity,
LogicalName = _customEntityName
};
RetrieveEntityResponse retrieveBankAccountEntityResponse = (RetrieveEntityResponse)_serviceProxy.Execute(retrieveBankAccountEntityRequest);
EntityMetadata BankAccountEntity = retrieveBankAccountEntityResponse.EntityMetadata;
// Disable Mail merge
BankAccountEntity.IsMailMergeEnabled = new BooleanManagedProperty(false);
// Enable Notes
UpdateEntityRequest updateBankAccountRequest = new UpdateEntityRequest
{
Entity = BankAccountEntity,
HasNotes = true
};
_serviceProxy.Execute(updateBankAccountRequest);
Delete a custom table
The following code sample uses the DeleteEntityRequest message to delete the table definition with the logical name specified by the _customEntityName variable.
DeleteEntityRequest request = new DeleteEntityRequest()
{
LogicalName = _customEntityName,
};
_serviceProxy.Execute(request);
See also
Use the IOrganizationService Sample and Helper Code
Customize table definitions
Create and update a table that can be emailed
Create a custom table