Parse DMARC reports

• Email Administrators: Those responsible for monitoring DKIM and SPF reports to ensure email deliverability and security.
• Data Analysts: Professionals who need to analyze DMARC reports for trends and issues in email authentication.
• IT Security Teams: Teams focused on maintaining email security and compliance with DMARC policies.
• Developers: Individuals looking to integrate email reporting into their applications or systems for better visibility.

This workflow automates the parsing and processing of DMARC reports, which can be complex and time-consuming to handle manually. It addresses issues such as:

• Email Deliverability: Ensures that emails are being authenticated correctly to improve deliverability rates.
• Security Monitoring: Identifies potential security issues related to DKIM and SPF failures, allowing for timely responses.
• Data Management: Automatically stores parsed report data into a MySQL database for further analysis and reporting.

• Email Trigger: The workflow is initiated by receiving an email containing DMARC reports.
• Unzip File: Any attached zip files are extracted for further processing.
• Extract XML Data: The workflow extracts XML data from the unzipped files.
• Parse XML to JSON: The extracted XML data is converted into a JSON format for easier handling.
• Conditional Logic: The workflow checks if multiple records exist in the parsed data to handle them accordingly.
• Map Fields: Relevant fields are mapped for database input, including organization name, date ranges, and domain information.
• Format Dates: Dates are formatted to a MySQL-compatible format.
• Input into Database: The parsed and formatted data is inserted into a MySQL database for storage.
• Notification: If any issues with DKIM or SPF are detected, notifications are sent via Slack and email to alert the relevant stakeholders.