Parse and process DMARC reports

Help me Build my Workflow
1

I am wanting to find a way to automatically process DMARC reports so that I can look at the reporting in PowerBI, seeing trends over a period of time.

There is a project called parseDMARC (https://github.com/domainaware/parsedmarc) which has the functionality for the most part, but also alot of extra functions that I don’t need i.e. Elastic/Splunk/Kabana

  1. Extract .zip and .gz archive files, ensure XML file is named as the archive
  2. Parse the XML file into JSON
  3. Generate aggregated and forensic JSON reports for each archive

I suspect that the parser and output configuration templates (aggregated and forensic) from the project could be used in some way in a flow.

Is anybody able to help me please?

Thanks

2

The way you can use the parsedmarc is install it as a python module, then you would call if from the execute command node, I guess.

Alternatively, you could create an api wrapper around the module and package it in docker container, then you would call it from an HTTP Request node.

3

use this template, thanks to the author Parse DMARC reports, save them in database and notify on DKIM or SPF error | n8n workflow template