Query Projects with Tableau API on New Leave Request Created from Breathe API

Pipedream makes it easy to connect APIs for Tableau, Breathe and 2,700+ other apps remarkably fast.

Trigger workflow on

New Leave Request Created from the Breathe API

Next, do this

Query Projects with the Tableau 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 Breathe trigger and Tableau action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Leave Request Created trigger
1. Connect your Breathe account
2. Configure timer
3. Optional- Select one or more Employee IDs
Configure the Query Projects action
1. Connect your Tableau account
2. Select a Site 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 Leave Request Created on Breathe

Description:Emit new event when a new employee leave request is created in Breathe. [See the documentation](https://developer.breathehr.com/examples#!/employees/GET_version_employees_id_leave_requests_json)

Version:0.0.1

Key:breathe-new-leave-request-created

View on GitHub

Trigger Code#

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

export default {
  ...common,
  key: "breathe-new-leave-request-created",
  name: "New Leave Request Created",
  description: "Emit new event when a new employee leave request is created in Breathe. [See the documentation](https://developer.breathehr.com/examples#!/employees/GET_version_employees_id_leave_requests_json)",
  version: "0.0.1",
  type: "source",
  dedupe: "unique",
  props: {
    ...common.props,
    employeeIds: {
      propDefinition: [
        common.props.breathe,
        "employeeId",
      ],
      type: "string[]",
      label: "Employee IDs",
      description: "Return leave requests for the selected employees only. If no employees are selected, leave requests for all employees will be returned.",
      optional: true,
    },
  },
  methods: {
    ...common.methods,
    getTsField() {
      return "created_at";
    },
    getResourceFn() {
      return this.breathe.listLeaveRequests;
    },
    getArgs(lastTs) {
      const args = {
        params: {
          startDate: lastTs,
        },
      };
      if (this.employeeIds?.length === 1) {
        args.params.employee_id = this.employeeIds[0];
      }
      return args;
    },
    getResourceKey() {
      return "leave_requests";
    },
    isRelevant(leaveRequest) {
      return !this.employeeIds?.length || this.employeeIds.includes(leaveRequest.employee.id);
    },
    generateMeta(leaveRequest) {
      return {
        id: leaveRequest.id,
        summary: `New Leave Request ID: ${leaveRequest.id}`,
        ts: Date.parse(leaveRequest.created_at),
      };
    },
  },
};

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
Breathe	`breathe`	`app`	This component uses the Breathe app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`
Employee IDs	`employeeIds`	`string[]`	Select a value from the drop down menu.

Trigger Authentication#

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

About Breathe#

HR Software That Puts People First.

Action#

Query Projects on Tableau

Description:Returns a list of projects on the specified site. [See the documentation](https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref_projects.htm)

Version:0.0.1

Key:tableau-query-projects

View on GitHub

Tableau Overview#

The Tableau API allows you to tap into the robust data visualization and business intelligence capabilities of Tableau. Within Pipedream, you can leverage this API to automate reporting, manage users, update data sources, and extract insights. This enables you to integrate Tableau's analytics with other services, streamlining your data workflows and ensuring your dashboards remain up-to-date with minimal manual effort.

Action Code#

import app from "../../tableau.app.mjs";
import constants from "../../common/constants.mjs";

export default {
  key: "tableau-query-projects",
  name: "Query Projects",
  description: "Returns a list of projects on the specified site. [See the documentation](https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref_projects.htm)",
  version: "0.0.1",
  type: "action",
  props: {
    app,
    siteId: {
      propDefinition: [
        app,
        "siteId",
      ],
    },
  },
  async run({ $ }) {
    const {
      app,
      siteId,
    } = this;

    const projects = await app.paginate({
      resourcesFn: app.listProjects,
      resourcesFnArgs: {
        $,
        siteId,
        params: {
          pageSize: constants.DEFAULT_LIMIT,
        },
      },
      resourceName: "projects.project",
    });

    $.export("$summary", `Successfully retrieved \`${projects.length}\` project(s)`);
    return projects;
  },
};

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
Tableau	`app`	`app`	This component uses the Tableau app.
Site ID	`siteId`	`string`	Select a value from the drop down menu.

Action Authentication#

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

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

Query Projects with Tableau API on New Leave Request Created from Breathe API

Pipedream makes it easy to connect APIs for Tableau, Breathe and 2,700+ other apps remarkably fast.

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

Developers ♥ Pipedream

1-24of2,700+apps by most popular

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