Skip to main content
Glama

mcp-google-sheets

task-completed.ts3.52 kB
import { OAuth2PropertyValue, Property } from '@activepieces/pieces-framework'; import { createTrigger, TriggerStrategy } from '@activepieces/pieces-framework'; import { DedupeStrategy, Polling, pollingHelper } from '@activepieces/pieces-common'; import { getTaskListsDropdown } from '../common'; import { microsoftToDoAuth } from '../../index'; import { Client, PageCollection } from '@microsoft/microsoft-graph-client'; import dayjs from 'dayjs'; import { TodoTask } from '@microsoft/microsoft-graph-types'; // https://learn.microsoft.com/en-us/answers/questions/567068/to-do-completeddatetime-and-timezone //Due to inconsistencies in completedDateTime, this trigger is currently unavailable. const polling: Polling<OAuth2PropertyValue, { task_list_id: string }> = { strategy: DedupeStrategy.TIMEBASED, items: async ({ auth, propsValue, lastFetchEpochMS }) => { const taskListId = propsValue.task_list_id; const client = Client.initWithMiddleware({ authProvider: { getAccessToken: () => Promise.resolve(auth.access_token), }, }); const tasks = []; const filter = lastFetchEpochMS === 0 ? '$top=10' : `$filter=status eq 'completed'`; let response: PageCollection = await client .api(`/me/todo/lists/${taskListId}/tasks?${filter}`) .get(); if (lastFetchEpochMS === 0) { for (const task of response.value as TodoTask[]) { tasks.push(task); } } else { while (response.value.length > 0) { for (const task of response.value as TodoTask[]) { tasks.push(task); } if (response['@odata.nextLink']) { response = await client.api(response['@odata.nextLink']).get(); } else { break; } } } return tasks.map((task) => ({ epochMilliSeconds: dayjs(task.completedDateTime?.dateTime).valueOf(), data: task, })); }, }; export const taskCompletedTrigger = createTrigger({ name: 'task_completed', displayName: 'Task Completed', description: 'Triggers when a task is completed.', auth: microsoftToDoAuth, props: { task_list_id: Property.Dropdown({ displayName: 'Task List', required: true, refreshers: [], options: async ({ auth }) => { if (!(auth as OAuth2PropertyValue)?.access_token) { return { disabled: true, placeholder: 'Connect your account first', options: [] }; } return await getTaskListsDropdown(auth as OAuth2PropertyValue); }, }), }, type: TriggerStrategy.POLLING, async onEnable(context) { await pollingHelper.onEnable(polling, { auth: context.auth, store: context.store, propsValue: context.propsValue, }); }, async onDisable(context) { await pollingHelper.onDisable(polling, { auth: context.auth, store: context.store, propsValue: context.propsValue, }); }, async test(context) { return await pollingHelper.test(polling, context); }, async run(context) { return await pollingHelper.poll(polling, context); }, sampleData: { '@odata.etag': 'W/"vVwdQvxCiE6779iYhchMrAAGgwrltg=="', importance: 'normal', isReminderOn: false, status: 'completed', title: 'Test Task', createdDateTime: '2025-05-08T14:05:53.4572708Z', lastModifiedDateTime: '2025-05-08T14:41:50.2593794Z', hasAttachments: false, categories: ['Blue category'], id: 'AQMkADAwATM3ZmYAZS0xNGVmLWNiZmYALTAwAi0wMAoARgAAAw8tTPoZEYtLvE5mK48wuvIHAL1cHUL8QohOu_-YmIXITKwABoMc598AAAC9XB1C-EKITrvv2JiFyEysAAaDHUmqAAAA', body: { content: '', contentType: 'text', }, completedDateTime: { dateTime: '2025-05-07T18:30:00.0000000', timeZone: 'UTC', }, }, });

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/activepieces/activepieces'

If you have feedback or need assistance with the MCP directory API, please join our Discord server