Update Product Variant with Shopify (OAuth) API on New Email Event (Instant) from Microsoft Outlook API

Pipedream makes it easy to connect APIs for Shopify (OAuth), Microsoft Outlook and 2,500+ other apps remarkably fast.

Trigger workflow on

New Email Event (Instant) from the Microsoft Outlook API

Next, do this

Update Product Variant with the Shopify (OAuth) 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 Microsoft Outlook trigger and Shopify (OAuth) action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Email Event (Instant) trigger
1. Connect your Microsoft Outlook account
2. Configure Webhook renewal timer
3. Optional- Select one or more Folder IDs to Monitor
Configure the Update Product Variant action
1. Connect your Shopify (OAuth) account
2. Select a Product ID
3. Select a Product Variant ID
4. Optional- Select one or more Options
5. Optional- Configure Price
6. Optional- Configure Image
7. Optional- Configure Sku
8. Optional- Configure Barcode
9. Optional- Configure Weight
10. Optional- Select a Weight Unit
11. Optional- Configure Metafields
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 Email Event (Instant) on Microsoft Outlook

Description:Emit new event when an email is received in specified folders.

Version:0.0.17

Key:microsoft_outlook-new-email

View on GitHub

Microsoft Outlook Overview#

The Microsoft Outlook API on Pipedream allows you to automate email-related tasks, manage calendars, and handle contacts effortlessly. With the API, you can trigger workflows on new emails, send emails programmatically, and synchronize calendars across platforms, among other functions. Pipedream's serverless platform facilitates the connection between Outlook and a myriad of other apps for efficient automation workflows.

Trigger Code#

import common from "../common/common-new-email.mjs";
import md5 from "md5";
import sampleEmit from "./test-event.mjs";

