Search Account with Quickbooks Sandbox API on Order Status Updated (Instant) from Printful API

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

Trigger workflow on

Order Status Updated (Instant) from the Printful 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 Printful 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 Order Status Updated (Instant) trigger
1. Connect your Printful account
2. Configure alert
3. Select a Store ID
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#

Order Status Updated (Instant) on Printful

Description:Emit new event when the status of an existing Printful order is updated.

Version:0.0.1

Key:printful-order-status-updated-instant

View on GitHub

Printful Overview#

The Printful API unlocks the ability to automate custom print-on-demand operations within Pipedream's serverless platform. With this API, you can streamline the process of managing products, submitting orders, and syncing inventory. Building workflows around the Printful API on Pipedream can significantly reduce manual intervention, connect your e-commerce data with other services, and enhance customer experiences through timely fulfillment and updates.

Trigger Code#

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

export default {
  ...common,
  key: "printful-order-status-updated-instant",
  name: "Order Status Updated (Instant)",
  description: "Emit new event when the status of an existing Printful order is updated.",
  version: "0.0.1",
  type: "source",
  dedupe: "unique",
  methods: {
    ...common.methods,
    getEventType() {
      return [
        "order_updated",
      ];
    },
    getModelField() {
      return "order";
    },
    getSummary(body) {
      return `Order ${body.data.order.id} status updated to ${body.data.order.status}`;
    },
  },
  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
Printful	`printful`	`app`	This component uses the Printful 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.
Store ID	`storeId`	`string`	Select a value from the drop down menu.

Trigger Authentication#

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

Generate Printful API Token by on Printful Developer Page > Tokens > Add new Token.
Required scopes for the API Token:

View and manage orders of the authorized store
View and manage store products
View and manage store webhooks

About Printful#

Easy print-on-demand drop shipping and fulfillment warehouse services

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 Order Status Updated (Instant) from Printful API

Pipedream makes it easy to connect APIs for Quickbooks Sandbox, Printful 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