EML_PARSE

Takes text containing EML (RFC822) content and parses out information such as to, from, subject, attachments, etc.

Syntax 

EML_PARSE(text)

Usage examples 

Example 1

Input

1
{
2
"my_action": {
3
"message": "Delivered-To: john@example.com\nDate: Fri, 20 Jan 2023 00:00:37 +0000\nFrom: John Smith john@example.com\nReply-To:john@example.com\nTo: john@example.com\nMessage-ID: <message_id>\nSubject: Example email\nMime-Version: 1.0\nContent-Type: multipart/alternative;\n boundary=\"--==_mimepart_63c9d9a544871_73eb214182db\";\n charset=UTF-8\nContent-Transfer-Encoding: 7bit\n\n\n----==_mimepart_63c9d9a544871_73eb214182db\nContent-Type: text/plain;\n charset=UTF-8\nContent-Transfer-Encoding: 7bit\n\nA real email body could go here\n----==_mimepart_63c9d9a544871_73eb214182db\nContent-Type: text/html;\n charset=UTF-8\nContent-Transfer-Encoding: 7bit\n\n<!DOCTYPE html>\n<html>\n <head>\n <meta content=\"text/html; charset=UTF-8\" http-equiv=\"Content-Type\" />\n </head>\n <body>\n A real email body could go here\n </body>\n</html>\n\n----==_mimepart_63c9d9a544871_73eb214182db--"
4
}
5
}

Formula

EML_PARSE(my_action.message)

Output

1
{
2
"message_id": "message_id",
3
"subject": "Example email",
4
"from": "John Smith john@example.com",
5
"to": [
6
"john@example.com"
7
],
8
"cc": [],
9
"date": "2023-01-20T00:00:37+00:00",
10
"headers": {
11
"Date": "Fri, 20 Jan 2023 00:00:37 +0000",
12
"From": "John Smith john@example.com",
13
"Reply-To": "john@example.com",
14
"To": "john@example.com",
15
"Message-ID": "<message_id>",
16
"Subject": "Example email",
17
"Mime-Version": "1.0",
18
"Content-Type": "multipart/alternative; boundary=\"--==_mimepart_63c9d9a544871_73eb214182db\"; charset=UTF-8",
19
"Content-Transfer-Encoding": "7bit",
20
"Delivered-To": "john@example.com"
21
},
22
"body": "<!DOCTYPE html>\n<html>\n <head>\n <meta content=\"text/html; charset=UTF-8\" http-equiv=\"Content-Type\" />\n </head>\n <body>\n A real email body could go here\n </body>\n</html>\n",
23
"attachments": []
24
}

Sample Actions 

Event Transform
My Action
Event Transform
EML_PARSE

Select an Action to inspect.

You can also click "Copy Actions" and paste them in your Tines Story to see how they work.

Was this helpful?