I am attempting to develop a solution to provide the following functionality:
- When an email file (.msg) is uploaded to a SharePoint Online folder configured for emails, the email metadata (to, from, subject, etc.) is automatically extracted and saved into corresponding columns.
There are third-party products for this, but if possible my client wants to avoid the ongoing costs and implement their own solution.
The theory is if the script included an email parser* to extract metadata from the email header, then this could be saved into columns via a CRUD operation provided by SPFx. This would be fired via an eventlistener or Workflow attached to the folder that the emails are uploaded to.
Before I go too far down the SPFx road, could someone please confirm if this is a realistic approach?
(*such as this one: https://github.com/ykarpovich/msg.reader)