TLDR;
I want to propagate a object delete to an external DB, just like my creates and updates, using a webhook. How would I do that?
I use CC to post JA data to my MSSQL database.
Usually an Edit of a record, and sometimes an Add.
I have a table that nothing references… a child record if anything - safe to delete. If its deleted in JA (via DB.destroy), then it also needs to be deleted in MSSQL.
How do I trigger a CC task to delete in MSSQL?
(ie. There is no webhook for a Delete action)
@jaymer This is an excellent question. As for why we don’t trigger webhooks on delete events, I don’t know (will try to get an answer). As for what to do instead, you can create a different object every time you execute a delete in the app, and have that object trigger the webhook instead of the deleted one (at least in the case of the delete event, although you could also consider moving your Create and Update webhook triggers to a separate, dedicated object. Doing that would also allow you to log and track each individual webhook trigger and integration attempt for every change.
If you do go down this route, make sure that you periodically clear out this table as it could get fairly large fairly quickly (depending on the number of changes that your app is generating)