Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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