Stored Procedure Hook for Email Event Connector

Adds flexibility to the connector to handle complex rules for incoming email, e.g.:

1. White-list sender email address. E.g. the SPROC would check for specific white-listed email addresses, as well as email addresses of active Analysts & Customers. Any non-recognized email address would be blocked;

2. New Call vs. Update Call based on CI. The SPROC derives the CI name (from the HOST_NAME tag). A simple query then returns if there are any open Calls logged against that CI. If there is, the Open Call has a note added instead of a new Call being logged.

3. Complex field resolution: The connector field derivation doesn't quite handle some of our permutations.

  • Patricia Sellars-Jones
  • Oct 9 2019
  • Reviewed by Alemba Product Manager
  • Attach files