dspCompose

Add Custom Email Validations

A Template Administrator can register email validations that are run on emails received at the external data email account. These validations reduce time needed for support by handling basic email validation automatically.

A Template Administrator can add custom email validations, in the form of views or stored procedures, to validate inbound emails from External Data roles. In the case of a stored procedure, the validation takes in an EmailMessageID parameter. A view binds on an EmailMessageID.

The EmailMessageID value should correspond to a value in the table ttEmailMessage.EmailMessageID. When dspCompose™ runs the validation, if a view returns at least one record or a procedure returns 1 then the validation fails.

Validations are stored procedures or views that have been written and saved in a data source that is registered in the DSP™. A validation executes when an event occurs and confirms that a process is valid. If the validation fails, processing stops. For example, a validation is registered to a Receive Email event. The validation confirms that an email received at a designated address has an attachment in a specified format. If the attachment is in a valid format, the validation passes and processing can continue. However, if the attachment is in an invalid format, the validation fails and processing stops.

To add a custom email validation:

  1. Select Configuration > Email Validation from Navigation pane.

  2. Click Add.

    View the field descriptions for the Email Validation page.

  3. Enter a sort order in PRIORITY field.

    NOTE: The priority determines the order in which the validations are run.

  4. Select a data source ID from the DATA SOURCE ID list box.

    NOTE: The data source contains the view or stored procedure that is the email validation.

  5. Select the validation from the RULE list box.

    NOTE: The validation is a view or a stored procedure from the data source.

  6. Enter a brief description of the validation in DESCRIPTION field.
  7. Click the CONTINUE ON FAILURE check box to enable it if the process should continue after an email validation failure.
  8. Click the EMAIL ON FAILURE check box to enable it if dspCompose™ should send an email to the sender with information about the failure.
  9. Click Save.
  10. Click Message.

  11. Click Edit next to the message’s language.

    View the field descriptions for the Email Validation Message page

  12. Enter the text for the email validation failure error message in the MESSAGE field.
  13. Click Save.