How to retrieve data + attachment from email and insert into Database

JHofman1600097184 — Sat, 16 Nov 2024 01:28:13 GMT

Hi!

For a project, I am trying to retrieve attachments and metadata from emails and insert them into a database.

For each email that i retrieve, a row in the database should be added with the following columns

: SendFrom, SendTo, Subject, Attachment.

I managed to retrieve the attachment and some metadata using:

All the attachments and emails now get saved in a folder on my root directory, but i would like this data to be inserted into a database as described above...

Can anybody put me in the right direction?

Re: How to retrieve data + attachment from email and insert into Database

Anonymous — Tue, 15 Sep 2020 10:08:51 GMT

Hello,

You can extract some key standard fields, such as, Subject, Date, From, Attachment, Received and then load the values into your DB.

The work flow looks like: tfileinputmail-->tDBOutput

Here is a related scenario: TalendHelpCenter: Extracting key fields from an email

Let us know if it works.

Best regards

Sabrina

topic How to retrieve data + attachment from email and insert into Database in Talend Data Catalog

How to retrieve data + attachment from email and insert into Database

Re: How to retrieve data + attachment from email and insert into Database