export default {
  ...common,
  key: "microsoft_outlook-new-email",
  name: "New Email Event (Instant)",
  description: "Emit new event when an email is received in specified folders.",
  version: "0.0.17",
  type: "source",
  dedupe: "unique",
  methods: {
    ...common.methods,
    async getSampleEvents({ pageSize }) {
      const folders = this.folderIds?.length
        ? this.folderIds.map((id) => `/me/mailFolders/${id}/messages`)
        : [
          "/me/messages",
        ];

      const results = [];
      for (const folder of folders) {
        const { value: messages } = await this.microsoftOutlook.listMessages({
          resource: folder,
          params: {
            $top: pageSize,
            $orderby: "createdDateTime desc",
          },
        });
        results.push(...messages);
      }
      return results;
    },
    emitEvent(item) {
      if (this.isRelevant(item)) {
        this.$emit(
          {
            email: item,
          },
          this.generateMeta(item),
        );
      }
    },
    generateMeta(item) {
      return {
        id: md5(item.id), // id > 64 characters, so dedupe on hash of id
        summary: `New email (ID:${item.id})`,
        ts: Date.parse(item.createdDateTime),
      };
    },
  },
  async run(event) {
    const folders = this.folderIds?.length
      ? this.folderIds.map((id) => `/me/mailFolders/${id}/messages`)
      : [
        "/me/messages",
      ];

    for (const folder of folders) {
      await this.run({
        event,
        emitFn: async ({ resourceId } = {}) => {
          try {
            const item = await this.microsoftOutlook.getMessage({
              resource: folder,
              messageId: resourceId,
            });
            this.emitEvent(item);
          } catch {
            console.log(`Could not fetch message with ID: ${resourceId}`);
          }
        },
      });
    }
  },
  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
Microsoft Outlook	`microsoftOutlook`	`app`	This component uses the Microsoft Outlook 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.
Webhook renewal timer	`timer`	`$.interface.timer`	Graph API expires Outlook notifications in 3 days, we auto-renew them in 2 days, see
Folder IDs to Monitor	`folderIds`	`string[]`	Select a value from the drop down menu.

Trigger Authentication#

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

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

User.Reademailoffline_accessopenidprofileMail.ReadWriteMail.SendMailboxSettings.ReadWriteIMAP.AccessAsUser.AllPOP.AccessAsUser.AllSMTP.SendCalendars.ReadWriteContacts.ReadWrite

About Microsoft Outlook#

Microsoft Outlook lets you bring all your email accounts and calendars in one convenient spot.

Action#

Update Product Variant on Shopify (OAuth)

Description:Update an existing product variant. [See the documentation](https://shopify.dev/docs/api/admin-graphql/latest/mutations/productVariantsBulkUpdate)

Version:0.0.16

Key:shopify-update-product-variant

View on GitHub

Shopify (OAuth) Overview#

Shopify provides a powerful API that enables developers to build a wide range
of applications and tools for merchants. Some examples of what you can build
using the Shopify API include:

Merchant tools: tools that help merchants manage their stores, such as order
management, product administration, and reporting
E-commerce applications: applications that enable merchants to sell their
products online, such as shopping carts, product catalogs, and order
management
Integration tools: tools that helps integrate Shopify with other systems,
such as accounting, inventory, and shipping

Action Code#

import shopify from "../../shopify.app.mjs";
import utils from "../../common/utils.mjs";
import {
  MAX_LIMIT, WEIGHT_UNITS,
} from "../../common/constants.mjs";
import { ConfigurationError } from "@pipedream/platform";

export default {
  key: "shopify-update-product-variant",
  name: "Update Product Variant",
  description: "Update an existing product variant. [See the documentation](https://shopify.dev/docs/api/admin-graphql/latest/mutations/productVariantsBulkUpdate)",
  version: "0.0.16",
  type: "action",
  props: {
    shopify,
    productId: {
      propDefinition: [
        shopify,
        "productId",
      ],
    },
    productVariantId: {
      propDefinition: [
        shopify,
        "productVariantId",
        (c) => ({
          productId: c.productId,
        }),
      ],
    },
    optionIds: {
      propDefinition: [
        shopify,
        "productOptionIds",
        (c) => ({
          productId: c.productId,
        }),
      ],
      optional: true,
    },
    price: {
      type: "string",
      label: "Price",
      description: "The price of the product variant",
      optional: true,
    },
    image: {
      type: "string",
      label: "Image",
      description: "The URL of an image to be added to the product variant",
      optional: true,
    },
    sku: {
      type: "string",
      label: "Sku",
      description: "A unique identifier for the product variant in the shop",
      optional: true,
    },
    barcode: {
      type: "string",
      label: "Barcode",
      description: "The barcode, UPC, or ISBN number for the product",
      optional: true,
    },
    weight: {
      type: "string",
      label: "Weight",
      description: "The weight of the product variant in the unit system specified with Weight Unit",
      optional: true,
    },
    weightUnit: {
      type: "string",
      label: "Weight Unit",
      description: "The unit of measurement that applies to the product variant's weight. If you don't specify a value for weight_unit, then the shop's default unit of measurement is applied.",
      optional: true,
      options: WEIGHT_UNITS,
    },
    metafields: {
      propDefinition: [
        shopify,
        "metafields",
      ],
    },
  },
  methods: {
    async getOptionValues() {
      const { product: { options } } = await this.shopify.getProduct({
        id: this.productId,
        first: MAX_LIMIT,
      });
      const productOptions = {};
      for (const option of options) {
        for (const optionValue of option.optionValues) {
          productOptions[optionValue.id] = option.id;
        }
      }
      const optionValues = this.optionIds.map((id) => ({
        id,
        optionId: productOptions[id],
      }));
      return optionValues;
    },
  },
  async run({ $ }) {
    if ((this.weightUnit && !this.weight) || (!this.weightUnit && this.weight)) {
      throw new ConfigurationError("Must enter both Weight and Weight Unit to set weight");
    }

    const response = await this.shopify.updateProductVariant({
      productId: this.productId,
      variants: [
        {
          id: this.productVariantId,
          optionValues: this.optionIds && await this.getOptionValues(),
          price: this.price,
          mediaSrc: this.image,
          barcode: this.barcode,
          inventoryItem: (this.sku || this.weightUnit || this.weight) && {
            sku: this.sku,
            measurement: (this.weightUnit || this.weight) && {
              weight: {
                unit: this.weightUnit,
                value: +this.weight,
              },
            },
          },
          metafields: this.metafields && utils.parseJson(this.metafields),
        },
      ],
    });
    if (response.productVariantsBulkUpdate.userErrors.length > 0) {
      throw new Error(response.productVariantsBulkUpdate.userErrors[0].message);
    }
    $.export("$summary", `Created new product variant \`${response.productVariantsBulkUpdate.productVariants[0].title}\` with ID \`${response.productVariantsBulkUpdate.productVariants[0].id}\``);
    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
Shopify (OAuth)	`shopify`	`app`	This component uses the Shopify (OAuth) app.
Product ID	`productId`	`string`	Select a value from the drop down menu.
Product Variant ID	`productVariantId`	`string`	Select a value from the drop down menu.
Options	`optionIds`	`string[]`	Select a value from the drop down menu.
Price	`price`	`string`	The price of the product variant
Image	`image`	`string`	The URL of an image to be added to the product variant
Sku	`sku`	`string`	A unique identifier for the product variant in the shop
Barcode	`barcode`	`string`	The barcode, UPC, or ISBN number for the product
Weight	`weight`	`string`	The weight of the product variant in the unit system specified with Weight Unit
Weight Unit	`weightUnit`	`string`	Select a value from the drop down menu:`KILOGRAMSGRAMSPOUNDSOUNCES`
Metafields	`metafields`	`string[]`	An array of objects, each one representing a metafield. If adding a new metafield, the object should contain `key`, `value`, `type`, and `namespace`. Example: `{{ [{ "key": "new", "value": "newvalue", "type": "single_line_text_field", "namespace": "global" }] }}`. To update an existing metafield, use the `id` and `value`. Example: `{{ [{ "id": "28408051400984", "value": "updatedvalue" }] }}`

Action Authentication#

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

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

About Shopify (OAuth)#

Shopify is a complete commerce platform that lets anyone start, manage, and grow a business. You can use Shopify to build an online store, manage sales, market to customers, and accept payments in digital and physical locations.

More Ways to Connect Shopify (OAuth) + Microsoft Outlook#

Other Popular Integrations#

Create Calendar Event with Microsoft Outlook API on New Abandoned Cart from Shopify API

Shopify (OAuth) + Microsoft Outlook

Update Product Variant with Shopify (OAuth) API on New Email Event (Instant) from Microsoft Outlook API

Pipedream makes it easy to connect APIs for Shopify (OAuth), Microsoft Outlook 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