Find Fields in Data Extensions in Salesforce Marketing Cloud
Cameron Robert answers a community question - How can you find every Field with the name "EmailAddress" in every Data Extension - stepping through the problem and developing the solution using a CloudPage, SSJS and WSProxy.
0:00 - Introduction
0:25 - Setup a CloudPage for development
2:23 - Setup SSJS Code
2:52 - WSProxy DataExtensionField Object
9:00 - Extract Field data from WSProxy Response
15:44 - WSProxy DataExtension Object
19:02 - Construct Final Dataset
23:30 - Output Results to a Table
27:12 - Add Rows to a Data Extension
30:31 - Create Script Activity in Automation Studio
32:22 - GitHub Resource
32:57 - Summary
Solution Code
• 📄 GitHub DE Field Search: https://gist.github.com/camrobert/3f0...
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...
• SSJS Rows.Add: https://developer.salesforce.com/docs...
Contact:
/ camrobert
https://www.cameronrobert.com.au/
/ auscamrobert
Music: https://www.bensound.com