Get Form Submissions with Jotform API on New Time Entry from TimeCamp API

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

Trigger workflow on

New Time Entry from the TimeCamp API

Next, do this

Get Form Submissions with the Jotform 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 TimeCamp trigger and Jotform 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 trigger
1. Connect your TimeCamp account
2. Configure timer
Configure the Get Form Submissions action
1. Connect your Jotform account
2. Optional- Select a Team
3. Select a Form
4. Configure Max Items
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 on TimeCamp

Description:Emit new event on each created time entry.

Version:0.0.3

Key:timecamp-new-time-entry

View on GitHub

TimeCamp Overview#

TimeCamp's API unlocks the potential to automate and integrate time tracking data with a myriad of services and platforms. By leveraging Pipedream's capabilities, you can create custom workflows that respond to events in TimeCamp, such as new time entries, projects, or tasks. These workflows can then trigger actions in other apps, or even process and analyze time tracking data to provide insights and streamline operations.

Trigger Code#

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

export default {
  name: "New Time Entry",
  version: "0.0.3",
  key: "timecamp-new-time-entry",
  description: "Emit new event on each created time entry.",
  type: "source",
  dedupe: "unique",
  props: {
    timecamp,
    db: "$.service.db",
    timer: {
      type: "$.interface.timer",
      static: {
        intervalSeconds: DEFAULT_POLLING_SOURCE_TIMER_INTERVAL,
      },
    },
  },
  methods: {
    _getLastSyncDate() {
      return this.db.get("lastSyncDate");
    },
    _setLastSyncDate(lastSyncDate) {
      return this.db.set("lastSyncDate", lastSyncDate);
    },
    emitEvent(data) {
      this.$emit(data, {
        id: data.id,
        summary: `New time entry with id ${data.id}`,
        ts: Date.parse(data.add_date),
      });
    },
    async emitTimeEntries() {
      const lastSyncDate = this._getLastSyncDate();

      const timeEntries = await this.timecamp.getTimeEntries({
        params: {
          from: lastSyncDate,
          to: dayjs().format("YYYY-MM-DD"),
        },
      });

      timeEntries.reverse().forEach(this.emitEvent);
    },
  },
  hooks: {
    async deploy() {
      const lastSyncDate = dayjs().subtract(1, "month")
        .format("YYYY-MM-DD");

      this._setLastSyncDate(lastSyncDate);

      await this.emitTimeEntries();
    },
  },
  async run() {
    await this.emitTimeEntries();

    const lastSyncDate = dayjs().format("YYYY-MM-DD");

    this._setLastSyncDate(lastSyncDate);
  },
};

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
TimeCamp	`timecamp`	`app`	This component uses the TimeCamp app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`

Trigger Authentication#

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

To get your API token,

Sign in to your TimeCamp account
Click on your avatar in the upper-right corner
Select your name to navigate to your Profile’s settings

About TimeCamp#

TimeCamp helps you and your team to track time. Automatic time-tracking software that tracks websites and applications usage, projects and helps you understand how your time is spent.

Action#

Get Form Submissions on Jotform

Description:Gets a list of form responses [See the docs here](https://api.jotform.com/docs/#form-id-submissions)

Version:0.1.3

Key:jotform-get-form-submissions

View on GitHub

Jotform Overview#

Jotform’s API is a powerhouse for automating form and survey data management. With Pipedream, harness this API to trigger workflows from new form submissions, manipulate and analyze your form data, and sync it across various platforms. Think streamlined data entry to CRMs, instant notifications for new leads or feedback, and timely data backups to cloud storage.

Action Code#

import common from "../common.mjs";

export default {
  ...common,
  key: "jotform-get-form-submissions",
  name: "Get Form Submissions",
  description: "Gets a list of form responses [See the docs here](https://api.jotform.com/docs/#form-id-submissions)",
  version: "0.1.3",
  type: "action",
  props: {
    ...common.props,
    teamId: {
      propDefinition: [
        common.props.jotform,
        "teamId",
      ],
    },
    formId: {
      propDefinition: [
        common.props.jotform,
        "formId",
        (c) => ({
          teamId: c.teamId,
        }),
      ],
    },
    max: {
      propDefinition: [
        common.props.jotform,
        "max",
      ],
    },
  },
  async run({ $ }) {
    const params = {
      $,
      max: this.max,
      formId: this.formId,
      teamId: this.teamId,
    };
    const submissions = await this.paginate(this.jotform.getFormSubmissions.bind(this), params);
    const results = [];
    for await (const submission of submissions) {
      results.push(submission);
    }
    $.export("$summary", `Successfully retrieved ${results.length} form submission${results.length === 1
      ? "s"
      : ""}`);
    return results;
  },
};

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
Jotform	`jotform`	`app`	This component uses the Jotform app.
Team	`teamId`	`string`	Select a value from the drop down menu.
Form	`formId`	`string`	Select a value from the drop down menu.
Max Items	`max`	`integer`	Maximum number of items to return

Try it

Create Task with TimeCamp API on New Submission (Instant) from Jotform API

Jotform + TimeCamp

Try it

Get Form Submissions with Jotform API on New Task from TimeCamp API

TimeCamp + Jotform

Try it

Get Monthly User Usage with Jotform API on New Task from TimeCamp API

TimeCamp + Jotform

Try it

Get User Submissions with Jotform API on New Task from TimeCamp API

TimeCamp + Jotform

Try it

Popular Triggers#

New Task from the TimeCamp API

Emit new event on each created task.

Try it

New Time Entry from the TimeCamp API

Emit new event on each created time entry.

Try it

New Submission (Instant) from the Jotform API

Emit new event when a form is submitted

Try it

Popular Actions#

Create Task with the TimeCamp API

Creates a task. See docs here

Try it

Create Time Entry with the TimeCamp API

Creates a time entry. See docs here

Try it

Get Form Submissions with the Jotform API

Gets a list of form responses See the docs here

Try it

Get Monthly User Usage with the Jotform API

Gets number of form submissions received this month. Also, get number of SSL form submissions, payment form submissions and upload space used by user See the docs here

Try it

Get User Submissions with the Jotform API

Gets a list of all submissions for all forms on the account See the docs here

Try it