Bringing Weather Data into an Eloqua Campaign

Here is my solution to adding weather data to an Eloqua Campaign.

Business Requirement: Provide a local forecast for Customer Roadshows/Events and include that in the reminder email sent to registered contacts.

Overview: An external weather data API is used to pull the forecast information for a specific location(s) and a date range. The weather data is processed and either a "HTML Code Snippet" can be uploaded to Eloqua as "shared content" and or the data can populate a Custom Object. Whichever route is chosen the content can be dynamically merged into the reminder message based on the location of the Roadshow.