How to Integrate Expensify with V0

1import { NextRequest, NextResponse } from 'next/server';
2
3const EXPENSIFY_API_URL = 'https://integrations.expensify.com/Integration-Server/ExpensifyIntegrations';
4
5function getCredentials() {
6  const partnerUserID = process.env.EXPENSIFY_PARTNER_USER_ID;
7  const partnerUserSecret = process.env.EXPENSIFY_PARTNER_USER_SECRET;
8  if (!partnerUserID || !partnerUserSecret) {
9    throw new Error('Expensify credentials not configured in environment variables');
10  }
11  return { partnerUserID, partnerUserSecret };
12}
13
14async function callExpensify(command: object): Promise<Response> {
15  const body = new URLSearchParams({
16    requestJobDescription: JSON.stringify(command),
17  });
18
19  return fetch(EXPENSIFY_API_URL, {
20    method: 'POST',
21    headers: { 'Content-Type': 'application/x-www-form-urlencoded' },
22    body: body.toString(),
23  });
24}
25
26export async function GET(request: NextRequest) {
27  const { searchParams } = new URL(request.url);
28  const status = searchParams.get('status') || 'OPEN';
29  const startDate = searchParams.get('from') || '2024-01-01';
30  const endDate = searchParams.get('to') || new Date().toISOString().split('T')[0];
31  const policyID = process.env.EXPENSIFY_POLICY_ID;
32
33  try {
34    const { partnerUserID, partnerUserSecret } = getCredentials();
35
36    const command = {
37      type: 'get',
38      credentials: { partnerUserID, partnerUserSecret },
39      inputSettings: {
40        type: 'reportInfos',
41        filters: {
42          startDate,
43          endDate,
44          status,
45          ...(policyID && { policyIDList: [policyID] }),
46        },
47      },
48    };
49
50    const response = await callExpensify(command);
51
52    if (!response.ok) {
53      return NextResponse.json(
54        { error: `Expensify API returned ${response.status}` },
55        { status: response.status }
56      );
57    }
58
59    const data = await response.json();
60
61    // Expensify returns responseCode 200 inside the JSON even on errors
62    if (data.responseCode && data.responseCode !== 200) {
63      return NextResponse.json(
64        { error: data.responseMessage || 'Expensify API error' },
65        { status: 400 }
66      );
67    }
68
69    return NextResponse.json(data);
70  } catch (error) {
71    console.error('Expensify API error:', error);
72    return NextResponse.json({ error: 'Failed to fetch expense reports' }, { status: 500 });
73  }
74}
75
76export async function POST(request: NextRequest) {
77  const body = await request.json();
78  const { title, amount, category, date, description, policyID } = body;
79
80  if (!title || !amount) {
81    return NextResponse.json({ error: 'Report title and amount are required' }, { status: 400 });
82  }
83
84  try {
85    const { partnerUserID, partnerUserSecret } = getCredentials();
86    const effectivePolicyID = policyID || process.env.EXPENSIFY_POLICY_ID;
87
88    const command = {
89      type: 'create',
90      credentials: { partnerUserID, partnerUserSecret },
91      inputSettings: {
92        type: 'report',
93        policyID: effectivePolicyID,
94        report: {
95          title,
96          fields: { description: description || '' },
97        },
98        expenses: [
99          {
100            date: date || new Date().toISOString().split('T')[0],
101            currency: 'USD',
102            amount: Math.round(amount * 100), // Expensify uses cents
103            category: category || 'General',
104            comment: description || '',
105          },
106        ],
107      },
108    };
109
110    const response = await callExpensify(command);
111    const data = await response.json();
112
113    if (data.responseCode && data.responseCode !== 200) {
114      return NextResponse.json(
115        { error: data.responseMessage || 'Failed to create expense report' },
116        { status: 400 }
117      );
118    }
119
120    return NextResponse.json({ reportID: data.reportID, success: true }, { status: 201 });
121  } catch (error) {
122    console.error('Expensify create error:', error);
123    return NextResponse.json({ error: 'Failed to create expense report' }, { status: 500 });
124  }
125}

1import { NextRequest, NextResponse } from 'next/server';
2
3export async function POST(request: NextRequest) {
4  try {
5    // Expensify sends webhooks as form-encoded data, not JSON
6    const formData = await request.formData();
7    const payloadRaw = formData.get('payload');
8
9    if (!payloadRaw || typeof payloadRaw !== 'string') {
10      // Some Expensify webhook versions send JSON directly
11      const jsonBody = await request.json().catch(() => null);
12      if (!jsonBody) {
13        return NextResponse.json({ error: 'Invalid webhook payload' }, { status: 400 });
14      }
15      // Handle JSON payload
16      console.log('Expensify webhook (JSON):', JSON.stringify(jsonBody));
17      return NextResponse.json({ received: true });
18    }
19
20    const payload = JSON.parse(payloadRaw);
21    const { reportID, status, action } = payload;
22
23    console.log(`Expensify webhook: report ${reportID} status changed to ${status} via ${action}`);
24
25    // Add your business logic here:
26    // - Update database record
27    // - Send Slack/email notification
28    // - Trigger downstream workflows
29
30    // Always return 200 quickly — Expensify retries on non-200 responses
31    return NextResponse.json({ received: true });
32  } catch (error) {
33    console.error('Expensify webhook error:', error);
34    // Return 200 anyway to prevent Expensify retry loops
35    return NextResponse.json({ received: true });
36  }
37}