Response Path when MySQL is the trigger

(Khashayar) #1

Hey!

So we want to broadcast a Custom Message when a new row is added on SQL. We have SQL as the trigger, then Bot - Custom Message. But the Response Path is empty. No one receives a message (in the logs it says flow is triggered).

Could I get some pointers? Thanks a lot

(John Jackson) #2

You can do this by making 2 flows:

  1. MySQL New Row trigger to a webhook action.
  2. Broadcast > Receive a Webhook to a Bot > Make a Custom Request.

The webhook action in flow 1 will need to be set up to fire the webhook trigger of the second flow, and pass the data from SQL across.

You’ll find that the Broadcast > Receive a Webhook has a response path output that will automatically be picked up when you add the custom request action.

Hope this gets you on the right path!