Create Timesheet Entry with Harvest API on Weekly schedule from Schedule API

Pipedream makes it easy to connect APIs for Harvest, Schedule and 2,400+ other apps remarkably fast.

Trigger workflow on

Weekly schedule from the Schedule API

Next, do this

Create Timesheet Entry with the Harvest 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 Schedule trigger and Harvest action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the Weekly schedule trigger
1. Connect your Schedule account
2. Configure Cron Schedule
Configure the Create Timesheet Entry action
1. Connect your Harvest account
2. Select a Account ID
3. Select a Project ID
4. Select a Task ID
5. Configure Spent date (YYYY-MM-DD)
6. Optional- Select a User ID
7. Configure Specify start and end time
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#

Weekly schedule on Schedule

Description:Trigger your workflow on one or more days each week at a specific time (with timezone support).

Version:0.0.1

Key:schedule-weekly

View on GitHub

Schedule Overview#

The Schedule app in Pipedream is a powerful tool that allows you to trigger workflows at regular intervals, ranging from every minute to once a year. This enables the automation of repetitive tasks and the scheduling of actions to occur without manual intervention. By leveraging this API, you can execute code, run integrations, and process data on a reliable schedule, all within Pipedream's serverless environment.

Trigger Code#

import schedule from "../../schedule.app.mjs";

export default {
  name: "Weekly schedule",
  version: "0.0.1",
  key: "schedule-weekly",
  type: "source",
  description: "Trigger your workflow on one or more days each week at a specific time (with timezone support).",
  props: {
    schedule,
    cron: {
      propDefinition: [
        schedule,
        "cron",
      ],
      default: {
        cron: "0 10 * * 1",
      },
    },
  },
};

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
Schedule	`schedule`	`app`	This component uses the Schedule app.
Cron Schedule	`cron`	`$.interface.timer`	Enter a cron expression

Trigger Authentication#

The Schedule API does not require authentication.

About Schedule#

Trigger workflows on an interval or cron schedule.

Action#

Create Timesheet Entry on Harvest

Description:Creates a new time entry object. [Create a time entry via duration documentation](https://help.getharvest.com/api-v2/timesheets-api/timesheets/time-entries/#create-a-time-entry-via-duration), [Create a time entry via start and end time documentation](https://help.getharvest.com/api-v2/timesheets-api/timesheets/time-entries/#create-a-time-entry-via-start-and-end-time)

Version:0.0.2

Key:harvest-create-timesheet-entry

View on GitHub

Harvest Overview#

Harvest is a time tracking and invoicing tool that can streamline the way freelancers and businesses record time for various projects and tasks. By leveraging the Harvest API on Pipedream, you can automate complex workflows that integrate time tracking data with other business tools. Generate reports, sync project data, and manage invoices with minimal manual intervention. Pipedream's serverless platform lets you create these automations using simple, code-driven components, enabling a seamless connection between Harvest and a multitude of other apps.

Action Code#

import { ConfigurationError } from "@pipedream/platform";
import harvest from "../../harvest.app.mjs";
import {
  isValidDate, isValidTime, removeNullEntries,
} from "../../common/utils.mjs";

export default {
  key: "harvest-create-timesheet-entry",
  name: "Create Timesheet Entry",
  description: `Creates a new time entry object. 
  [Create a time entry via duration documentation](https://help.getharvest.com/api-v2/timesheets-api/timesheets/time-entries/#create-a-time-entry-via-duration),
  [Create a time entry via start and end time documentation](https://help.getharvest.com/api-v2/timesheets-api/timesheets/time-entries/#create-a-time-entry-via-start-and-end-time)`,
  version: "0.0.2",
  type: "action",
  props: {
    harvest,
    accountId: {
      propDefinition: [
        harvest,
        "accountId",
      ],
    },
    projectId: {
      propDefinition: [
        harvest,
        "projectId",
        (c) => ({
          accountId: c.accountId,
        }),
      ],
    },
    taskId: {
      propDefinition: [
        harvest,
        "taskId",
        (c) => ({
          accountId: c.accountId,
        }),
      ],
    },
    spentDate: {
      type: "string",
      label: "Spent date (YYYY-MM-DD)",
      description: "The ISO 8601 formatted date on which the time entry was spent. Example: 2019-07-26",
    },
    userId: {
      propDefinition: [
        harvest,
        "userId",
        (c) => ({
          accountId: c.accountId,
        }),
      ],
    },
    specifyStartEndTime: {
      type: "boolean",
      label: "Specify start and end time",
      description: "Specify start and end time",
      reloadProps: true,
    },
  },
  async additionalProps() {
    const props = {};
    if (this.specifyStartEndTime === true) {
      props.startedTime = {
        type: "string",
        label: "Start time(H:MM am/pm)",
        description: "The time the entry started. Defaults to the current time. Example: 8:00am.",
      };
      props.endedTime = {
        type: "string",
        label: "End time(H:MM am/pm)",
        description: "The time the entry ended. Defaults to the current time. Example: 8:00am.",
        optional: true,
      };
    }
    return props;
  },
  async run({ $ }) {

    if (this.spentDate && !isValidDate(this.spentDate)) {
      throw new ConfigurationError("Invalid spent date. Ensure format is YYYY-MM-DD");
    }

    if (this.startedTime && !isValidTime(this.startedTime)) {
      throw new ConfigurationError("Invalid start time. Ensure format is (H:MM am/pm)");
    }

    if (this.endedTime && !isValidTime(this.endedTime)) {
      throw new ConfigurationError("Invalid end time. Ensure format is (H:MM am/pm)");
    }

    const params = removeNullEntries({
      project_id: this.projectId,
      task_id: this.taskId,
      user_id: this.userId,
      spent_date: this.spentDate,
      started_time: this.startedTime?.replace(/\s/g, ""),
      ended_time: this.endedTime?.replace(/\s/g, ""),
    });
    const response = await this.harvest.createTimeEntry({
      $,
      params,
      accountId: this.accountId,
    });
    response && $.export("$summary", "Successfully created time entry");
    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
Harvest	`harvest`	`app`	This component uses the Harvest app.
Account ID	`accountId`	`string`	Select a value from the drop down menu.
Project ID	`projectId`	`string`	Select a value from the drop down menu.
Task ID	`taskId`	`string`	Select a value from the drop down menu.
Spent date (YYYY-MM-DD)	`spentDate`	`string`	The ISO 8601 formatted date on which the time entry was spent. Example: 2019-07-26
User ID	`userId`	`string`	Select a value from the drop down menu.
Specify start and end time	`specifyStartEndTime`	`boolean`	Specify start and end time

Action Authentication#

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

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