Microsoft OneDrive is a file hosting service and synchronization service operated by Microsoft as part of its web version of Office.
Please note that terms used in the OneDrive channel categories are OneDrive specific terminology.
How to Connect
- On the My pipelines page, click Create a pipeline. Enter name, description, and tag fields and click the Create Pipelines button. The pipelines wizard displays:
- From the wizard you choose the connections for the first steps of your pipeline. When you choose a type, you'll add the channels and steps for your first steps. You can always add more steps later. A Triggered pipeline is started by a specific event in real-time. A Scheduled pipeline will start according to a schedule. A Manual pipeline only starts manually. Once you've completed the wizard, you'll be prompted for connection detail, if necessary. If you are an experienced builder, click the Start from scratch button and then from the right side of the page, choose the All to list all available channels.
- Expand OneDrive and click Connect to OneDrive.
- Review the permissions that Pipelines will receive once connected. Your permissions are based on your existing OneDrive account. You can select specific permissions or allow all the options. OneDrive Read permissions are required. When finished click Connect.
Note: Depending on the permissions granted, integration and functionality will be affected.
- You may be requested to sign in with your Microsoft credentials. This is required to set up the connection between OneDrive and Pipelines.
- Agree to allow Pipelines access to your OneDrive account by clicking Accept.
How to reconnect the OneDrive channel
You may need to reconnect your account to a channel. Reasons may be (but not limited to):
-
If you need to connect a different account.
-
Authorization updates, such as a changed password.
-
Editing the access rights that Pipelines has to the channel.
To reconnect:
- Select a pipeline that already has OneDrive in it.
- Open a step containing OneDrive.
- Under account, select Connect (or reconnect) and follow the process above, How to connect.
Steps
The steps you can use with OneDrive fall under the Files category.
Note: You cannot use jinja expressions in trigger conditions unless explicitly specified as possible.
| Type | Name | Description |
|---|---|---|
| Files | ||
| Trigger | File Created | Initiates when a new file is created in a selected folder. |
| Trigger | File Created or Modified | Initiates when, in a particular folder:
|
| Trigger | File Deleted | Triggered when a file is moved to the Recycle Bin or permanently deleted. The field DELETED_STATE distinguishes the two events:
|
| Action | Upload a File | Creates a new file in a specific folder by pulling it from a specific URL. |
| Action | Delete a File | Deletes a specified file. |
| Query | Search Files | Searches for files in the selected account and returns a list. |
| Action | Fetch a Linked File | Fetches a linked file. |
| Query | Look up a File | Look up a file by the id. |
Use case examples
The following are some examples of using the OneDrive channel.
In this example, when a user drops a CSV file into Onedrive, the CSV is imported into Quickbase
- Add a OneDrive File Created or Modified trigger. This step will trigger when a user drops a CSV file into Onedrive.
- Then, add the step Quickbase Import with CSV to import the new OneDrive file. The URL should be the file transfer handle URL.