I would like to read an email, and save the csv attachment from the email.
i would like to import the data from the csv into SQL
or if this can't be done, simply save the attachment to a file server
I would like to read an email, and save the csv attachment from the email.
i would like to import the data from the csv into SQL
or if this can't be done, simply save the attachment to a file server
Are you talking about workflow steps that contain a Send Email step? If so, take a look at this how-to article on using the system Workflow Attachment SmartObject to save attachments. How To: Add and View Workflow Attachments
In summary, this article explains how to use a system SmartObject to store attachments from a workflow step that you can then reference in other systems.
hi
nah its not for an email step.
basically i am using the exchange mailbox service to monitor an inbox for email
i then get the email, and load its contents into SQL, subject, body, to, from, attachments yes/no
then i load the attachment information, and store that into SQL.
but i would like to be able to read the data out of the csv and write it directly into SQL
Hi
You will have to use a Custom Broker to Read that information from DB as a file and then import data inside the file (csv) into a DB.
You have Custom broker like this one:
https://community.k2.com/t5/K2-Cloud/Import-CSV-file-data-into-List-View/m-p/105590?nobounce#M67
Regards,
JJ
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.