Cameron Robert builds an Automated Weather Notification Service, using AMPscript and SSJS to transform XML data from an external FTP to create a alert for rain forecasts.
Cameron's use case is to let him know if there will be rain during his walk, however a similar automated service could be built to trigger communications or personalise content to customer based on their local weather.
0:00 - Introduction
1:04 - Weather Data & XML FTP Service
1:58 - Import an XML file from an External FTP
5:55 - Reassemble the imported XML using AMPscript
9:05 - Parse the XML file to read the attributes and values
24:33 - Save the XML values into a Data Extension
28:58 - SQL to select forecast rain
33:17 - Run AMPscript in SSJS
36:48 - Add a Verification activity to send a Weather Alert
38:12 - Summary
Australian BOM Links:
📄Brisbane Forecast: www.bom.gov.au/qld/forecasts/b...
📄Weather Data Services: www.bom.gov.au/catalogue/data-...
📄Weather Information FTP Services: reg.bom.gov.au/other/Ftp.shtml
Useful Links:
📄AMPScript in SSJS by Mateusz Dąbrowski: mateuszdabrowski.pl/docs/ssjs...
Related Videos:
▶️AMPscript BuildRowSetFromXML Function: • AMPscript BuildRowSetF...
▶️Import XML from FTP: • Import a XML file from...
Salesforce Documentation:
• Import File Activity: help.salesforce.com/s/article...
• BuildRowSetFromXML: developer.salesforce.com/docs...
Contact:
/ camrobert
www.cameronrobert.com.au/
/ auscamrobert
Music: www.bensound.com