Name: List Related Deals
Author: Cimminelli1982

Flusso

Parse context — the frontend sends Contact ID and Contact Name
If no Contact ID — ask Simone which contact to look up
Query deals_contacts — find all deals linked to this contact
Format and display — show deal opportunity, stage, category, amount, linked contacts
Handle edge cases — no deals found → say so

1) Find deals for contact

source /opt/openclaw.env

curl -sS "${SUPABASE_URL}/rest/v1/deals_contacts?contact_id=eq.{CONTACT_ID}&select=relationship,deals(deal_id,opportunity,deal_name,stage,category,total_investment,deal_currency,source_category,description,created_at)" \
  -H "apikey: $SUPABASE_KEY" -H "Authorization: Bearer $SUPABASE_KEY"

2) Get linked contacts for each deal (optional, for richer display)

Flusso

Parse context — the frontend sends Contact ID and Contact Name
If no Contact ID — ask Simone which contact to look up
Query deals_contacts — find all deals linked to this contact
Format and display — show deal opportunity, stage, category, amount, linked contacts
Handle edge cases — no deals found → say so

1) Find deals for contact

source /opt/openclaw.env

curl -sS "${SUPABASE_URL}/rest/v1/deals_contacts?contact_id=eq.{CONTACT_ID}&select=relationship,deals(deal_id,opportunity,deal_name,stage,category,total_investment,deal_currency,source_category,description,created_at)" \
  -H "apikey: $SUPABASE_KEY" -H "Authorization: Bearer $SUPABASE_KEY"

List Related Deals

Flusso

1) Find deals for contact

2) Get linked contacts for each deal (optional, for richer display)

List Related Deals

Flusso

1) Find deals for contact

2) Get linked contacts for each deal (optional, for richer display)

3) Format response

Log operativo

Ordercli

Paypal Integration

Stripe Integration

Billing Automation

Odoo Ecommerce Configurator

Odoo Shopify Integration