How to Integrate Monday.com with V0

1// app/api/monday/items/route.ts
2import { NextRequest, NextResponse } from 'next/server';
3
4const MONDAY_API_URL = 'https://api.monday.com/v2';
5
6async function mondayQuery<T = unknown>(
7  query: string,
8  variables: Record<string, unknown> = {}
9): Promise<T> {
10  const token = process.env.MONDAY_API_TOKEN;
11  if (!token) throw new Error('MONDAY_API_TOKEN is not configured');
12
13  const response = await fetch(MONDAY_API_URL, {
14    method: 'POST',
15    headers: {
16      Authorization: token,
17      'Content-Type': 'application/json',
18      'API-Version': '2024-01',
19    },
20    body: JSON.stringify({ query, variables }),
21  });
22
23  if (!response.ok) {
24    throw new Error(`Monday.com API HTTP error: ${response.status}`);
25  }
26
27  const result = await response.json();
28
29  if (result.errors?.length) {
30    throw new Error(`Monday.com GraphQL error: ${result.errors[0].message}`);
31  }
32
33  return result.data;
34}
35
36export async function GET(request: NextRequest) {
37  const { searchParams } = new URL(request.url);
38  const boardId = searchParams.get('boardId');
39
40  if (!boardId) {
41    return NextResponse.json({ error: 'boardId query parameter is required' }, { status: 400 });
42  }
43
44  const query = `
45    query GetBoardItems($boardId: ID!, $limit: Int) {
46      boards(ids: [$boardId]) {
47        id
48        name
49        description
50        columns {
51          id
52          title
53          type
54        }
55        groups {
56          id
57          title
58          color
59        }
60        items_page(limit: $limit) {
61          cursor
62          items {
63            id
64            name
65            state
66            created_at
67            updated_at
68            group {
69              id
70              title
71            }
72            column_values {
73              id
74              type
75              text
76              value
77              column {
78                title
79              }
80            }
81          }
82        }
83      }
84    }
85  `;
86
87  try {
88    const data = await mondayQuery<{
89      boards: Array<{
90        id: string;
91        name: string;
92        columns: Array<{ id: string; title: string; type: string }>;
93        groups: Array<{ id: string; title: string; color: string }>;
94        items_page: { items: Array<Record<string, unknown>> };
95      }>;
96    }>(query, { boardId, limit: 200 });
97
98    const board = data.boards[0];
99    if (!board) {
100      return NextResponse.json({ error: 'Board not found' }, { status: 404 });
101    }
102
103    return NextResponse.json({
104      board: {
105        id: board.id,
106        name: board.name,
107        columns: board.columns,
108        groups: board.groups,
109        items: board.items_page.items,
110      },
111    });
112  } catch (error) {
113    const message = error instanceof Error ? error.message : 'Unknown error';
114    console.error('Monday.com items fetch failed:', message);
115    return NextResponse.json({ error: message }, { status: 500 });
116  }
117}

1// app/api/monday/create-item/route.ts
2import { NextRequest, NextResponse } from 'next/server';
3
4const MONDAY_API_URL = 'https://api.monday.com/v2';
5
6async function mondayMutation(query: string, variables: Record<string, unknown>) {
7  const response = await fetch(MONDAY_API_URL, {
8    method: 'POST',
9    headers: {
10      Authorization: process.env.MONDAY_API_TOKEN!,
11      'Content-Type': 'application/json',
12      'API-Version': '2024-01',
13    },
14    body: JSON.stringify({ query, variables }),
15  });
16  const result = await response.json();
17  if (result.errors?.length) throw new Error(result.errors[0].message);
18  return result.data;
19}
20
21export async function POST(request: NextRequest) {
22  try {
23    const { boardId, groupId, name, status, dueDate, assignee } = await request.json();
24
25    if (!boardId || !name) {
26      return NextResponse.json({ error: 'boardId and name are required' }, { status: 400 });
27    }
28
29    // Build column values JSON — column IDs depend on your board configuration
30    const columnValues: Record<string, unknown> = {};
31    if (status) columnValues['status'] = { label: status };
32    if (dueDate) columnValues['date4'] = { date: dueDate };
33    if (assignee) columnValues['text'] = assignee;
34
35    const mutation = `
36      mutation CreateItem($boardId: ID!, $groupId: String, $name: String!, $columnValues: JSON) {
37        create_item(
38          board_id: $boardId
39          group_id: $groupId
40          item_name: $name
41          column_values: $columnValues
42        ) {
43          id
44          name
45          created_at
46        }
47      }
48    `;
49
50    const data = await mondayMutation(mutation, {
51      boardId,
52      groupId: groupId || null,
53      name,
54      columnValues: JSON.stringify(columnValues),
55    });
56
57    return NextResponse.json({ success: true, item: data.create_item });
58  } catch (error) {
59    const message = error instanceof Error ? error.message : 'Unknown error';
60    console.error('Monday.com create item failed:', message);
61    return NextResponse.json({ error: message }, { status: 500 });
62  }
63}