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

[JHofman1600097184]

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?

[Anonymous]

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