Update Item with Quickbooks Sandbox API

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

Trigger workflow on

HTTP requests, schedules and app events

Next, do this

Update Item 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#

Create a workflow to Update Item with the Quickbooks Sandbox API. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Configure the Update Item action
1. Connect your Quickbooks Sandbox 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
Select a trigger to run your workflow on HTTP requests, schedules or app events
Deploy the workflow
Send a test event to validate your setup
Turn on the trigger

Integrations#

Update Item with Quickbooks Sandbox API on New Requests (Payload Only) from HTTP / Webhook API

HTTP / Webhook + Quickbooks Sandbox

Try it

Update Item with Quickbooks Sandbox API on New Item in Feed from RSS API

RSS + Quickbooks Sandbox

Try it

Update Item with Quickbooks Sandbox API on New Message from Discord API

Discord + Quickbooks Sandbox

Try it

Update Item with Quickbooks Sandbox API on New Message In Channels from Slack API

Slack + Quickbooks Sandbox

Try it

Update Item with Quickbooks Sandbox API on New Message in Channel from Discord Bot API

Discord Bot + Quickbooks Sandbox

Try it

Details#

This is a pre-built, source-available component from Pipedream's GitHub repo. The component is 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.

Update Item on Quickbooks Sandbox

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.2.4

Key:quickbooks_sandbox-update-item

View on GitHub

Code#

import app from "../../quickbooks_sandbox.app.mjs";
import common from "@pipedream/quickbooks/actions/update-item/update-item.mjs";

import { adjustPropDefinitions } from "../../common/utils.mjs";

const {
  name, description, type, ...others
} = common;
const props = adjustPropDefinitions(others.props, app);

export default {
  ...others,
  key: "quickbooks_sandbox-update-item",
  version: "0.2.4",
  name,
  description,
  type,
  props: {
    quickbooks: app,
    ...props,
  },
};

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
Quickbooks Sandbox	`quickbooks`	`app`	This component uses the Quickbooks Sandbox 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.

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