Hopefully a nice easy one (hopefully)
We have an external API feeding a console application (ASP.MVC) that runs every 5 minutes on Windows Scheduler on our main host server.
The API is connected to our 'Contact Us' page on our website, so basically just fields like name, phone number, general enquiry etc.
We now feed the system and create a new record for every enquiry sent. This has been working perfectly.
The marketing team have asked me to setup a notification email for every new record that gets created by the API Feed.
Could I please get some examples or help on how to look for any new records to then send the email?
I have no issue setting up the email script section, just the how to identify newly created records to then ping out the notification. Please note they also want a notification per enquiry, so it could send up to 10 separate emails with a quick overview of the enquiry.