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/56b...
▶️ SFMC Companion: • SFMC Companion Introduction
Useful Links
• 📄 SSJS Try Catch: https://www.cameronrobert.com.au/sfmc...
• 📄 SSJS Loops: https://www.cameronrobert.com.au/sfmc...
Salesforce Documentation:
• WSProxy Retrieve: https://developer.salesforce.com/docs...
• DataExtensionField Object: https://developer.salesforce.com/docs...
• DataFolder Object: https://developer.salesforce.com/docs...
• SSJ GetQueryStringParameters: https://developer.salesforce.com/docs...
Contact:
/ camrobert
https://www.cameronrobert.com.au/
/ auscamrobert
Music: https://www.bensound.com