process-document

POST /functions/v1/process-document

curl -i --location --request POST \
  'https://your-project.supabase.co/functions/v1/process-document' \
  --header 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...' \
  --header 'Content-Type: image/jpeg' \
  --header 'x-file-name: receipt.jpg' \
  --data-binary '@/path/to/receipt.jpg'

curl -i --location --request POST \
  'https://your-project.supabase.co/functions/v1/process-document' \
  --header 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...' \
  --header 'Content-Type: application/pdf' \
  --header 'x-file-name: invoice.pdf' \
  --data-binary '@/path/to/invoice.pdf'

{
  "success": true,
  "transaction": {
    "id": "uuid",
    "user_id": "uuid",
    "source_email": "manual-upload",
    "source_message_id": "manual-1234567890-abc123xyz",
    "date": "2024-03-04T10:30:00.000Z",
    "amount": 42.99,
    "currency": "USD",
    "transaction_type": "expense",
    "transaction_description": "Coffee and pastries",
    "transaction_date": "2024-03-04",
    "merchant": "Local Cafe",
    "category": "food"
  },
  "message": "Transaction created successfully from document"
}

{
  "success": false,
  "error": "Could not extract transaction data from document"
}

{
  "success": false,
  "error": "This appears to be a personal email, not a receipt or invoice"
}

{
  "error": "No file provided"
}

{
  "error": "File too large. Maximum size is 5MB."
}

{
  "error": "Unsupported file type. Only PDF and image files are allowed."
}

{
  "error": "Could not extract text from PDF"
}

{
  "error": "Unauthorized"
}

{
  "error": "Method not allowed"
}

{
  "error": "Failed to process PDF file"
}

{
  "error": "Failed to save transaction"
}

{
  "error": "Internal server error"
}

const pdf = await getDocumentProxy(fileBytes)
const { text } = await extractText(pdf, { mergePages: true })

{
  data: Uint8Array,
  mimeType: string,  // Normalized to 'image/jpeg' for 'image/jpg'
  filename: string
}

{
  user_id: string,
  source_email: 'manual-upload',
  source_message_id: `manual-${Date.now()}-${randomString}`,
  date: string,  // Current timestamp
  amount: number,
  currency: string,
  transaction_type: string,
  transaction_description: string,
  transaction_date: string,
  merchant: string,
  category: string
}

const { flushLangfuse } = await import("../_shared/lib/langfuse.ts")
await flushLangfuse()

const normalizedMimeType = contentType === 'image/jpg' ? 'image/jpeg' : contentType

import { extractText, getDocumentProxy } from 'npm:unpdf'

const { data: userData } = await supabase.auth.admin.getUserById(user.id)
const userFullName = userData?.user?.user_metadata?.full_name