Handling Retries

function idempotencyKey(eventData: any, eventId: string): string {
  if (eventData.event === 'message.received') {
    // Inbound: each inbound message has its own UUID
    return `in:${eventData.payload.message_id}`;
  }
  if (eventData.field === 'message' && eventData.payload.message_id) {
    // Outbound: state transition is unique
    return `msg:${eventData.payload.message_id}:${eventData.payload.message_status}`;
  }
  if (eventData.field === 'templates') {
    return `tpl:${eventData.payload.template_id}:${eventData.payload.status}`;
  }
  // Fallback: the event's own UUID, identical on every attempt
  return `evt:${eventId}`;
}

async function handleWebhook(eventData: any, eventId: string) {
  const key = idempotencyKey(eventData, eventId);

  const existing = await db.webhookEvents.findUnique({ where: { idempotencyKey: key } });
  if (existing) {
    console.log(`Event ${key} already processed`);
    return;
  }

  await processEvent(eventData);

  await db.webhookEvents.create({
    data: { idempotencyKey: key, eventType: eventData.field, processedAt: new Date() }
  });
}

def idempotency_key(event_data: dict, event_id: str) -> str:
    if event_data.get('event') == 'message.received':
        # Inbound: each inbound message has its own UUID
        return f"in:{event_data['payload']['message_id']}"
    if event_data.get('field') == 'message' and event_data['payload'].get('message_id'):
        return f"msg:{event_data['payload']['message_id']}:{event_data['payload']['message_status']}"
    if event_data.get('field') == 'templates':
        return f"tpl:{event_data['payload']['template_id']}:{event_data['payload']['status']}"
    # Fallback: the event's own UUID, identical on every attempt
    return f"evt:{event_id}"

async def handle_webhook(event_data: dict, event_id: str):
    key = idempotency_key(event_data, event_id)

    existing = db.webhook_events.find_unique(where={"idempotency_key": key})
    if existing:
        print(f"Event {key} already processed")
        return

    await process_event(event_data)

    db.webhook_events.create({
        "idempotency_key": key,
        "event_type": event_data['field'],
        "processed_at": datetime.now()
    })

import "fmt"

func idempotencyKey(event WebhookEvent, eventID string) string {
    // WebhookEvent maps the envelope: Field `json:"field"`, Event `json:"event"`, Payload `json:"payload"`
    if event.Event != nil && *event.Event == "message.received" {
        // Inbound: each inbound message has its own UUID
        return fmt.Sprintf("in:%s", event.Payload.MessageID)
    }
    if event.Field == "message" && event.Payload.MessageID != "" {
        return fmt.Sprintf("msg:%s:%s", event.Payload.MessageID, event.Payload.MessageStatus)
    }
    if event.Field == "templates" {
        return fmt.Sprintf("tpl:%s:%s", event.Payload.TemplateID, event.Payload.Status)
    }
    // Fallback: the event's own UUID, identical on every attempt
    return fmt.Sprintf("evt:%s", eventID)
}

func handleWebhook(event WebhookEvent, eventID string) error {
    key := idempotencyKey(event, eventID)

    var exists bool
    if err := db.QueryRow("SELECT EXISTS(SELECT 1 FROM webhook_events WHERE idempotency_key = $1)", key).Scan(&exists); err != nil {
        return err
    }
    if exists {
        log.Printf("Event %s already processed", key)
        return nil
    }

    if err := processEvent(event); err != nil {
        return err
    }

    _, err := db.Exec(
        "INSERT INTO webhook_events (idempotency_key, event_type, processed_at) VALUES ($1, $2, $3)",
        key, event.Field, time.Now(),
    )
    return err
}

const key = idempotencyKey(eventData, eventId);

await db.$transaction(async (tx) => {
  // Record event processing start
  await tx.webhookEvents.create({
    data: {
      idempotencyKey: key,
      eventType: eventData.field,
      status: 'processing'
    }
  });

  // Process business logic
  if (eventData.field === 'message') {
    await tx.messages.update({
      where: { id: eventData.payload.message_id },
      data: { status: eventData.payload.message_status }
    });
  }

  // Mark as completed
  await tx.webhookEvents.update({
    where: { idempotencyKey: key },
    data: { status: 'completed' }
  });
});

key = idempotency_key(event_data, event_id)

with db.transaction():
    # Record event processing start
    webhook_event = WebhookEvent(
        idempotency_key=key,
        event_type=event_data['field'],
        status="processing"
    )
    db.add(webhook_event)

    # Process business logic
    if event_data['field'] == 'message':
        message = db.messages.find_by_id(event_data['payload']['message_id'])
        message.status = event_data['payload']['message_status']

    # Mark as completed
    webhook_event.status = "completed"
    db.commit()