Implement INSERT Event Trigger for escrow_transactions

[sotoJ24]

Description

Implement a Hasura event trigger that fires when new records are inserted into the escrow_transactions table to initiate communication with third-party APIs.

Requirements

• Create event trigger for INSERT operations on escrow_transactions table
• Configure trigger to fire only for specific transaction_types that require immediate API notification
• Define appropriate payload structure including relevant transaction fields
• Set up initial webhook endpoint configuration for new transaction events

Acceptance Criteria

• Event trigger successfully fires on new transaction creation
• Payload contains all necessary transaction data
• Trigger filters out transaction types that don't require immediate API notification
• Basic logging implemented to track trigger activation

Technical Implementation Details

• Create trigger through Hasura console or metadata configuration
• Configure payload to include all relevant fields from the transaction record
• Set up proper security headers for webhook calls

Make sure to follow the Git Guidelines for Atomic Commits and read Contributing Guide

The Pull request needs to have the format mentioned below in the Git Guideline

• Contributing Guide
• Git Guidelines

Hasura Event-Triggers Documentation

https://hasura.io/docs/2.0/event-triggers/overview/

[fatiudeen]

Hey, Could I take on this issue?

[GideonBature]

I will love to tackle this task! I am a Software Engineer with experience building backend systems, working with Hasura migrations and seeding. I will love to implement the Hasura event trigger for escrow_transactions table. I will set up the trigger to fire on INSERT operations, filter it for specific transaction_types needing immediate API calls, and define a payload with all the key transaction fields. I will also configure the initial webhook endpoint with proper security headers and add basic logging to track trigger activation all via the Hasura console or metadata, per the guidelines. I have checked out the Hasura Event Triggers docs and feel confident about solving this issue.

If you assign me this issue, I will submit my first PR within 72 - 96 hours. Thank you for considering my application!

[Jagadeeshftw]

Hi, I’d love to take on this issue! With my expertise in Cairo, StarkNet, and smart contract development, I can implement a clean and efficient solution.

🚀 Why Me?

• Proven Blockchain Experience – Hands-on work with StarkNet, Solidity, and Rust, building secure and optimized smart contracts.
• Open Source Contributor – Actively contributed to 30+ open-source projects, showcasing adaptability and collaboration.
• Efficient & Reliable – I deliver high-quality, production-ready solutions quickly, ensuring security and scalability.

⏱ Timeline

I estimate completing this within 1 day. Let me know if I can proceed!

🌐 My Profile

Check out my OnlyDust profile for more insights: Jagadeeshftw on OnlyDust

Looking forward to contributing. 🚀

[Iwueseiter]

Is it okay if I take this?
I'm a smart contract developer with a solid knowledge of rust, cairo and go lang.
I write efficient code and also end-to-end tests for smart contracts. Please let me handle
this as I will implement this task as expected and efficiently.

[Kingsuite]

Can I attempt this issue? It will be awesome to contribute to this project

[Oseec]

Hello there, I'm Isaac, Computer engineer student and currently learning about web3 as a member of Dojo Coding community ⛩️ and I would love to contribute to this project, it might be one of my first contributions in the ODBuild 🚀

I've never done a work like this one before, but I do know SQL triggers and uses it a little bit in some college courses, so I think I can pull this task off properly with some research. It would be a good challenge for me to learn and contribute.

I'll follow the guidelines strictly and would have good prcatices to implement this event. Lmk if I can start working on it.

[Runtee]

Could I take over this issue?

[ekumamatthew]

Can I take this issue?

[Bosun-Josh121]

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged:

software engineering background, backend & smart contract dev (https://app.onlydust.com/users/Bosun-Josh121/overview) looking to make first contribution on this project

How I plan on tackling this issue

I have made contribution to similar issue as sighted in (Trustless-Work/Product#44) for instance. I've gone through highlighted docs to implement here as well. I will work on feedback & recommendation ensuring contact. Can deliver within 48hrs upon assignment