5

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!

2 Answers 2

8

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>

See my blog post for further enhancements to the above script: Find a Data Extension and it’s folder path using SSJS

8
  • Sorry, I'm new to marketing cloud. Not sure where do I run the script, can you give me a hint please
    – Duicug
    Commented Aug 23, 2019 at 14:09
  • 2
    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
    Commented Aug 23, 2019 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
    Commented Aug 23, 2019 at 14:23
  • Click on Publish in top right corner and take out the <> around DE name
    – zuzannamj
    Commented Aug 23, 2019 at 14:25
  • 2
    sorry, the problem was the brackets. Thanks a lot
    – Duicug
    Commented Aug 23, 2019 at 14:29
3

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .