| Runs | Each morning; results collected later |
|---|---|
| Sends | The customer screening batch from SharePoint, unzipped, PGP-encrypted, uploaded by SFTP |
| Collects | The results by SFTP, decrypted and flattened from XML into a readable CSV |
| Files | In SharePoint, through Microsoft Graph, with an email to the analysts |
| Checks | An alert when an upload fails |
| Tools | n8n, a small encryption service (OpenPGP.js), SFTP, SharePoint, Microsoft Graph, Outlook |
| Our part | The encryption and decryption service and the morning send. A member of the lender's team built the results workflow on top of it. |
| Status | Live in production |
What does it do?
- Each morning, pulls the screening batch from SharePoint and unzips it.
- PGP-encrypts each file in a small encryption service and uploads it to the screening service by SFTP, with an alert if an upload fails.
- Later, collects the results by SFTP and decrypts them.
- Flattens the XML into a readable CSV, files it in SharePoint and emails the analysts.
What doesn't it do?
- Screen anyone. The screening service screens; the lender's analysts review the results.
- Make a compliance decision.
- Decide who goes in the batch.
- Use AI.
Does this help with FINTRAC sanctions screening?
It handles the files. It moves the screening batch, encrypts it, decrypts the results and turns them into a CSV. Your screening service and your analysts do the screening and make the decisions. We don't claim it makes you compliant with FINTRAC requirements.
On your build, personal information is mapped first. Screening results will hold personal information about the people screened. Before we build, we'll write down every place a readable file will exist, even briefly, including while it is processed, so it can go in your privacy records. We'll also set run history to be kept only as long as you need it.
What would this look like at your lender?
If your sanctions screening service, or any other partner, wants PGP-encrypted files by SFTP, this is the build. In the free prototype we'd encrypt a sample file with a test key, send it to a test SFTP folder, then decrypt and flatten a sample result into a CSV, so you can see every column before anything touches real data.
- Price: PGP and SFTP are custom work, fixed in writing after the prototype, from $995.
- Watching it for you: $99 a month for monitoring, fixes and small changes, month to month.