Update Item with QuickBooks Sandbox API on New Message (Instant) from Discord API

Pipedream makes it easy to connect APIs for QuickBooks Sandbox, Discord and 3,000+ other apps remarkably fast.

Trigger workflow on

New Message (Instant) from the Discord API

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#

This integration creates a workflow with a Discord 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 New Message (Instant) trigger
1. Connect your Discord account
2. Configure Channels
3. Configure discordApphook
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
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 Message (Instant) on Discord

Description:Emit new event for each message posted to one or more channels in a Discord server

Version:1.0.3

Key:discord-new-message

View on GitHub

Discord Overview#

The Discord API interacts seamlessly with Pipedream, empowering you to craft customized automations and workflows for your Discord server. With this powerful integration, you can automate tasks like message posting, user management, and notifications, based on a myriad of triggers and actions from different apps. These automations can enhance the Discord experience for community moderators and members, by synchronizing with external tools, organizing community engagement, and streamlining notifications.

Trigger Code#

import discord from "../../discord.app.mjs";
import sampleEmit from "./test-event.mjs";

export default {
  type: "source",
  key: "discord-new-message",
  name: "New Message (Instant)",
  description: "Emit new event for each message posted to one or more channels in a Discord server",
  version: "1.0.3",

  dedupe: "unique",
  props: {
    discord,
    channels: {
      type: "$.discord.channel[]",
      appProp: "discord",
      label: "Channels",
      description: "Select the channel(s) you'd like to be notified for",
    },
    // eslint-disable-next-line pipedream/props-label,pipedream/props-description
    discordApphook: {
      type: "$.interface.apphook",
      appProp: "discord",
      async eventNames() {
        return this.channels || [];
      },
    },
  },
  async run(event) {
    if (event.guildID != this.discord.$auth.guild_id) {
      return;
    }
    this.$emit(event, {
      id: event.id,
    });
  },
  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
Discord	`discord`	`app`	This component uses the Discord app.
Channels	`channels`	`$.discord.channel[]`	Select the channel(s) you'd like to be notified for
	`discordApphook`	`$.interface.apphook`

Trigger Authentication#

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

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

botemailidentifyguilds

About Discord#

Use this app to create a Discord source that emits messages from your guild to a Pipedream workflow.

Action#

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

Key:quickbooks_sandbox-update-item

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#

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.5",
  name,
  description,
  type,
  props: {
    quickbooks: app,
    ...props,
  },
};

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

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

Update Item with QuickBooks Sandbox API on New Message (Instant) from Discord API

Pipedream makes it easy to connect APIs for QuickBooks Sandbox, Discord and 3,000+ other apps remarkably fast.

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

Developers ♥ Pipedream

1-24of3,000+apps by most popular

1
-
24
of
3,000+
apps by most popular