How to Integrate Omnifocus with V0

1// app/api/omnifocus/sync/route.ts
2import { NextRequest, NextResponse } from 'next/server';
3import { neon } from '@neondatabase/serverless';
4
5interface OFTask {
6  id: string;
7  name: string;
8  projectId?: string;
9  projectName?: string;
10  dueDate?: string;    // ISO 8601 or null
11  flagged: boolean;
12  completed: boolean;
13  tags: string[];
14  note?: string;
15  estimatedMinutes?: number;
16}
17
18interface OFProject {
19  id: string;
20  name: string;
21  folder?: string;
22  status: 'active' | 'on-hold' | 'dropped' | 'done';
23  dueDate?: string;
24  taskCount: number;
25  completedCount: number;
26}
27
28interface SyncPayload {
29  userId: string;
30  tasks: OFTask[];
31  projects: OFProject[];
32  syncedAt: string;
33}
34
35export async function POST(request: NextRequest) {
36  const authHeader = request.headers.get('Authorization');
37  if (authHeader !== `Bearer ${process.env.OMNIFOCUS_SYNC_SECRET}`) {
38    return NextResponse.json({ error: 'Unauthorized' }, { status: 401 });
39  }
40
41  const sql = neon(process.env.DATABASE_URL!);
42  let body: SyncPayload;
43
44  try {
45    body = await request.json();
46  } catch {
47    return NextResponse.json({ error: 'Invalid JSON' }, { status: 400 });
48  }
49
50  const { userId, tasks, projects, syncedAt } = body;
51
52  if (!userId) {
53    return NextResponse.json({ error: 'userId required' }, { status: 400 });
54  }
55
56  // Ensure tables exist
57  await sql`
58    CREATE TABLE IF NOT EXISTS of_tasks (
59      id TEXT,
60      user_id TEXT,
61      name TEXT NOT NULL,
62      project_id TEXT,
63      project_name TEXT,
64      due_date TIMESTAMPTZ,
65      flagged BOOLEAN DEFAULT false,
66      completed BOOLEAN DEFAULT false,
67      tags JSONB DEFAULT '[]',
68      note TEXT,
69      estimated_minutes INTEGER,
70      synced_at TIMESTAMPTZ,
71      PRIMARY KEY (id, user_id)
72    )
73  `;
74
75  // Full replacement sync — delete old data for this user first
76  await sql`DELETE FROM of_tasks WHERE user_id = ${userId}`;
77
78  // Insert current snapshot
79  for (const task of tasks) {
80    await sql`
81      INSERT INTO of_tasks
82        (id, user_id, name, project_id, project_name, due_date,
83         flagged, completed, tags, note, estimated_minutes, synced_at)
84      VALUES
85        (${task.id}, ${userId}, ${task.name}, ${task.projectId ?? null},
86         ${task.projectName ?? null}, ${task.dueDate ?? null},
87         ${task.flagged}, ${task.completed}, ${JSON.stringify(task.tags)},
88         ${task.note ?? null}, ${task.estimatedMinutes ?? null}, ${syncedAt})
89    `;
90  }
91
92  return NextResponse.json({
93    success: true,
94    tasksStored: tasks.length,
95    projectsReceived: projects.length,
96  });
97}

1-- OmniFocus AppleScript export (save in Script Editor, schedule with launchd)
2tell application "OmniFocus"
3  tell default document
4    set theTasks to flattened tasks where completed is false
5    
6    set taskList to ""
7    set taskCount to count of theTasks
8    
9    repeat with i from 1 to taskCount
10      set theTask to item i of theTasks
11      
12      set taskName to name of theTask
13      -- Escape quotes in task names for JSON
14      set taskName to my replaceText(taskName, "\"", "\\\"")
15      
16      set taskID to id of theTask
17      set isFlagged to flagged of theTask
18      set isCompleted to completed of theTask
19      
20      set dueStr to "null"
21      if due date of theTask is not missing value then
22        set dueDate to due date of theTask
23        set dueStr to "\"" & (year of dueDate as text) & "-" & my pad(month of dueDate as integer) & "-" & my pad(day of dueDate) & "T" & my pad(hours of dueDate) & ":" & my pad(minutes of dueDate) & ":00Z" & "\""
24      end if
25      
26      set taskJSON to "{\"id\":\"" & taskID & "\",\"name\":\"" & taskName & "\",\"flagged\":" & isFlagged & ",\"completed\":" & isCompleted & ",\"dueDate\":" & dueStr & ",\"tags\":[]}"
27      
28      if i < taskCount then
29        set taskList to taskList & taskJSON & ","
30      else
31        set taskList to taskList & taskJSON
32      end if
33    end repeat
34    
35    set jsonPayload to "{\"userId\":\"YOUR_USER_ID\",\"tasks\":[" & taskList & "],\"projects\":[],\"syncedAt\":\"" & (current date as «class isot» as text) & "\"}"
36    
37    -- POST to your Next.js API route
38    set curlCmd to "curl -s -X POST https://your-app.vercel.app/api/omnifocus/sync -H 'Content-Type: application/json' -H 'Authorization: Bearer YOUR_SECRET' -d '" & jsonPayload & "'"
39    do shell script curlCmd
40  end tell
41end tell
42
43on pad(num)
44  if num < 10 then
45    return "0" & num
46  else
47    return num as text
48  end if
49end pad
50
51on replaceText(theText, searchStr, replaceStr)
52  set AppleScript's text item delimiters to searchStr
53  set theItems to text items of theText
54  set AppleScript's text item delimiters to replaceStr
55  set theResult to theItems as text
56  set AppleScript's text item delimiters to ""
57  return theResult
58end replaceText