Update Checklist Item with ClickUp API on New Time Entry Started from McTime API

Pipedream makes it easy to connect APIs for ClickUp, McTime and 2,800+ other apps remarkably fast.

Trigger workflow on

New Time Entry Started from the McTime API

Next, do this

Update Checklist Item with the ClickUp API

No credit card required

▶

Watch us build a workflow

8 min

Watch now ➜

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Getting Started#

This integration creates a workflow with a McTime trigger and ClickUp action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Time Entry Started trigger
1. Connect your McTime account
2. Configure timer
Configure the Update Checklist Item action
1. Connect your ClickUp account
2. Select a Workspace
3. Select a Space
4. Optional- Configure Use custom task IDs
5. Optional- Select a Authorized Team
6. Configure Name
7. Optional- Select a Assignee
8. Optional- Configure Resolved
9. Optional- Select a Folder ID
10. Select a List ID
11. Select a Task ID
12. Select a Checklist ID
13. Select a Checklist Item ID
14. Optional- Select a Checklist Parent ID
Deploy the workflow
Send a test event to validate your setup
Turn on the trigger

Details#

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger#

New Time Entry Started on McTime

Description:Emit new event each time a new time entry is started

Version:0.0.1

Key:mctime-new-time-entry-started

View on GitHub

McTime Overview#

The McTime API provides functionality for tracking and managing time-related data. With McTime integrated into Pipedream, you can automate processes involving employee scheduling, time tracking, and payroll. Leverage Pipedream's ability to connect with hundreds of apps to link time data with project management tools, accounting software, and communication platforms, streamlining workflow efficiencies and reducing manual timekeeping errors.

Trigger Code#

import { DEFAULT_POLLING_SOURCE_TIMER_INTERVAL } from "@pipedream/platform";
import mctime from "../../mctime.app.mjs";

export default {
  key: "mctime-new-time-entry-started",
  name: "New Time Entry Started",
  description: "Emit new event each time a new time entry is started",
  version: "0.0.1",
  type: "source",
  dedupe: "unique",
  props: {
    mctime,
    db: "$.service.db",
    timer: {
      type: "$.interface.timer",
      default: {
        intervalSeconds: DEFAULT_POLLING_SOURCE_TIMER_INTERVAL,
      },
    },
  },
  methods: {
    _getLastStarted() {
      return this.db.get("lastStarted");
    },
    _setLastStarted(lastStarted) {
      this.db.set("lastStarted", lastStarted);
    },
    generateMeta(data) {
      const {
        id, from,
      } = data;
      return {
        id,
        summary: `New Time Entry: ${id}`,
        ts: Date.parse(from),
      };
    },
    getDateTimeWithOffset(date) {
      date = new Date(date);
      const offsetMinutes = date.getTimezoneOffset();
      const offsetHours = Math.abs(Math.floor(offsetMinutes / 60));
      const offsetMinutesRemainder = Math.abs(offsetMinutes % 60);
      const offsetSign = offsetMinutes > 0
        ? "-"
        : "+";
      const offsetFormatted = offsetSign + (offsetHours < 10
        ? "0"
        : "") + offsetHours + ":" + (offsetMinutesRemainder < 10
        ? "0"
        : "") + offsetMinutesRemainder;
      const isoString = date.toISOString().split(".")[0];
      return isoString + offsetFormatted;
    },
  },
  async run() {
    const currentDate = new Date();
    const to = this.getDateTimeWithOffset(currentDate);
    let lastStarted = this._getLastStarted()
      || this.getDateTimeWithOffset(currentDate.setDate(currentDate.getDate() - 7)); // if no lastStarted get date from one week ago
    const params = {
      to,
      from: lastStarted,
      page: 1,
    };
    let total;
    do {
      const { items } = await this.mctime.getTimeEntries({
        params,
      });
      const timeEntries = items[0].data.timeEntries;
      for (const timeEntry of timeEntries) {
        for (const time of timeEntry.times) {
          if (Date.parse(time.from) > Date.parse(lastStarted)) {
            lastStarted = time.from;
          }
          const meta = this.generateMeta(time);
          this.$emit(time, meta);
        }
      }
      total = timeEntries?.length;
      params.page++;
    } while (total);
    this._setLastStarted(lastStarted);
  },
};

Trigger Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.

