[Date/Time] Compare Dates with Formatting API on New Lead from Visitor Queue API

Pipedream makes it easy to connect APIs for Formatting, Visitor Queue and 2,000+ other apps remarkably fast.

Trigger workflow on

New Lead from the Visitor Queue API

Next, do this

[Date/Time] Compare Dates with the Formatting API

No credit card required

▶

Watch us build a workflow

4 min

Watch now ➜

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

Developers ♥ Pipedream

Getting Started#

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

Select this integration
Configure the New Lead trigger
1. Connect your Visitor Queue account
2. Configure Polling interval
3. Select a Data Views
Configure the [Date/Time] Compare Dates action
1. Connect your Formatting account
2. Configure Start Date
3. Optional- Select a Input Format
4. Configure End Date
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 Lead on Visitor Queue

Description:Emit new event when a new Waiver sign is received. [See docs here](https://docs.visitorqueue.com/#4f021159-baae-e19d-bb7f-91a915e5b4ea)

Version:0.0.3

Key:visitor_queue-new-lead

View on GitHub

Visitor Queue Overview#

The Visitor Queue API lets you track and identify businesses that visit your website, providing valuable data for lead generation and marketing analytics. By leveraging this API on Pipedream, you can automate tasks such as scoring leads, syncing data with CRM systems, and engaging with potential customers through targeted outreach. The ability to connect with hundreds of apps on Pipedream allows for powerful, automated workflows that can enrich your sales pipeline and optimize your marketing strategies.

Trigger Code#

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

export default {
  key: "visitor_queue-new-lead",
  name: "New Lead",
  description: "Emit new event when a new Waiver sign is received. [See docs here](https://docs.visitorqueue.com/#4f021159-baae-e19d-bb7f-91a915e5b4ea)",
  version: "0.0.3",
  dedupe: "unique",
  type: "source",
  props: {
    visitor_queue,
    db: "$.service.db",
    timer: {
      label: "Polling interval",
      description: "Pipedream will poll the Visitor Queue API on this schedule",
      type: "$.interface.timer",
      default: {
        intervalSeconds: DEFAULT_POLLING_SOURCE_TIMER_INTERVAL,
      },
    },
    dataViews: {
      propDefinition: [
        visitor_queue,
        "dataViews",
      ],
    },
  },
  methods: {
    _getLastTime() {
      return this.db.get("lastTime");
    },
    _setLastTime(lastTime) {
      this.db.set("lastTime", lastTime);
    },
    getDataToEmit({
      id, name, last_visited_at,
    }) {
      return {
        id,
        summary: `New lead (${name})`,
        ts: new Date(last_visited_at).getTime(),
      };
    },
    async processEvent({
      params, lastTime,
    }) {
      const records = this.visitor_queue.paginate({
        fn: this.visitor_queue.listLeads,
        params,
      });

      for await (const record of records) {
        if (moment(record.last_visited_at).isAfter(lastTime))
          this._setLastTime(record.last_visited_at);

        this.$emit(record, this.getDataToEmit(record));
      }
    },
  },
  hooks: {
    async activate() {
      const lastTime = this._getLastTime();
      const leads = await this.visitor_queue.listLeads({
        params: {
          ga_view_id: this.dataViews,
          min_date: lastTime,
          per_page: 20,
        },
      });

      for (const lead of leads) {
        if (!lastTime || moment(lastTime).isAfter(lead.last_visited_at)) {
          this._setLastTime(lead.last_visited_at);
        }
        this.$emit(lead, this.getDataToEmit(lead));
      }
    },
  },
  async run() {
    const lastTime = this._getLastTime();
    const params = {
      ga_view_id: this.dataViews,
      min_date: lastTime,
    };

    return this.processEvent({
      params,
      lastTime,
    });
  },
};

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
Visitor Queue	`visitor_queue`	`app`	This component uses the Visitor Queue app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
Polling interval	`timer`	`$.interface.timer`	Pipedream will poll the Visitor Queue API on this schedule
Data Views	`dataViews`	`string`	Select a value from the drop down menu.

Trigger Authentication#

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

To get your API Key, go to the integrations page and in the "Utilize the Visitor Queue API" card, click "Generate API Key".

About Visitor Queue#

Visitor Queue is an advanced B2B lead generation software that identifies the name, contact details & user data of the businesses that visit your website.

Action#

[Date/Time] Compare Dates on Formatting

Description:Get the duration between two dates in days, hours, minutes, and seconds along with checking if they are the same.

Version:0.0.4

Key:formatting-compare-dates

View on GitHub

Action Code#

import { defineAction } from "@pipedream/types";
import commonDateTime from "../../common/date-time/commonDateTime.mjs";
import app from "../../app/formatting.app.mjs";
import { DATE_TIME_UNITS } from "../../common/date-time/dateTimeUnits.mjs";
export default defineAction({
    ...commonDateTime,
    name: "[Date/Time] Compare Dates",
    description: "Get the duration between two dates in days, hours, minutes, and seconds along with checking if they are the same.",
    key: "formatting-compare-dates",
    version: "0.0.4",
    type: "action",
    props: {
        ...commonDateTime.props,
        inputDate: {
            propDefinition: [
                app,
                "inputDate",
            ],
            label: "Start Date",
            description: "Enter start date string, in the format defined in `Input Format`. If the start date is after the end date, these dates will be swapped and in the output `datesSwapped` will be set to `true`.",
        },
        endDate: {
            propDefinition: [
                app,
                "inputDate",
            ],
            label: "End Date",
            description: "Enter end date string, in the format defined in `Input Format`. Timezone is assumed the same for both dates if not explicitly set.",
        },
    },
    async run({ $ }) {
        const startDateObj = this.getDateFromInput(this.inputDate);
        const endDateObj = this.getDateFromInput(this.endDate);
        const startValue = startDateObj.valueOf();
        const endValue = endDateObj.valueOf();
        const datesSwapped = startValue > endValue;
        let result = "equal";
        let remainingValue = Math.abs(endValue - startValue);
        if (remainingValue) {
            const arrResults = [];
            const arrUnits = Object.entries(DATE_TIME_UNITS).sort((a, b) => b[1] - a[1]);
            for (const [word, unit,] of arrUnits) {
                const amount = Math.floor(remainingValue / unit);
                if (amount) {
                    arrResults.push(`${amount} ${amount === 1
                        ? word
                        : `${word}s`}`);
                    remainingValue %= unit;
                    if (!remainingValue)
                        break;
                }
            }
            result = arrResults.join(", ");
        }
        $.export("$summary", "Successfully compared dates");
        return {
            datesSwapped,
            result,
        };
    },
});

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
Formatting	`app`	`app`	This component uses the Formatting app.
Start Date	`inputDate`	`string`	Enter start date string, in the format defined in `Input Format`. If the start date is after the end date, these dates will be swapped and in the output `datesSwapped` will be set to `true`.
Input Format	`inputFormat`	`string`	Select a value from the drop down menu:`{ "label": "Sun Jan 22 23:04:05 -0000 2006", "value": "ddd MMM DD HH:mm:ss Z YYYY" }{ "label": "January 22 2006 23:04:05", "value": "MMMM DD YYYY HH:mm:ss" }{ "label": "January 22 2006", "value": "MMMM DD YYYY" }{ "label": "Jan 22 2006", "value": "MMM DD YYYY" }{ "label": "2006-01-22T23:04:05", "value": "YYYY-MM-DDTHH:mm:ss" }{ "label": "2006-01-22T23:04:05-0000", "value": "YYYY-MM-DDTHH:mm:ss" }{ "label": "2006-01-22 23:04:05 -0000", "value": "YYYY-MM-DD HH:mm:ss Z" }{ "label": "2006-01-22 23:04", "value": "YYYY-MM-DD HH:mm" }{ "label": "2006-01-22", "value": "YYYY-MM-DD" }{ "label": "01-22-2006", "value": "MM-DD-YYYY" }{ "label": "01/22/2006", "value": "MM/DD/YYYY" }{ "label": "01/22/06", "value": "MM/DD/YY" }{ "label": "22-01-2006", "value": "DD-MM-YYYY" }{ "label": "22/01/2006", "value": "DD/MM/YYYY" }{ "label": "22/01/06", "value": "DD/MM/YY" }{ "label": "1137971045", "value": "Unix time (seconds)" }{ "label": "1137971045000", "value": "Unix time (milliseconds)" }`
End Date	`endDate`	`string`	Enter end date string, in the format defined in `Input Format`. Timezone is assumed the same for both dates if not explicitly set.