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!


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

<script runat=server>
var FolderScript= DataExtension.Retrieve({Property:"Name",SimpleOperator:"equals",Value:deName});
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;

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

  • 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 '19 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
    Aug 23 '19 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 '19 at 14:23
  • Click on Publish in top right corner and take out the <> around DE name
    – zuzannamj
    Aug 23 '19 at 14:25
  • 2
    sorry, the problem was the brackets. Thanks a lot
    – Duicug
    Aug 23 '19 at 14:29

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.