Office 365 Exchange Script to Delete Emails Based on File (2)

Solution: We work with a ticketing system in which we receive emails each time a ticket is updated. Thus, all the previous ticket emails we receive are irrelevant as the latest email contains all the information we need. We need a means to be able to delete all the old versions of a specific email with a defined subject that matches a criteria we feed it and delete or move the email to a specified folder. Specs: I am looking to have a script created that looks at a JSON file for rules to be ran against an Office 365 Exchange mailbox based on subject text in the Inbox. For instance, a rule may contain the following: - delete messages with subject starting with "hello" that were received on or before "2023-07-11 12:44:44" - delete messages with subject containing "r-235321" that were received on or before "2023-07-11 12:44:44" The file that the program looks at will change often and the script will run likely every 5-10 minutes against an account. This will require the ability to store credentials somehow and will run headless. - Script will utilize PowerShell to connect to Microsoft Exchange - PowerShell script will enable ability for account to use MFA - Developer will provide instructions on how the certificate or access keys will be generated - Script will run headless and setup as a scheduled task - In event script cannot run due to expired key or any issues, an email will be sent using SMTP with provided username and password at top of hour (ie. 2:00, 3:00, etc.) - Script will look at JSON file to read rules that need applied to inbox only - Emails will only scan inbox and no other folder - Emails that match the proper criteria will either be deleted or moved to a specified folder if it matches the “action” record - If email matches criteria and action = “moveToFolder” and “folder” item doesn’t exists, no action will be performed on email but alert will be sent at top of hour (ie. 2:00, 3:00, etc.) - JSON file may contain hundreds of rules that will need to execute against an inbox Sample JSON file: { "rule1": { "type": "startsWith", "value": "hello", "fromEmail": "testing @ [login to view URL]", "receivedBefore": "2023-07-11 12:44:44" }, { "type": "contains", "value": "r-235523", "toEmail": "john @ [login to view URL]", "receivedBefore": "2023-07-25 18:33:22" }, { "type": "endsWith", "value": "You", "receivedBefore": "2023-07-25 18:33:22", "fromEmail": "testing @ [login to view URL]", "toEmail": "john @ [login to view URL]", "action":"delete" }, { "type": "contains", "value": "urgent alert overdue", "receivedBefore": "2023-05-12 18:33:22", "fromEmail": "testing @ testing . com ", "toEmail": "john @ [login to view URL]", "action":"moveToFolder", "folder":"Inbox/IT Alerts/Urgent" } }