Update Item with QuickBooks API on New Requests from HTTP / Webhook API

Pipedream makes it easy to connect APIs for QuickBooks, HTTP / Webhook and 2,400+ other apps remarkably fast.

Trigger workflow on

New Requests from the HTTP / Webhook API

Next, do this

Update Item with the QuickBooks 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 HTTP / Webhook trigger and QuickBooks action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Requests trigger
1. Optional- Configure Body Only
2. Optional- Configure Response Status Code
3. Optional- Configure Response Content-Type
4. Optional- Configure Response Body
5. Connect your HTTP / Webhook account
Configure the Update Item action
1. Connect your QuickBooks account
2. Select a Item ID
3. Configure Name
4. Optional- Configure Track Quantity on Hand
5. Optional- Configure Quantity on Hand
6. Optional- Select a Income Account Ref Value
7. Optional- Select a Type
8. Optional- Select a Asset Account Ref Value
9. Optional- Configure Inventory Start Date
10. Optional- Select a Expense Account Ref Value
11. Optional- Configure Sku
12. Optional- Configure Sales Tax Included
13. Optional- Select a Sales Tax Code Ref Value
14. Optional- Configure Purchase Tax Included
15. Optional- Configure Description
16. Optional- Configure Abatement Rate
17. Optional- Configure Reverse Charge Rate
18. Optional- Configure Sub Item
19. Optional- Configure Taxable
20. Optional- Configure UQC Display Text
21. Optional- Configure Reorder Point
22. Optional- Configure Purchase Description
23. Optional- Select a Pref Vendor Ref Value
24. Optional- Configure Active
25. Optional- Configure UQC ID
26. Optional- Select a Purchase Tax Code Ref Value
27. Optional- Configure Service Type
28. Optional- Configure Purchase Cost
29. Optional- Configure Unit Price
30. Optional- Select a Tax Classification ID
31. Optional- Select a Parent Ref Value
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 Requests on HTTP / Webhook

Description:Get a URL and emit the full HTTP event on every request (including headers and query parameters). You can also configure the HTTP response code, body, and more.

Version:0.1.1

Key:http-new-requests

View on GitHub

HTTP / Webhook Overview#

Build, test, and send HTTP requests without code using your Pipedream workflows. The HTTP / Webhook action is a tool to build HTTP requests with a Postman-like graphical interface.

Point and click HTTP requests

Define the target URL, HTTP verb, headers, query parameters, and payload body without writing custom code.

$A screenshot of Pipedream's HTTP Request Configuration interface with a GET request type selected. The request URL is set to 'https://api.openai.com/v1/models'. The 'Auth' tab is highlighted, indicating that authentication is required for this request. In the headers section, there are two headers configured: 'User-Agent' is set to 'pipedream/1', and 'Authorization' is set to 'Bearer {{openai_api_key}}', showing how the OpenAI account's API key is dynamically inserted into the headers to handle authentication automatically.$

Here's an example workflow that uses the HTTP / Webhook action to send an authenticated API request to OpenAI.

Focus on integrating, not authenticating

This action can also use your connected accounts with third-party APIs. Selecting an integrated app will automatically update the request’s headers to authenticate with the app properly, and even inject your token dynamically.

Pipedream integrates with thousands of APIs, but if you can’t find a Pipedream integration simply use Environment Variables in your request headers to authenticate with.

Compatible with no code actions or Node.js and Python

The HTTP/Webhook action exports HTTP response data for use in subsequent workflow steps, enabling easy data transformation, further API calls, database storage, and more.

Response data is available for both coded (Node.js, Python) and no-code steps within your workflow.

Trigger Code#

import http from "../../http.app.mjs";

