Webhook to MySQL: Event Capture Pipeline Template

Capture incoming JSON events from a webhook, pick the fields you need, and store each one as a row in a MySQL events table.

What It Builds

This template starts with a Webhook trigger that receives a JSON event over HTTP. A Connector node on the json connector pulls out just the fields you care about, and a Connector node on the mysql connector inserts a row into your events table. The result is a clean, append-only audit trail of every event your systems send to Spojit.

The Prompt

Paste this into Miraxa and it builds the workflow, connecting the tools for you:

Build a workflow with a Webhook trigger that receives a JSON event. Pick the event_type, source, and occurred_at fields out of the body with the json connector, then insert one row into my MySQL "events" table with those values plus the full raw payload.

Connectors Used

  • Webhook trigger - external systems POST a JSON event to the workflow URL, verified by a signing connection.
  • json - picks the exact fields you need from {{ input }} before storage.
  • mysql - inserts a row into your events table with insert-rows.

Customize It

Change the field names (event_type, source, occurred_at) to match your payload, swap the target table name, or add a Condition node before the insert to drop events you do not want to keep. You can also store the whole body in a JSON column to keep an unfiltered copy alongside the parsed fields.

Tips

  • Use Direct mode on the mysql node so each insert is deterministic and costs no AI credits.
  • Set a signing connection on the Webhook trigger so only trusted senders can write rows.
  • Add a unique index on an event-id column to make re-delivered events safe to ignore.

Related

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.