I am working on an email listener, where the email body will be having the data which needs to be fetched and used for processing. Using the data from the email body, we need to build a SQL object to get data from the database accordingly.
I am able to get this working if i use the attachment concept of email, but no clue about how to read the body of an email message. Any idea/suggestion how can this be done.
Thanks.This message has been edited. Last edited by: FP Mod Chuck,
iWay Release: iWay 55(IAM), iWay5.5 (ISM), iWay 6 (ISM) DQC Database: DB2, SQL Server 2008, Oracle OS: Windows Server 2003, XP Format: FTP, SAP, EDI, FLAT
May 26, 2011, 04:45 AM
Isn't the email body the document on the bus when it enters your pflow?
iWay 5.5 SMSP1 and 6.0.1 on Intel/Linux
November 27, 2012, 06:52 PM
Have you succeeded in reading the body text?
Shirley Huang WF 7.7.04M MRE BID DevStudio WIN2003, SQL Server 2000/DB2 HTML/PDF/EXL2k/AHTML iSM 6.16
September 18, 2017, 01:52 PM
Can you give an idea how to read email attachment and use it as a data source to put it into a target table.?