Queries re new email capability

1

Hi,

Was just reading the blog and saw that the new features allow:

  • Sending an automated reminder if someone didn’t send an expected data file in time.
  • Automatically verifying incoming data in email attachments and then sending back a request to resubmit the data if a data quality checks fails.

Exactly how would one go about achieving this?

Regards,

Shaheed

2

Hi Shaheed,

Create a project that retrieves emails using the "Fetch email" action. Then filter the table with retrieved emails by sender, attachment file name, and timestamp. Then create a derived table with condition which sends a reminder when the source table (the result of filtering) is empty.

Finally, schedule the project for execution right after the expected time.

Create a project that retrieves emails with attachments using the "Fetch email" action. Filter the list of emails to keep only the necessary attachment and load it into EasyMorph using a relevant file import action. Perform necessary data quality checks. The result of the checks should be an empty table if all quality checks are passed. Finally, create a derived table with condition which sends a message when the source table (the result of checks) is not empty.

1 Like