Find a Data Extension using SSJS and WSProxy in Salesforce Marketing Cloud

Cameron Robert shows how you can use Server-Side JavaScript and WSProxy on a CloudPage to display the location of a Data Extension. There are already Chrome Extensions that can help you locate missing Data Extensions - Including SFMC Companion - however this is a great exercise to see how SSJS and WSProxy can be used. 0:00 - Introduction 0:18 - Setup a CloudPage for development 1:55 - Setup SSJS Code 2:38 - WSProxy DataExtension & DataFolder Object 3:25 - WSProxy DataExtension Retrieve 6:43 - WSProxy DataFolder Retrieve using a DO WHILE Loop 12:40 - Testing the Data Extension Finder code 13:51 - Adding GetQueryStringParameters function 15:28 - GitHub Resource 15:53 - Summary Solution Code • ? GitHub SSJ DE Search: https://gist.github.com/camrobert/56bf749d5ccec348cfedfa2f0dc46e7d ▶️ SFMC Companion: https://www.youtube.com/watch?v=Z-HerDFcAbE Useful Links • ? SSJS Try Catch: https://www.cameronrobert.com.au/sfmc/using-the-try-statement-in-ssjs/ • ? SSJS Loops: https://www.cameronrobert.com.au/sfmc/server-side-javascript-loops/ Salesforce Documentation: • WSProxy Retrieve: https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/ssjs_WSProxy_basic_retrieve.html • DataExtensionField Object: https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/dataextensionfield.html • DataFolder Object: https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/datafolder.html • SSJ GetQueryStringParameters: https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/ssjs_utilitiesGetQueryStringParameters.html Contact: https://www.linkedin.com/in/camrobert/ https://www.cameronrobert.com.au/ https://twitter.com/AusCamRobert Music: https://www.bensound.com