Import a XML file from FTP into Salesforce Marketing Cloud
Cameron Robert demonstrates an alternative method to import XML files from a FTP folder into Salesforce Marketing Cloud.
The Data Extract Convert XML method can be useful for simple XML structures, however users looking to import more complex XML files will find this method is more accommodating.
0:00 - Introduction
0:36 - Importing a XML file from FTP
4:26 - Re-assemble the XML in AMPscript
7:33 - Use BuildRowSetFromXML to parse the XML file
8:51 - Read and Output values from the XML file
13:10 - Store XML values in a Data Extension
16:10 - Summary
▶️AMPscript BuildRowSetFromXML Function: • AMPscript BuildRowSetFromXML Function...
📄XML Examples: https://www.w3schools.com/xml/xml_exa...
Salesforce Documentation:
• Import File Activity: https://help.salesforce.com/s/article...
• BuildRowSetFromXML: https://developer.salesforce.com/docs...
Contact:
/ camrobert
https://www.cameronrobert.com.au/
/ auscamrobert
Music: https://www.bensound.com