Create Folder with Microsoft OneDrive API on New Transaction from BoxHero API

Pipedream makes it easy to connect APIs for Microsoft OneDrive, BoxHero and 2,400+ other apps remarkably fast.

Trigger workflow on

New Transaction from the BoxHero API

Next, do this

Create Folder with the Microsoft OneDrive 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 BoxHero trigger and Microsoft OneDrive action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Transaction trigger
1. Connect your BoxHero account
2. Configure timer
3. Optional- Select a Transaction Type
Configure the Create Folder action
1. Connect your Microsoft OneDrive account
2. Optional- Select a Parent Folder Type
3. Select a Parent Folder ID
4. Select a Shared Folder Reference
5. Configure Folder Name
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 Transaction on BoxHero

Description:Emit new event when a transaction occurs. [See the documentation](https://docs-en.boxhero-app.com/integrations-and-api/boxhero-api-reference#v1-txs)

Version:0.0.1

Key:boxhero-new-transaction

View on GitHub

BoxHero Overview#

The BoxHero API provides tools to manage inventory in a streamlined and efficient way. By integrating with Pipedream, you can automate inventory tracking, update stock levels in real-time, and synchronize data across platforms. Create powerful workflows that trigger actions based on inventory changes, connect to other apps for a seamless operation, or analyze inventory data for smarter decision-making.

Trigger Code#

import boxhero from "../../boxhero.app.mjs";
import constants from "../../common/constants.mjs";
import { DEFAULT_POLLING_SOURCE_TIMER_INTERVAL } from "@pipedream/platform";
import sampleEmit from "./test-event.mjs";

export default {
  key: "boxhero-new-transaction",
  name: "New Transaction",
  description: "Emit new event when a transaction occurs. [See the documentation](https://docs-en.boxhero-app.com/integrations-and-api/boxhero-api-reference#v1-txs)",
  version: "0.0.1",
  type: "source",
  dedupe: "unique",
  props: {
    boxhero,
    db: "$.service.db",
    timer: {
      type: "$.interface.timer",
      default: {
        intervalSeconds: DEFAULT_POLLING_SOURCE_TIMER_INTERVAL,
      },
    },
    transactionType: {
      type: "string",
      label: "Transaction Type",
      description: "Filter events by transaction type",
      options: constants.TRANSACTION_TYPE,
      optional: true,
    },
  },
  hooks: {
    async deploy() {
      await this.processEvent(25);
    },
  },
  methods: {
    _getLastCreatedTs() {
      return this.db.get("lastCreatedTs") || 0;
    },
    _setLastCreatedTs(lastCreatedTs) {
      this.db.set("lastCreatedTs", lastCreatedTs);
    },
    emitEvent(transaction) {
      const meta = this.generateMeta(transaction);
      this.$emit(transaction, meta);
    },
    generateMeta(transaction) {
      return {
        id: transaction.id,
        summary: `New Transaction ${transaction.id}`,
        ts: Date.parse(transaction.created_at),
      };
    },
    async getTeamMode() {
      const { mode } = await this.boxhero.getTeam();
      return mode;
    },
    async processEvent(max) {
      const lastCreatedTs = this._getLastCreatedTs();
      let maxTs = lastCreatedTs;

      const teamMode = await this.getTeamMode();
      const resourceFn = teamMode === 0
        ? this.boxhero.listBasicTransactions
        : this.boxhero.listLocationTransactions;

      const results = this.boxhero.paginate({
        resourceFn,
        params: this.transactionType
          ? {
            type: this.transactionType,
          }
          : {},
        max,
      });

      const transactions = [];
      for await (const transaction of results) {
        const ts = Date.parse(transaction.created_at);
        if (ts > lastCreatedTs) {
          transactions.push(transaction);
          if (ts > maxTs) {
            maxTs = ts;
          }
        }
      }

      transactions.reverse().forEach((transaction) => this.emitEvent(transaction));

      this._setLastCreatedTs(maxTs);
    },
  },
  async run() {
    await this.processEvent();
  },
  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
BoxHero	`boxhero`	`app`	This component uses the BoxHero app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`
Transaction Type	`transactionType`	`string`	Select a value from the drop down menu:`{ "value": "in", "label": "Stock In" }{ "value": "out", "label": "Stock Out" }{ "value": "adjust", "label": "Adjust" }{ "value": "move", "label": "Move (exclusive to Location Mode)" }`

Trigger Authentication#

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

About BoxHero#

Inventory Management Reinvented. BoxHero makes inventory management easier than ever.

Action#

Create Folder on Microsoft OneDrive

Description:Create a new folder in a drive. [See the documentation](https://learn.microsoft.com/en-us/onedrive/developer/rest-api/api/driveitem_post_children?view=odsp-graph-online)

Version:0.1.1

Key:microsoft_onedrive-create-folder

View on GitHub

Microsoft OneDrive Overview#

The Microsoft OneDrive API taps into the robust file storage and management capabilities of OneDrive, allowing for operations like file uploads, retrievals, sharing, and synchronization. Integrating this API into Pipedream workflows lets you automate tasks involving file management, content collaboration, and data backup processes. With OneDrive's API on Pipedream, you can streamline document workflows, trigger actions based on file changes, and connect your file storage to countless other services for enhanced productivity.

Action Code#

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

export default {
  name: "Create Folder",
  description: "Create a new folder in a drive. [See the documentation](https://learn.microsoft.com/en-us/onedrive/developer/rest-api/api/driveitem_post_children?view=odsp-graph-online)",
  key: "microsoft_onedrive-create-folder",
  version: "0.1.1",
  type: "action",
  props: {
    onedrive,
    parentFolderType: {
      type: "string",
      label: "Parent Folder Type",
      description: "Whether to nest the new folder within a folder in your drive (`default`) or a shared folder (`shared`)",
      optional: true,
      options: [
        "default",
        "shared",
      ],
      reloadProps: true,
    },
    parentFolderId: {
      propDefinition: [
        onedrive,
        "folder",
      ],
      label: "Parent Folder ID",
      description: "The ID of the folder which the the new folder should be created. Use the \"Load More\" button to load subfolders.",
      hidden: true,
    },
    sharedFolderReference: {
      propDefinition: [
        onedrive,
        "sharedFolderReference",
      ],
      hidden: true,
    },
    folderName: {
      type: "string",
      label: "Folder Name",
      description: "The name of the new folder to be created. e.g. `New Folder`",
    },
  },
  async additionalProps(props) {
    if (this.parentFolderType === "default") {
      props.parentFolderId.hidden = false;
      props.sharedFolderReference.hidden = true;
    }
    if (this.parentFolderType === "shared") {
      props.sharedFolderReference.hidden = false;
      props.parentFolderId.hidden = true;
    }
    return {};
  },
  async run({ $ }) {
    const {
      folderName, parentFolderId, sharedFolderReference,
    } = this;

    if (sharedFolderReference && parentFolderId) {
      throw new ConfigurationError("You have to select either a `Parent Folder` or a `Shared Folder`.");
    }

    const response = await this.onedrive.createFolder({
      folderName,
      parentFolderId,
      sharedFolderReference,
    });

    if (response?.id) {
      $.export("$summary", `Successfully created folder with ID ${response.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
Microsoft OneDrive	`onedrive`	`app`	This component uses the Microsoft OneDrive app.
Parent Folder Type	`parentFolderType`	`string`	Select a value from the drop down menu:`defaultshared`
Folder Name	`folderName`	`string`	The name of the new folder to be created. e.g. `New Folder`

Action Authentication#

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

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

User.Reademailoffline_accessopenidprofileFiles.ReadFiles.Read.AllFiles.ReadWrite