Locate SFMC SendLog Data Extension

If you’re onboarding on to a new client or SFMC account or business unit, it can be a little tricky to locate the Send Log data extension.

Usually it can be found using the SOAP APIP or WSproxy with conditional filters such as the below:

{
   Property: "Name",    
   SimpleOperator: "equals",   
   Value: "SendLog"
}

or alternatively;

{
   Property: "Description",    
   SimpleOperator: "equals",   
   Value: "Send Log Data Extension Template"
}

However, this may not yield results if a user has renamed the resulting DE’s name and description. Then you’re in a tight spot. Never fear, here is a two step workaround to help you locate this Data Extension.

STEP 1

Retrieve the DataExtensionTemplate object to get the SendLog Data Extension Template information. When the results are returned, copy the CustomerKey value since we need this in step 2’s API.

STEP 2

Once we have the results from the previous script and have the Template’s CustomerKey saved, we proceed to retrieve the DataExtension object. Note that the filter uses Template.CustomerKey = {{CustomerKey}}

Now you have the DE information, you can use the Name value or the categoryID to subsequently locate the SendLog DE in your Salesforce Marketing Cloud account.