Anyway to mass delete Custom Metadata Type records?

Question

I currently have 100+ records I need to delete under my custom metadata type, and I am not keen on having to do it one by one (I will need to reset the records every now and then as our requirements keep updating). I tried to do this via Apex but according to the documentation:

Apex code can create, read, and update (but not delete) custom metadata records...

Answer 1

As Custom Metadata Records are metadata you can use Force.com Migration Tool and deploy the destructive changes

content of destructiveChanges.xml

<?xml version="1.0" encoding="UTF-8"?>
<Package xmlns="http://soap.sforce.com/2006/04/metadata">
    <types>
        <members>CustomMetadataType.CustomMetadataTypeRecord</members>
        <name>CustomMetadata</name>
    </types>
</Package>

Answer 2

If you can run Apex, here's how you assemble the list for the destructiveChanges.xml very quick. Note: replace { and } by corresponding angle brackets. Copy paste the debug statements into your destructiveChanges.xml file.

List{String} objectTypes = new List{String}{
        SomeCustomMetadataType__mdt.getSObjectType().getDescribe().getName(),
        AnotherCustomMetadataType__mdt.getSObjectType().getDescribe().getName()
};





System.debug('\t{types}');
for (String objectType : objectTypes) {
    List{SObject} customMetadataRecords = Database.query('SELECT DeveloperName FROM ' + objectType);
    
    for (SObject customMetadataRecord : customMetadataRecords) {
        String recordName = (String)customMetadataRecord.get('DeveloperName');
        System.debug('\t\t{members}' + objectType + '.' + recordName + '{/members}');
    }
}
System.debug('\t\t{name}CustomMetadata{/name}');
System.debug('\t{/types}');