So a month ago in an non critical application I set up a trigger for a stored procedure to copy records (about 3000) from one table to another 6 times a day.
Approximately 38 days in and I have 100% reliability.
I have firewalled the required IP addresses listed by Microsoft
Azure Logic Apps list of IPs for Firewalls
I will keep running this for testing purposes to identify the reliability and report back