Hello,
It should be possible with these configuration steps:
-Create a table in your DB for email storage
-in GeniusConnect map your Folder to the table and click OK
-on GeniusConnect Config->Datababase Tab, select the folder -> click More Actions - >Advanced - > Add/Edit Outlook Filter , and add your subject filter, example :
@SQL="urn:schemas:httpmail:subject" LIKE '%my subject%'
-If you like to delete the email after saving to DB :
on GeniusConnect Config->Datababase Tab, select the folder -> click More Actions - >Advanced - > Delete After Saved to DB:Delete from folder
After these steps complete emails with "my subject" in subject will be stored in your table and deleted from the Folder.
To extract data from email body you can create for example a View , like this (SQL Server syntax):
SELECT
SUBSTRING(MailBody, CHARINDEX('Client Code:', MailBody, 1) + 12, 3) as ClientCode,
SUBSTRING(MailBody, CHARINDEX('Reservation Number:', MailBody, 1) + 19, 20) as ReservationNumber
FROM myStagingMail
Please note this is only example code, it may be better to create for example a stored procedure and functions to extract the data into a new table, or do the extracting in insert trigger, more info :
https://support.geniusconnect.com/Posts/t59- More Info Outlook Filters:
https://support.geniusconnect.com/Posts/t192-