// Core HTTP component
export default {
  key: "http-new-requests",
  name: "New Requests",
  description: "Get a URL and emit the full HTTP event on every request (including headers and query parameters). You can also configure the HTTP response code, body, and more.",
  version: "0.1.1",
  type: "source",
  props: {
    httpInterface: {
      type: "$.interface.http",
      customResponse: true,
    },
    emitBodyOnly: {
      type: "boolean",
      label: "Body Only",
      description: "This source emits an event representing the full HTTP request by default. Select `true` to emit the body only.",
      optional: true,
      default: false,
    },
    resStatusCode: {
      type: "string",
      label: "Response Status Code",
      description: "The status code to return in the HTTP response",
      optional: true,
      default: "200",
    },
    resContentType: {
      type: "string",
      label: "Response Content-Type",
      description: "The `Content-Type` of the body returned in the HTTP response",
      optional: true,
      default: "application/json",
    },
    resBody: {
      type: "string",
      label: "Response Body",
      description: "The body to return in the HTTP response",
      optional: true,
      default: "{ \"success\": true }",
    },
    http,
  },
  async run(event) {
    const summary = `${event.method} ${event.path}`;

    this.httpInterface.respond({
      status: this.resStatusCode,
      body: this.resBody,
      headers: {
        "content-type": this.resContentType,
      },
    });

    if (this.emitBodyOnly) {
      this.$emit(event.body, {
        summary,
      });
    } else {
      this.$emit(event, {
        summary,
      });
    }
  },
};

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
N/A	`httpInterface`	`$.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.
Body Only	`emitBodyOnly`	`boolean`	This source emits an event representing the full HTTP request by default. Select `true` to emit the body only.
Response Status Code	`resStatusCode`	`string`	The status code to return in the HTTP response
Response Content-Type	`resContentType`	`string`	The `Content-Type` of the body returned in the HTTP response
Response Body	`resBody`	`string`	The body to return in the HTTP response
HTTP / Webhook	`http`	`app`	This component uses the HTTP / Webhook app.

Trigger Authentication#

The HTTP / Webhook API does not require authentication.

About HTTP / Webhook#

Get a unique URL where you can send HTTP or webhook requests

Action#

Update Item on QuickBooks

Description:Updates an item. [See the documentation](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/item#full-update-an-item)

Version:0.0.1

Key:quickbooks-update-item

View on GitHub

QuickBooks Overview#

The QuickBooks API allows for streamlined financial management within Pipedream's ecosystem, enabling automated accounting and data syncing across various platforms. With this API, you can manipulate invoices, manage sales receipts, handle expenses, and synchronize customer data. It's a robust tool for financial oversight and automation that can save time and reduce errors for businesses of all sizes.

Action Code#

import quickbooks from "../../quickbooks.app.mjs";
import { ConfigurationError } from "@pipedream/platform";

export default {
  key: "quickbooks-update-item",
  name: "Update Item",
  description: "Updates an item. [See the documentation](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/item#full-update-an-item)",
  version: "0.0.1",
  type: "action",
  props: {
    quickbooks,
    itemId: {
      propDefinition: [
        quickbooks,
        "itemId",
      ],
    },
    name: {
      type: "string",
      label: "Name",
      description: "Name of the item. This value must be unique.",
    },
    trackQtyOnHand: {
      type: "boolean",
      label: "Track Quantity on Hand",
      description: "True if there is quantity on hand to be tracked. Once this value is true, it cannot be updated to false. Applicable for items of type `Inventory`. Not applicable for `Service` or `NonInventory` item types.",
      optional: true,
    },
    qtyOnHand: {
      type: "string",
      label: "Quantity on Hand",
      description: "Current quantity of the `Inventory` items available for sale. Not used for `Service` or `NonInventory` type items. Required for `Inventory` type items.",
      optional: true,
    },
    incomeAccountRefValue: {
      type: "string",
      label: "Income Account Ref Value",
      description: "Reference to the posting account, that is, the account that records the proceeds from the sale of this item. Must be an account with account type of `Sales of Product Income`. Query the Account name list resource to determine the appropriate Account object for this reference. Use `Account.Id` from that object for `IncomeAccountRef.value`. See specifications for the IncomeAccountRef parameters in the [Create an item page](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/item#create-an-item).",
      propDefinition: [
        quickbooks,
        "accountIds",
      ],
    },
    type: {
      type: "string",
      label: "Type",
      description: "Classification that specifies the use of this item. See the description at the top of the [Item entity page](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/item) for details about supported item types. See specifications for the type parameter in the [Create an item page](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/item#create-an-item).",
      optional: true,
      options: [
        "Inventory",
        "Group",
        "Service",
        "NonInventory",
      ],
    },
    assetAccountRefValue: {
      type: "string",
      label: "Asset Account Ref Value",
      description: "Required for Inventory item types. Reference to the Inventory Asset account that tracks the current value of the inventory. If the same account is used for all inventory items, the current balance of this account will represent the current total value of the inventory. Must be an account with account type of `Other Current Asset`. Query the Account name list resource to determine the appropriate Account object for this reference. Use `Account.Id` from that object for `AssetAccountRef.value`.",
      propDefinition: [
        quickbooks,
        "accountIds",
      ],
    },
    invStartDate: {
      type: "string",
      label: "Inventory Start Date",
      description: "Date of opening balance for the inventory transaction. Required when creating an `Item.Type=Inventory`. Required for `Inventory` item types.",
      optional: true,
    },
    expenseAccountRefValue: {
      type: "string",
      label: "Expense Account Ref Value",
      description: "Reference to the expense account used to pay the vendor for this item. Must be an account with account type of `Cost of Goods Sold`. Query the Account name list resource to determine the appropriate Account object for this reference. Use `Account.Id` from that object for `ExpenseAccountRef.value`. See specifications for the ExpenseAccountRef parameters in the [Create an item page](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/item#create-an-item).",
      propDefinition: [
        quickbooks,
        "accountIds",
      ],
    },
    sku: {
      type: "string",
      label: "Sku",
      description: "The stock keeping unit (SKU) for this Item. This is a company-defined identifier for an item or product used in tracking inventory.",
      optional: true,
    },
    salesTaxIncluded: {
      type: "boolean",
      label: "Sales Tax Included",
      description: "True if the sales tax is included in the item amount, and therefore is not calculated for the transaction.",
      optional: true,
    },
    salesTaxCodeRefValue: {
      label: "Sales Tax Code Ref Value",
      description: "ID of the referenced sales tax code  for the Sales item. Applicable to Service and Sales item types only. Query the TaxCode name list resource to determine the appropriate TaxCode object for this reference. Use `TaxCode.Id` from that object for `SalesTaxCodeRef.value`.",
      propDefinition: [
        quickbooks,
        "taxCodeId",
      ],
    },
    purchaseTaxIncluded: {
      type: "boolean",
      label: "Purchase Tax Included",
      description: "True if the purchase tax is included in the item amount, and therefore is not calculated for the transaction.",
      optional: true,
    },
    description: {
      type: "string",
      label: "Description",
      description: "Description of the item.",
      optional: true,
    },
    abatementRate: {
      type: "string",
      label: "Abatement Rate",
      description: "Sales tax abatement rate for India locales.",
      optional: true,
    },
    reverseChargeRate: {
      type: "string",
      label: "Reverse Charge Rate",
      description: "Sales tax reverse charge rate for India locales.",
      optional: true,
    },
    subItem: {
      type: "boolean",
      label: "Sub Item",
      description: "If true, this is a sub item. If false or null, this is a top-level item. Creating inventory hierarchies with traditional inventory items is being phased out in lieu of using categories and sub categories.",
      optional: true,
    },
    taxable: {
      type: "boolean",
      label: "Taxable",
      description: "If true, transactions for this item are taxable. Applicable to US companies, only.",
      optional: true,
    },
    UqcDisplayText: {
      type: "string",
      label: "UQC Display Text",
      description: "Text to be displayed on customer's invoice to denote the Unit of Measure (instead of the standard code).",
      optional: true,
    },
    reorderPoint: {
      type: "string",
      label: "Reorder Point",
      description: "The minimum quantity of a particular inventory item that you need to restock at any given time. The ReorderPoint value cannot be set to null for sparse updates(sparse=true). It can be set to null only for full updates.",
      optional: true,
    },
    purchaseDesc: {
      type: "string",
      label: "Purchase Description",
      description: "Purchase description for the item.",
      optional: true,
    },
    prefVendorRefValue: {
      type: "string",
      label: "Pref Vendor Ref Value",
      description: "Pref vendor ref value",
      propDefinition: [
        quickbooks,
        "vendorIds",
      ],
    },
    active: {
      type: "boolean",
      label: "Active",
      description: "If true, the object is currently enabled for use by QuickBooks.",
      optional: true,
    },
    UqcId: {
      type: "string",
      label: "UQC ID",
      description: "ID of Standard Unit of Measure (UQC:Unique Quantity Code) of the item according to GST rule.",
      optional: true,
    },
    purchaseTaxCodeRefValue: {
      label: "Purchase Tax Code Ref Value",
      description: "The ID for the referenced purchase tax code object as found in the Id field of the object payload. \n\nReference to the purchase tax code for the item. Applicable to Service, Other Charge, and Product (Non-Inventory) item types. Query the TaxCode name list resource to determine the appropriate TaxCode object for this reference. Use `TaxCode.Id` from that object for `PurchaseTaxCodeRef.value`.",
      propDefinition: [
        quickbooks,
        "taxCodeId",
      ],
    },
    serviceType: {
      type: "string",
      label: "Service Type",
      description: "Sales tax service type for India locales.",
      optional: true,
    },
    purchaseCost: {
      type: "string",
      label: "Purchase Cost",
      description: "Amount paid when buying or ordering the item, as expressed in the home currency.",
      optional: true,
    },
    unitPrice: {
      type: "string",
      label: "Unit Price",
      description: "Corresponds to the Price/Rate column on the QuickBooks Online UI to specify either unit price, a discount, or a tax rate for item. If used for unit price, the monetary value of the service or product, as expressed in the home currency. If used for a discount or tax rate, express the percentage as a fraction. For example, specify `0.4` for 40% tax",
      optional: true,
    },
    taxClassificationRefValue: {
      description: "The ID for the referenced Tax classification object as found in the Id field of the object payload.\n\nTax classification segregates different items into different classifications and the tax classification is one of the key parameters to determine appropriate tax on transactions involving items. Tax classifications are sourced by either tax governing authorities as in India/Malaysia or externally like Exactor. 'Fuel', 'Garments' and 'Soft drinks' are a few examples of tax classification in layman terms. User can choose a specific tax classification for an item while creating it. A level 1 tax classification cannot be associated to an Item",
      propDefinition: [
        quickbooks,
        "taxClassificationId",
      ],
    },
    parentRefValue: {
      label: "Parent Ref Value",
      description: "The ID for the referenced parent item object as found in the Id field of the object payload. \n\nThe immediate parent of the sub item in the hierarchical Category:Sub-category list. If SubItem is true, then ParenRef is required. Query the Item name list resource to determine the appropriate object for this reference. Use `Item.Id` from that object for `ParentRef.value`.",
      optional: true,
      propDefinition: [
        quickbooks,
        "itemId",
      ],
    },
  },
  methods: {
    async getSyncToken($) {
      const { Item: item } = await this.quickbooks.getItem({
        $,
        itemId: this.itemId,
      });
      return item.SyncToken;
    },
  },
  async run({ $ }) {
    if (!this.itemId || !this.name) {
      throw new ConfigurationError("Must provide itemId and name parameters.");
    }

    const data = {
      sparse: true,
      Id: this.itemId,
      Name: this.name,
      QtyOnHand: this.qtyOnHand,
      SyncToken: await this.getSyncToken($),
      IncomeAccountRef: this.incomeAccountRefValue && {
        value: this.incomeAccountRefValue,
      },
      Type: this.type,
      AssetAccountRef: this.assetAccountRefValue && {
        value: this.assetAccountRefValue,
      },
      InvStartDate: this.invStartDate,
      ExpenseAccountRef: this.expenseAccountRefValue && {
        value: this.expenseAccountRefValue,
      },
      Sku: this.sku,
      SalesTaxIncluded: this.salesTaxIncluded,
      TrackQtyOnHand: this.trackQtyOnHand,
      SalesTaxCodeRef: this.salesTaxCodeRefValue && {
        value: this.salesTaxCodeRefValue,
      },
      PurchaseTaxIncluded: this.purchaseTaxIncluded,
      Description: this.description,
      AbatementRate: this.abatementRate,
      ReverseChargeRate: this.reverseChargeRate,
      SubItem: this.subItem,
      Taxable: this.taxable,
      UQCDisplayText: this.UqcDisplayText,
      ReorderPoint: this.reorderPoint,
      PurchaseDesc: this.purchaseDesc,
      PrefVendorRef: this.prefVendorRefValue && {
        value: this.prefVendorRefValue,
      },
      Active: this.active,
      UQCId: this.UqcId,
      PurchaseTaxCodeRef: this.purchaseTaxCodeRefValue && {
        value: this.purchaseTaxCodeRefValue,
      },
      ServiceType: this.serviceType,
      PurchaseCost: this.purchaseCost,
      UnitPrice: this.unitPrice,
      TaxClassificationRef: this.taxClassificationRefValue && {
        value: this.taxClassificationRefValue,
      },
    };

    if (this.parentRefValue || this.parentRefName) {
      data["ParentRef"] = {
        value: this.parentRefValue,
      };
    }

    const response = await this.quickbooks.updateItem({
      $,
      data,
    });

    if (response) {
      $.export("summary", `Successfully updated item with ID ${this.itemId}`);
    }

    return response;
  },
};

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	`quickbooks`	`app`	This component uses the QuickBooks app.
Item ID	`itemId`	`string`	Select a value from the drop down menu.
Name	`name`	`string`	Name of the item. This value must be unique.
Track Quantity on Hand	`trackQtyOnHand`	`boolean`	True if there is quantity on hand to be tracked. Once this value is true, it cannot be updated to false. Applicable for items of type `Inventory`. Not applicable for `Service` or `NonInventory` item types.
Quantity on Hand	`qtyOnHand`	`string`	Current quantity of the `Inventory` items available for sale. Not used for `Service` or `NonInventory` type items. Required for `Inventory` type items.
Income Account Ref Value	`incomeAccountRefValue`	`string`	Select a value from the drop down menu.
Type	`type`	`string`	Select a value from the drop down menu:`InventoryGroupServiceNonInventory`
Asset Account Ref Value	`assetAccountRefValue`	`string`	Select a value from the drop down menu.
Inventory Start Date	`invStartDate`	`string`	Date of opening balance for the inventory transaction. Required when creating an `Item.Type=Inventory`. Required for `Inventory` item types.
Expense Account Ref Value	`expenseAccountRefValue`	`string`	Select a value from the drop down menu.
Sku	`sku`	`string`	The stock keeping unit (SKU) for this Item. This is a company-defined identifier for an item or product used in tracking inventory.
Sales Tax Included	`salesTaxIncluded`	`boolean`	True if the sales tax is included in the item amount, and therefore is not calculated for the transaction.
Sales Tax Code Ref Value	`salesTaxCodeRefValue`	`string`	Select a value from the drop down menu.
Purchase Tax Included	`purchaseTaxIncluded`	`boolean`	True if the purchase tax is included in the item amount, and therefore is not calculated for the transaction.
Description	`description`	`string`	Description of the item.
Abatement Rate	`abatementRate`	`string`	Sales tax abatement rate for India locales.
Reverse Charge Rate	`reverseChargeRate`	`string`	Sales tax reverse charge rate for India locales.
Sub Item	`subItem`	`boolean`	If true, this is a sub item. If false or null, this is a top-level item. Creating inventory hierarchies with traditional inventory items is being phased out in lieu of using categories and sub categories.
Taxable	`taxable`	`boolean`	If true, transactions for this item are taxable. Applicable to US companies, only.
UQC Display Text	`UqcDisplayText`	`string`	Text to be displayed on customer's invoice to denote the Unit of Measure (instead of the standard code).
Reorder Point	`reorderPoint`	`string`	The minimum quantity of a particular inventory item that you need to restock at any given time. The ReorderPoint value cannot be set to null for sparse updates(sparse=true). It can be set to null only for full updates.
Purchase Description	`purchaseDesc`	`string`	Purchase description for the item.
Pref Vendor Ref Value	`prefVendorRefValue`	`string`	Select a value from the drop down menu.
Active	`active`	`boolean`	If true, the object is currently enabled for use by QuickBooks.
UQC ID	`UqcId`	`string`	ID of Standard Unit of Measure (UQC:Unique Quantity Code) of the item according to GST rule.
Purchase Tax Code Ref Value	`purchaseTaxCodeRefValue`	`string`	Select a value from the drop down menu.
Service Type	`serviceType`	`string`	Sales tax service type for India locales.
Purchase Cost	`purchaseCost`	`string`	Amount paid when buying or ordering the item, as expressed in the home currency.
Unit Price	`unitPrice`	`string`	Corresponds to the Price/Rate column on the QuickBooks Online UI to specify either unit price, a discount, or a tax rate for item. If used for unit price, the monetary value of the service or product, as expressed in the home currency. If used for a discount or tax rate, express the percentage as a fraction. For example, specify `0.4` for 40% tax
Tax Classification ID	`taxClassificationRefValue`	`string`	Select a value from the drop down menu.
Parent Ref Value	`parentRefValue`	`string`	Select a value from the drop down menu.

Action Authentication#

QuickBooks uses OAuth authentication. When you connect your QuickBooks account, Pipedream will open a popup window where you can sign into QuickBooks 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 API.

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

com.intuit.quickbooks.accountingopenidprofileemail

About QuickBooks#

QuickBooks Online is designed to help you manage your business finances with ease.

More Ways to Connect QuickBooks + HTTP / Webhook#

Other Popular Integrations#

Send any HTTP Request with HTTP / Webhook API on New Customer Created from QuickBooks API

QuickBooks + HTTP / Webhook