Parsing text from mailhook to variables or collection

Questions & Answers
1

I am having difficulty finding a module (or modules) to use for the following:

Use Case:
Action: FORWARDED email received by custom mailhook, which includes an array of Attachments.
Goal: PUT those attachments to an S3 bucket.

Workflow: Mailhook → Iterator → S3 module.

The set-up works as expected for iterating the attachments, as they are already present as an array.

I would like to add the following:
parse out one or more extra block(s) of added text from the mailhook’s TEXT mapping field - ie:

FromV: Fred Flinstone
SubjectV: FW Rubber Tires
DateV: <datestring>

(Why? because forwarded messages appear not to pass the original sender or received date.)

the text string is:

Begin forwarded message:

From: Fred Flinstone
Subject: FW Rubber Tires
Date:
To: somebody@somewhere
…

more message text more message text…

idea is to parse the text block into a collection or array item for follow-on use, or at least into multiple items:

Data: {
    FromV: "Fred Flinstone",
    SubjectV: "FW Rubber Tires",
    DateV: somedate
}

or

variable "FromVar" = "Fred Flinstone" (as a regex replace of FromV...)
variable "SubjectVar" = "FW Rubber Tires"
... and so on

in order to use them as additional headers in the S3 module - ie:

header name: x-amz-meta-from; value: Data.From;
etc...

I am currently parsing a value out of the mailhook Text item using Replace() in the Folder field of the s3 module, but that’s pretty hacky. So it seems is using text parser n times… can’t figure out proper regex capture for set multiple variables.

Ideally, I would like to build a simple array item to map into the S3 module:

Data [
    {"From" : "Fred Flinstone"},
    {"Subject" : "FW Rubber Tires"},
    {"Date" : "somedate"}
]

Hoping to find a combo of modules in-between to do the conversion. Any thoughts would be helpful. Thanks!

1 Like
2

Hi

Don’t know if you found the solution yet.
I’d do it this way:

{{
add(emptyarray;
          add(emptyarray;"FromV";replace(input;/^fromv:\s*(.*)\n/im;$1);
          add(emptyarray;"SubjectV";replace(input;/^Subject:\s*(.*)\n/im;$1);
          add(emptyarray;"DateV";replace(input;/^Date:\s*(.*)\n/im;$1))
}}

just wrote the regex while writing this answer so they’re not tested, surely contain mistakes, but that would be the general idea.

1 Like