Use DeleteMultiple (preview)

[This topic is pre-release documentation and is subject to change.]

Important

This is a preview feature.

Preview features aren’t meant for production use and may have restricted functionality. These features are available before an official release so that customers can get early access and provide feedback.

DeleteMultiple

Delete multiple rows of data in elastic tables with a single request.

SDK for .NET

You must use the OrganizationRequest class because the SDK for .NET doesn't have a DeleteMultipleRequest class. Learn how to use messages with the SDK for .NET.

The following DeleteMultipleExample static method uses the DeleteMultiple message with the OrganizationRequest class to delete multiple rows from the contoso_SensorData elastic table using the alternate key to include the partitionid to uniquely identify the rows.

public static void DeleteMultipleExample(IOrganizationService service)
{
    string tableLogicalName = "contoso_sensordata";

    List<EntityReference> entityReferences = new() {
        {
            new EntityReference(logicalName: tableLogicalName,
               keyAttributeCollection: new KeyAttributeCollection
               {
                  { "contoso_sensordataid", "3f56361a-b210-4a74-8708-3c664038fa41" },
                  { "partitionid", "deviceid-001" }
               })
        },
        { new EntityReference(logicalName: tableLogicalName,
               keyAttributeCollection: new KeyAttributeCollection
               {
                  { "contoso_sensordataid", "e682715b-1bba-415e-b2bc-de9327308423" },
                  { "partitionid", "deviceid-002" }
               })
        }
    };

    OrganizationRequest request = new(requestName:"DeleteMultiple")
    {
        Parameters = {
            {"Targets", new EntityReferenceCollection(entityReferences)}
        }
    };

    service.Execute(request);
}

Web API

The following example shows how to use the DeleteMultiple action to delete multiple rows from the contoso_SensorData elastic table including the partitionid to uniquely identify the rows.

Note

At the time of this writing, the Web API DeleteMultiple action is a private action. You won't find it in the CSDL $metadata document or in the Dataverse Web API Action Reference. This action will become public soon. You can use it while it's private.

Request:

POST [Organization Uri]/api/data/v9.2/contoso_sensordatas/Microsoft.Dynamics.CRM.DeleteMultiple
OData-MaxVersion: 4.0
OData-Version: 4.0
If-None-Match: null
Accept: application/json
Content-Type: application/json; charset=utf-8
Content-Length: 603

{
    "Targets": [
        {
            "@odata.type": "Microsoft.Dynamics.CRM.contoso_sensordata",
            "contoso_sensordataid": "6114ca58-0928-ee11-9965-6045bd5cd155",
            "partitionid": "Device-ABC-1234"
        },
        {
            "@odata.type": "Microsoft.Dynamics.CRM.contoso_sensordata",
            "contoso_sensordataid": "6214ca58-0928-ee11-9965-6045bd5cd155",
            "partitionid": "Device-ABC-1234"
        },
        {
            "@odata.type": "Microsoft.Dynamics.CRM.contoso_sensordata",
            "contoso_sensordataid": "6314ca58-0928-ee11-9965-6045bd5cd155",
            "partitionid": "Device-ABC-1234"
        }
    ]
}

Response:

HTTP/1.1 204 NoContent
OData-Version: 4.0

Availability

DeleteMultiple is supported only for elastic tables. Elastic tables don't support table relationship cascading behavior, which can result in unpredictable execution times for delete operations. If you use DeleteMultiple on a standard table, you get the error: DeleteMultiple has not yet been implemented.

Examples

You can find sample code on GitHub in github.com/microsoft/PowerApps-Samples:

• Elastic table sample code
• Within Sample: SDK for .NET Use bulk operations or Sample: Web API Use bulk operations, change the Settings.cs config file and choose the UseElastic option.

See also

Use bulk operation messages
Elastic tables
Elastic table sample code
Sample: SDK for .NET Use bulk operations
Sample: Web API Use bulk operations