I require a coder to write some code that utilises Azure Queues and Functions, as well as SQL Database and SendGrid.
Function 1 named UpdateReminderQueue
This, which will be a scheduled function (runs every day at 1am). This will query a database for email addresses, where the ReceiveEmails = 1, Unsubscribed = 0, MessageSent = 0 and the SubsExpiry date is within 14 days of the day the script runs. It will store the email address, name, item1, item2, item3 plus a subscription id & customer ID, subsexpiry date in an Azure queue.
Function 2 named sendmail
This, when called via a http request, will go through the queue and will send the email, using SendGrid. The template for the mail will be stored as a file within the function. There will be multiple templates. The template choosen will depend on the SubscriptionID. The code will state at the beginning of the file, easily editable, to which ID (integer) refers to which file.
As an email address is sent it will update another Azure Queue (emailsent) of the UserID, Email Address, and ErrorStatus and Date/Time sent.
The message is then removed from the queue once it's processed.
Function 3 (emailsent). This is triggered by a message in the queue.
This goes through the emailsent queue and will then update the MessageSent to =1 in the database. It will then log the status of everything to a text file and then the message is removed from the queue.
5 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hi! I can write the requested 3 Azure functions for you. have worked with Azure functions in the past and this is quite a straightforward task. Regards, Andrew