A customer lookup tool for your support team

// _worker.js
export default {
  async fetch(request, env) {
    const url = new URL(request.url);
    if (url.pathname !== '/api/search') return new Response('Not found', { status: 404 });

    const email = request.headers.get('x-brod-user-email');
    const q = (url.searchParams.get('q') || '').trim();
    if (q.length < 3) return Response.json({ customers: [] });

    const res = await fetch(
      'https://api.yourcrm.example/v1/contacts?search=' + encodeURIComponent(q),
      { headers: { Authorization: 'Bearer ' + env.CRM_API_KEY } });
    if (!res.ok) {
      console.log('crm error', res.status);           // shows in get_logs, without customer data
      return new Response('CRM unavailable', { status: 502 });
    }
    const { results } = await res.json();

    await env.DB.run('CREATE TABLE IF NOT EXISTS searches (by TEXT, q TEXT, at INTEGER)');
    await env.DB.run('INSERT INTO searches VALUES (?, ?, ?)', [email, q, Date.now()]);

    // Send the browser only what support needs
    return Response.json({
      customers: results.map(c => ({
        name: c.name, email: c.email, plan: c.plan,
        openTickets: c.open_tickets, lastOrder: c.last_order,
      })),
    });
  },
};