We have been using sql triggers on feature classes with after insert and update. We are thinking to move to webhook concept. I was thinking , to develop web hook payload url using aspnet core web api and pass submitted information through payload . SQL triggers are not consistent and have been encountering issues with it . Could you guys suggest is it a good move ?
Power Automate, Make (formerly Integromat), and FME would be my suggestions. If there is some reason you have to build a custom solution, I don't have many suggestions.
