Webhook Configuration

https://aeroquote.aviationopsmanager.com/api/functions/aeroquoteWebhook

x-webhook-secret

{
  "trip": {
    "trip_number": "AQ-001",
    "client_name": "John Smith",
    "status": "scheduled",
    "aircraft_type": "Citation CJ3",
    "aircraft_tail": "N123AB",
    "departure_date": "2026-05-01",
    "legs": [
      {
        "leg_number": 1,
        "departure_airport": "KMIA",
        "arrival_airport": "KTEB",
        "departure_time": "2026-05-01T08:00:00",
        "arrival_time": "2026-05-01T11:30:00"
      }
    ]
  }
}

import { createClientFromRequest } from 'npm:@base44/sdk@0.8.25';

Deno.serve(async (req) => {
  try {
    const base44 = createClientFromRequest(req);
    const user = await base44.auth.me();
    if (!user) return Response.json({ error: 'Unauthorized' }, { status: 401 });

    const { trip_id } = await req.json();

    // Fetch the trip from AeroQuote's database
    const trip = await base44.entities.Trip.get(trip_id);
    if (!trip) return Response.json({ error: 'Trip not found' }, { status: 404 });

    // Fetch the trip's legs
    const legs = await base44.entities.TripLeg.filter({ trip_id: trip.id });

    // Build the payload to send to AeroPilot Pro
    const payload = {
      trip: {
        trip_number: trip.trip_number,
        company_id: trip.company_id || '',
        client_name: trip.client_name || '',
        status: trip.status || 'scheduled',
        departure_date: trip.departure_date || null,
        return_date: trip.return_date || null,
        aircraft_type: trip.aircraft_type || '',
        aircraft_tail: trip.aircraft_tail || '',
        assigned_pilots: trip.assigned_pilots || [],
        pic_name: trip.pic_name || '',
        sic_name: trip.sic_name || '',
        notes: trip.notes || '',
        dispatch_notes: trip.dispatch_notes || '',
        legs: legs.map(leg => ({
          leg_number: leg.leg_number,
          departure_airport: leg.departure_airport,
          arrival_airport: leg.arrival_airport,
          departure_time: leg.departure_time || null,
          arrival_time: leg.arrival_time || null,
          status: leg.status || 'planned',
          fbo_departure: leg.fbo_departure || '',
          fbo_arrival: leg.fbo_arrival || '',
          fbo_departure_phone: leg.fbo_departure_phone || '',
          fbo_arrival_phone: leg.fbo_arrival_phone || '',
          fbo_departure_address: leg.fbo_departure_address || '',
          fbo_arrival_address: leg.fbo_arrival_address || '',
          passengers: leg.passengers || 0,
          flight_time_estimated: leg.flight_time_estimated || 0,
          notes: leg.notes || '',
        })),
      }
    };

    // ✅ FILL IN THESE TWO VALUES:
    const AEROPILOT_WEBHOOK_URL = 'YOUR_AEROPILOT_WEBHOOK_URL_HERE';
    const AEROPILOT_WEBHOOK_SECRET = 'YOUR_AEROQUOTE_WEBHOOK_SECRET_VALUE';

    const res = await fetch(AEROPILOT_WEBHOOK_URL, {
      method: 'POST',
      headers: {
        'Content-Type': 'application/json',
        'x-webhook-secret': AEROPILOT_WEBHOOK_SECRET,
      },
      body: JSON.stringify(payload),
    });

    const result = await res.json();
    console.log('AeroPilot sync result:', JSON.stringify(result));

    return Response.json({ success: true, result });
  } catch (error) {
    console.error('pushTripToAeroPilot error:', error);
    return Response.json({ error: error.message }, { status: 500 });
  }
});

{
  "success": true,
  "trip_number": "AQ-001",
  "action": "updated",
  "trip_id": "abc123"
}

https://aeroquote.aviationopsmanager.com/api/functions/aeropilotInbound