Label	Prop	Type	Description
McTime	`mctime`	`app`	This component uses the McTime app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`

Trigger Authentication#

McTime uses API keys for authentication. When you connect your McTime account, Pipedream securely stores the keys so you can easily authenticate to McTime APIs in both code and no-code steps.

About McTime#

McTime's time recording helps small and large teams to record and evaluate project hours or absences. Fully automatic time recording included!

Action#

Update Checklist Item on ClickUp

Description:Updates item in a checklist. [See the documentation](https://clickup.com/api) in **Checklists / Edit Checklist Item** section.

Version:0.0.10

Key:clickup-update-checklist-item

View on GitHub

ClickUp Overview#

The ClickUp API on Pipedream allows you to automate tasks, sync data across various platforms, and construct custom workflows to streamline project management. By leveraging the API, you can create tasks, update statuses, and manipulate lists or spaces programmatically. Whether you're looking to integrate ClickUp with your CRM, coordinate cross-functional teams, or just manage notifications, Pipedream's serverless platform lets you build scalable, event-driven processes with minimal fuss.

Action Code#

import common from "../common/task-props.mjs";

export default {
  ...common,
  key: "clickup-update-checklist-item",
  name: "Update Checklist Item",
  description: "Updates item in a checklist. [See the documentation](https://clickup.com/api) in **Checklists / Edit Checklist Item** section.",
  version: "0.0.10",
  type: "action",
  props: {
    ...common.props,
    name: {
      label: "Name",
      type: "string",
      description: "The name of item",
    },
    assignee: {
      label: "Assignee",
      type: "string",
      propDefinition: [
        common.props.clickup,
        "assignees",
        (c) => ({
          workspaceId: c.workspaceId,
        }),
      ],
      optional: true,
    },
    resolved: {
      label: "Resolved",
      description: "Set the item as resolved",
      type: "boolean",
      optional: true,
    },
    folderId: {
      propDefinition: [
        common.props.clickup,
        "folderId",
        (c) => ({
          spaceId: c.spaceId,
        }),
      ],
      optional: true,
    },
    listId: {
      propDefinition: [
        common.props.clickup,
        "listId",
        (c) => ({
          folderId: c.folderId,
          spaceId: c.spaceId,
        }),
      ],
    },
    taskId: {
      propDefinition: [
        common.props.clickup,
        "taskId",
        (c) => ({
          listId: c.listId,
          useCustomTaskIds: c.useCustomTaskIds,
          authorizedTeamId: c.authorizedTeamId,
        }),
      ],
      description: "To show options please select a **List** first",
    },
    checklistId: {
      propDefinition: [
        common.props.clickup,
        "checklistId",
        (c) => ({
          taskId: c.taskId,
          useCustomTaskIds: c.useCustomTaskIds,
          authorizedTeamId: c.authorizedTeamId,
        }),
      ],
    },
    checklistItemId: {
      propDefinition: [
        common.props.clickup,
        "checklistItemId",
        (c) => ({
          checklistId: c.checklistId,
          taskId: c.taskId,
          useCustomTaskIds: c.useCustomTaskIds,
          authorizedTeamId: c.authorizedTeamId,
        }),
      ],
    },
    parent: {
      propDefinition: [
        common.props.clickup,
        "checklistItemId",
        (c) => ({
          checklistId: c.checklistId,
          taskId: c.taskId,
          useCustomTaskIds: c.useCustomTaskIds,
          authorizedTeamId: c.authorizedTeamId,
        }),
      ],
      label: "Checklist Parent ID",
      description: "Set another checklist item as parent",
      optional: true,
    },
  },
  async run({ $ }) {
    const {
      checklistId,
      checklistItemId,
      name,
      assignee,
      resolved,
      parent,
    } = this;

    const response = await this.clickup.updateChecklistItem({
      $,
      checklistId,
      checklistItemId,
      data: {
        name,
        assignee,
        resolved,
        parent,
      },
    });

    $.export("$summary", "Successfully updated checklist item");

    return response;
  },
};

Action Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

Label	Prop	Type	Description
ClickUp	`clickup`	`app`	This component uses the ClickUp app.
Workspace	`workspaceId`	`string`	Select a value from the drop down menu.
Space	`spaceId`	`string`	Select a value from the drop down menu.
Use custom task IDs	`useCustomTaskIds`	`boolean`	Whether it should use custom task id instead of the ClickUp task ID. Should be used with `Authorized Team`
Authorized Team	`authorizedTeamId`	`string`	Select a value from the drop down menu.
Name	`name`	`string`	The name of item
Assignee	`assignee`	`string`	Select a value from the drop down menu.
Resolved	`resolved`	`boolean`	Set the item as resolved
Folder ID	`folderId`	`string`	Select a value from the drop down menu.
List ID	`listId`	`string`	Select a value from the drop down menu.
Task ID	`taskId`	`string`	Select a value from the drop down menu.
Checklist ID	`checklistId`	`string`	Select a value from the drop down menu.
Checklist Item ID	`checklistItemId`	`string`	Select a value from the drop down menu.
Checklist Parent ID	`parent`	`string`	Select a value from the drop down menu.

Action Authentication#

ClickUp uses OAuth authentication. When you connect your ClickUp account, Pipedream will open a popup window where you can sign into ClickUp and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any ClickUp API.

Pipedream requests the following authorization scopes when you connect your account:

Update Checklist Item with ClickUp API on New Time Entry Started from McTime API

Pipedream makes it easy to connect APIs for ClickUp, McTime and 2,800+ other apps remarkably fast.

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

1-24of2,800+apps by most popular

1
-
24
of
2,800+
apps by most popular