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?
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.