Search Account with Quickbooks Sandbox API on Edit Event (Instant) from WaiverFile API

Pipedream makes it easy to connect APIs for Quickbooks Sandbox, WaiverFile and 2,500+ other apps remarkably fast.

Trigger workflow on

Edit Event (Instant) from the WaiverFile API

Next, do this

Search Account with the Quickbooks Sandbox 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 WaiverFile trigger and Quickbooks Sandbox action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the Edit Event (Instant) trigger
1. Connect your WaiverFile account
Configure the Search Account action
1. Connect your Quickbooks Sandbox account
2. Configure include_clause
3. Configure where_clause
4. Optional- Configure order_clause
5. Optional- Configure start_position
6. Optional- Configure max_results
7. Optional- Configure minorversion
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#

Edit Event (Instant) on WaiverFile

Description:Emit new event when an existing event in WaiverFile is edited. [See the documentation](https://api.waiverfile.com/swagger/ui/index#!/Subscription/Subscription_editevent)

Version:0.0.1

Key:waiverfile-edit-event-instant

View on GitHub

WaiverFile Overview#

With the WaiverFile API, you can automate interactions with your WaiverFile account directly from Pipedream. This API provides access to manage and retrieve waivers, customer data, and events, allowing you to integrate WaiverFile with other services for streamlined workflows. You could automate the sending of waiver links, synchronize signed waivers with a database, or trigger actions based on waiver completions. The flexibility of the WaiverFile API means you can create powerful automations tailored to your business needs on Pipedream's serverless platform.

Trigger Code#

import common from "../common/base-webhook.mjs";
import sampleEmit from "./test-event.mjs";

export default {
  ...common,
  key: "waiverfile-edit-event-instant",
  name: "Edit Event (Instant)",
  description: "Emit new event when an existing event in WaiverFile is edited. [See the documentation](https://api.waiverfile.com/swagger/ui/index#!/Subscription/Subscription_editevent)",
  version: "0.0.1",
  type: "source",
  dedupe: "unique",
  methods: {
    ...common.methods,
    getEventType() {
      return "editevent";
    },
    generateMeta(body) {
      const ts = Date.parse(body.LastModified);
      return {
        id: `${body.WaiverEventID}${ts}`,
        summary: `Updated Event ${body.WaiverEventID}`,
        ts,
      };
    },
  },
  sampleEmit,
};

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
WaiverFile	`waiverfile`	`app`	This component uses the WaiverFile app.
N/A	`http`	`$.interface.http`	This component uses `$.interface.http` to generate a unique URL when the component is first instantiated. Each request to the URL will trigger the `run()` method of the component.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.

Trigger Authentication#

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

To retrieve your Site ID and Key,

Navigate to your WaiverFile account and sign in
Go to “Settings” > “API”

About WaiverFile#

WaiverFile lets your customers sign their release waivers from a computer, tablet or mobile device. From your website or at a kiosk, completing the forms is quick and easy.

Action#

Search Account on Quickbooks Sandbox

Description:Searches for accounts.

Version:0.1.1

Key:quickbooks_sandbox-search-account

View on GitHub

Quickbooks Sandbox Overview#

QuickBooks Sandbox API provides a robust platform for developers to test QuickBooks Online integrations without affecting live data. With Pipedream, you can harness this API to automate various accounting tasks, simulate financial scenarios, or validate app behavior pre-deployment. Imagine syncing invoice statuses with your CRM, triggering alerts based on financial thresholds, or reconciling payments programmatically—all in a safe, isolated environment before going live.

Action Code#

// legacy_hash_id: a_vgid15
import { axios } from "@pipedream/platform";

export default {
  key: "quickbooks_sandbox-search-account",
  name: "Search Account",
  description: "Searches for accounts.",
  version: "0.1.1",
  type: "action",
  props: {
    quickbooks_sandbox: {
      type: "app",
      app: "quickbooks_sandbox",
    },
    include_clause: {
      type: "string",
      description: "Fields to use in the include clause of the Account data query. See query language syntax, limitations, and other specifications on [Data queries](https://developer.intuit.com/app/developer/qbo/docs/develop/explore-the-quickbooks-online-api/data-queries)",
    },
    where_clause: {
      type: "string",
      description: "Filters to use in the where clause of the Account data query. Note: Multiple clauses (filters) are AND'd. The OR operation is not supported.",
    },
    order_clause: {
      type: "string",
      description: "The `order_clause` is for sorting the result. Include the Account property to sort by. The default sort order is ascending; to indicate descending sort order, include DESC, for example: `Name DESC`",
      optional: true,
    },
    start_position: {
      type: "string",
      description: "The starting count of the response for pagination.",
      optional: true,
    },
    max_results: {
      type: "string",
      description: "The number of Account entity elements in the response.",
      optional: true,
    },
    minorversion: {
      type: "string",
      description: "Use the `minorversion` query parameter in REST API requests to access a version of the API other than the generally available version. For example, to invoke minor version 1 of the JournalEntry entity, issue the following request:\n`https://quickbooks.api.intuit.com/v3/company/<realmId>/journalentry/entityId?minorversion=1`",
      optional: true,
    },
  },
  async run({ $ }) {
  //See Quickbooks API docs at: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/account#query-an-account

    if (!this.include_clause || !this.where_clause) {
      throw new Error("Must provide include_clause, where_clause parameters.");
    }

    //Prepares OrderBy clause,start position, max results parameters to be used in the request's query parameter.
    var orderClause = "";
    if (this.order_clause) {
      orderClause = ` ORDERBY  ${this.order_clause}`;
    }

    var startPosition = "";
    if (this.start_position) {
      startPosition = ` STARTPOSITION  ${this.start_position}`;
    }

    var maxResults = "";
    if (this.max_results) {
      maxResults = ` MAXRESULTS ${this.max_results}` || "";
    }

    //Prepares the request's query parameter
    const query = `select ${this.include_clause} from Account where ${this.where_clause}${orderClause}${startPosition}${maxResults}`;

    //Sends the request against Quickbooks API
    return await axios($, {
      url: `https://sandbox-quickbooks.api.intuit.com/v3/company/${this.quickbooks_sandbox.$auth.company_id}/query`,
      headers: {
        "Authorization": `Bearer ${this.quickbooks_sandbox.$auth.oauth_access_token}`,
        "accept": "application/json",
        "content-type": "application/octet-stream",
      },
      params: {
        minorversion: this.minorversion,
        query,
      },
    });
  },
};

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
Quickbooks Sandbox	`quickbooks_sandbox`	`app`	This component uses the Quickbooks Sandbox app.
include_clause	`include_clause`	`string`	Fields to use in the include clause of the Account data query. See query language syntax, limitations, and other specifications on Data queries
where_clause	`where_clause`	`string`	Filters to use in the where clause of the Account data query. Note: Multiple clauses (filters) are AND'd. The OR operation is not supported.
order_clause	`order_clause`	`string`	The `order_clause` is for sorting the result. Include the Account property to sort by. The default sort order is ascending; to indicate descending sort order, include DESC, for example: `Name DESC`
start_position	`start_position`	`string`	The starting count of the response for pagination.
max_results	`max_results`	`string`	The number of Account entity elements in the response.
minorversion	`minorversion`	`string`	Use the `minorversion` query parameter in REST API requests to access a version of the API other than the generally available version. For example, to invoke minor version 1 of the JournalEntry entity, issue the following request: `https://quickbooks.api.intuit.com/v3/company/<realmId>/journalentry/entityId?minorversion=1`

Action Authentication#

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

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

com.intuit.quickbooks.accountingopenidprofileemail

Search Account with Quickbooks Sandbox API on Edit Event (Instant) from WaiverFile API

Pipedream makes it easy to connect APIs for Quickbooks Sandbox, WaiverFile and 2,500+ other apps remarkably fast.

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

Developers ♥ Pipedream

1-24of2,500+apps by most popular

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