2

I need to find the path of a data extension that I use in a SQL Query.

I can find the name of it but because the data extension structure is very messy is hard to find it.

Is there a way in Salesforce Marketing Cloud to see that? Thanks!

3

Yes, there's a script for that. Replace <DATA EXTENSION NAME> with the name of your DE.

<script runat=server>
Platform.Load("core","1.1.5");
var deName="<DATA EXTENSION NAME>";
var FolderScript= DataExtension.Retrieve({Property:"Name",SimpleOperator:"equals",Value:deName});
({Property:"CustomerKey",SimpleOperator:"equals",Value:key}); 
var FolderID = FolderScript[0].CategoryID;
var results = Folder.Retrieve({Property:"ID",SimpleOperator:"equals",Value:FolderID});

var folderName = results [0].Name;
var parentFolder=results [0].ParentFolder.Name;
var countdown = function(id) {
    if (id> 0) {
        var results = Folder.Retrieve({Property:"ID",SimpleOperator:"equals",Value:id});
    Write(results [0].Name+">");
        return countdown(results[0].ParentFolder.ID);
    } else {
        return id;
    }
};
countdown(FolderID);
</script>

Mind that the path you get will be the other way around, right to left.

  • Sorry, I'm new to marketing cloud. Not sure where do I run the script, can you give me a hint please – Duicug Aug 23 at 14:09
  • WebStudio>CloudPages. Create a new collection, inside the collection create a new landing page. Add a plain HTML content block and paste it there. Hit publish, and the path will be displayed on-screen. No need to actually publish it. – zuzannamj Aug 23 at 14:10
  • CodeRage, I have updated my question with a screenshot. It doesn't seem to work. I have changed the data extension name with different data extension names but it doesn't show anything – Duicug Aug 23 at 14:23
  • Click on Publish in top right corner and take out the <> around DE name – zuzannamj Aug 23 at 14:25
  • 1
    sorry, the problem was the brackets. Thanks a lot – Duicug Aug 23 at 14:29
1

I would also suggest this chrome extension 'SFMC OBJECT FINDER'

Users find difficult to track down a Object location from the Salesforce Marketing Cloud platform.

This extension would help users to search for a Object from the platform and display the exact location.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.