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.

--

--

--

I am a certified Salesforce Marketing Cloud Consultant at Bower House Digital in Melbourne, Australia.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Firebase Summit 2018

The Golden Rule of Cloud Architecture

Fire Everything!

Agile Development Methodology - Case Study: Zomato

“Hybrid Apps are slow”

Container Vs Virtual Machines

CS373 Spring 2022: Vijay Kiran Vuyyuru

Using Technical Indicators In Python

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Charlie Fay

Charlie Fay

I am a certified Salesforce Marketing Cloud Consultant at Bower House Digital in Melbourne, Australia.

More from Medium

Convert XML to JSON using XSL in Salesforce Marketing Cloud

CSV to Salesforce Multipicklist upsert

Top Salesforce Spring ’22 Features in Nonprofit and Education Cloud

How to add dynamic css inline class add/remove, toggle and zoom-up/zoom-out style based on button…