Question

1
Replies
105
Views
MuraliKrishnaV2722 Member since 2019 2 posts
Infosys Ltd
Posted: October 23, 2019
Last activity: October 23, 2019

Email Listener- How to parse an excel attachment in the email

We have a requirement to parse the records present in an excel which comes as the attachment in an email.

For each record in the excel, we need to process the business logic as per the requirement.

Tried using MSOParseExcelFile activity but the got an error in the tracer that the uploaded file doesn't match the template(pzUnrecognizedFileTemplate). I believe its due to fact that only the ServiceExport path needs to be passed to the activity.

Is there a way to store the attachment in serviceexport directory path from email and get to know the location address.

Need assistance in knowing other methods on how the excel records can be parsed.

***Edited by Moderator: Lochan to update platform capability tags***

Low-Code App Development Case Management Data Integration
Share this page LinkedIn