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.