蜜豆视频

Microsoft OneDrive modules

In an 蜜豆视频 Workfront Fusion scenario, you can automate workflows that use OneDrive, as well as connect it to multiple third-party applications and services.

If you need instructions on creating a scenario, see Create a scenario in 蜜豆视频 Workfront Fusion.

For information about modules, see Modules in 蜜豆视频 Workfront Fusion.

Access requirements

You must have the following access to use the functionality in this article:

蜜豆视频 Workfront plan*
Pro or higher
蜜豆视频 Workfront license*
Plan, Work
蜜豆视频 Workfront Fusion license**

Current license requirement: No Workfront Fusion license requirement.

Or

Legacy license requirement: Workfront Fusion for Work Automation and Integration

Product

Current product requirement: If you have the Select or Prime 蜜豆视频 Workfront plan, your organization must purchase 蜜豆视频 Workfront Fusion as well as 蜜豆视频 Workfront to use functionality described in this article. Workfront Fusion is included in the Ultimate Workfront plan.

Or

Legacy product requirement: Your organization must purchase 蜜豆视频 Workfront Fusion as well as 蜜豆视频 Workfront to use functionality described in this article.

To find out what plan, license type, or access you have, contact your Workfront administrator.

For information on 蜜豆视频 Workfront Fusion licenses, see 蜜豆视频 Workfront Fusion licenses.

Prerequisites

To use OneDrive modules, you must have a Microsoft OneDrive account.

OneDrive API information

The OneDrive connector uses the following:

Base URL
https://graph.microsoft.com/v1.0
API version
v1
API tag
v2.0.10

Connecting the OneDrive service to Workfront Fusion

For instructions about connecting your OneDrive account to Workfront Fusion, see Create a connection to 蜜豆视频 Workfront Fusion - Basic instructions

NOTE
Some Microsoft apps use the same connection, which is tied to individual user permissions. Therefore, when creating a connection, the permissions consent screen displays any permissions that were previously granted to this user鈥檚 connection, in addition to any new permissions needed for the current application.
For example, if a user has 鈥淩ead table鈥 permissions granted via the Excel connector and then creates a connection in the Outlook connector to read emails, the permissions consent screen will show both the already granted 鈥淩ead table鈥 permission and the newly required 鈥淲rite email鈥 permission.

Microsoft OneDrive modules and their fields

When you configure OneDrive modules, Workfront Fusion displays the fields listed below. Along with these, additional OneDrive fields might display, depending on factors such as your access level in the app or service. A bolded title in a module indicates a required field.

If you see the map button above a field or function, you can use it to set variables and functions for that field. For more information, see Map information from one module to another in 蜜豆视频 Workfront Fusion.

File/Folder

Watch Files/Folders

This trigger module starts a scenario when a file or folder is created or updated.

Connection
For instructions about connecting your OneDrive account to Workfront Fusion, see Create a connection to 蜜豆视频 Workfront Fusion - Basic instructions
Watch Files/Folders

Select how you want to watch files or folders:

  • By Created聽Time

    Watch for new files or folders.

  • By Updated Time

    Watch for updated existing files or folders.

Choose your OneDrive location

Select the location you want to watch:

  • My Drive

    Select whether to enable the module to enter a drive ID.

    • Yes

      Enter the ID聽of the drive that you want the module to watch.

    • No

      Navigate to the folder that you want the module to watch. You can also enter a query to filter the returned results.

  • Shared With Me

    The module watches files that have been shared with the owner of the drive.

  • Site's Drive

    Select the SharePoint Site that you want the module to watch. Available Sites are Sites followed by the signed-in user.

  • Group's Drive

    Select the group whose drive you want the module to watch.

Choose an Item Type

Select whether you want to watch files, folders, or both.

Note: You cannot watch for folders in a Shared With Me drive.

Limit
Enter or map the maximum number of records you want the module to return during each scenario execution cycle.

Search Files/Folders

This search module returns files and folders based on criteria you set.

Connection
For instructions about connecting your OneDrive account to Workfront Fusion, see Create a connection to 蜜豆视频 Workfront Fusion - Basic instructions
Choose your OneDrive location

Select the location you want to search:

  • My Drive

    Select whether to enable the module to enter a drive ID.

    • Yes

      Enter the ID聽of the drive that you want the module to search.

    • No

      Navigate to the folder that you want the module to search. You can also enter a query to filter the returned results.

  • Shared With Me

    The module searches files that have been shared with the owner of the drive.

  • Site's Drive

    Select the SharePoint Site that you want the module to search. Available Sites are Sites followed by the signed-in user.

  • Group's Drive

    Select the group whose drive you want the module to search.

Choose an Item Type

Select whether you want to search for files, folders, or both.

Note: You cannot search for folders in a Shared With Me drive.

Limit
Enter or map the maximum number of records you want the module to return during each scenario execution cycle.

Get a file

This action module gets the metadata of a specified file.

Connection
For instructions about connecting your OneDrive account to Workfront Fusion, see Create a connection to 蜜豆视频 Workfront Fusion - Basic instructions
Enter (File ID & File Path)
Select whether you want to identify the file by File ID or by the File Path.
Enter a File ID / File Path

Select how you want to enter the File ID or File Path:

  • Enter Manually

    Select this option if you want to enter the ID聽or path directly, or map it from a previous module.

  • Select from a list

    Select this option if you want to select from a list of available files or paths.

Choose your OneDrive location

Select the location you want to search:

  • My Drive

    Select whether to enable the module to enter a drive ID.

    • Yes

      Enter the ID聽of the drive that contains the file you want to get.

    • No

  • Site's Drive

    Select the SharePoint Site that contains the file you want to get. Available Sites are Sites followed by the signed-in user.

  • Group's Drive

    Select the group whose drive contains the file you want to get.

Drive ID
Select or map the drive that contains the file you want to get. This field is not available if you selected No in the Enable to Enter a Drive ID field.
File / File ID / File Path

If you selected Enter Manually, enter or map the file ID聽or path of the file you want to get.

If you selected Select from the list, select the file that you want to get.

Download a file

This action module downloads the specified file.

Connection
For instructions about connecting your OneDrive account to Workfront Fusion, see Create a connection to 蜜豆视频 Workfront Fusion - Basic instructions
Enter (File ID & File Path)
Select whether you want to identify the file by File ID or by the File Path.
Enter a File ID / File Path

Select how you want to enter the File ID or File Path:

  • Enter Manually

    Select this option if you want to enter the ID聽or path directly, or map it from a previous module.

  • Select from a list

    Select this option if you want to select from a list of available files or paths.

Choose your OneDrive location

Select the location you want to that contains the file you want to download:

  • My Drive

    Select whether to enable the module to enter a drive ID.

    • Yes

      Enter the ID聽of the drive that contains the file you want to download.

    • No

  • Site's Drive

    Select the SharePoint Site that contains the file you want to download. Available Sites are Sites followed by the signed-in user.

  • Group's Drive

    Select the group whose drive contains the file you want to download.

Drive ID
Select or map the drive that contains the file you want to download. This field is not available if you selected No in the Enable to Enter a Drive ID field.
File / File ID / File Path

If you selected Enter Manually, enter or map the file ID聽or path of the file you want to download.

If you selected Select from the list, select the file that you want to download.

Convert to PDF

Enable this option to convert the file to a PDF file. You can convert from the following file types:

table 0-row-3 layout-auto html-authored no-header
  • CSV

  • DOC

  • DOCX

  • ODP

  • ODS

  • ODT

  • POT

  • POTM

  • POTX

  • PPS

  • PPSX

  • PPSXM

  • PPT

  • PPTM

  • PPTX

  • RTF

  • XLS

  • XLSX

Upload a file

This action module uploads a file to the specified folder.

Connection
For instructions about connecting your OneDrive account to Workfront Fusion, see Create a connection to 蜜豆视频 Workfront Fusion - Basic instructions
Enter (Folder Location ID & Path)
Select whether you want to identify the target folder by ID聽or by a path.
Choose your OneDrive location

Select the location where you want to upload a file:

  • My Drive

    Select whether to enable the module to enter a drive ID.

    • Yes

      Select the drive that contains the file you want to get.

    • No

  • Site's Drive

    Select the SharePoint Site that contains the folder where you want to upload a file. Available Sites are Sites followed by the signed-in user.

  • Group's Drive

    Select the group whose drive contains the folder where you want to upload a file.

Drive ID
Select the drive that contains the folder where you want to upload a file. This field is not available if you selected No in the Enable to Enter a Drive ID field.
Source file
Select a source file from a previous module, or map the source file's name and data.
If the File with the Same Name Exists
Select how to proceed if a file with the same name already exists.
Description
Add a description to the uploaded file.

Create a Folder

This action module creates a new folder in the specified drive.

Connection
For instructions about connecting your OneDrive account to Workfront Fusion, see Create a connection to 蜜豆视频 Workfront Fusion - Basic instructions
Choose your OneDrive location

Select the location where you want to create a folder:

  • My Drive

    Select whether to enable the module to enter a drive ID.

    • Yes

      Select the drive where you want to create a folder.

    • No

  • Site's Drive

    Select the SharePoint Site where you want to create a folder. Available Sites are Sites followed by the signed-in user.

  • Group's Drive

    Select the group that owns the drivewhere you want to create a folder.

Drive ID
Select the drive that where you want to create a folder. This field is not available if you selected No in the Enable to Enter a Drive ID field.
Folder
If you want the new folder to be a subfolder, navigate to the folder that you want it to be a subfolder in.
New Folder Name
Enter or map a name for the new folder.
If the Folder with the Same Name Exists
Select how to proceed if a file with the same name already exists.

This action module returns a share link for the specified file.

Connection
For instructions about connecting your OneDrive account to Workfront Fusion, see Create a connection to 蜜豆视频 Workfront Fusion - Basic instructions
Enter (File ID & File Path)
Select whether you want to identify the file by File ID or by the File Path.
Enter a File ID / File Path

Select how you want to enter the File ID or File Path:

  • Enter Manually

    Select this option if you want to enter the ID聽or path directly, or map it from a previous module.

  • Select from a list

    Select this option if you want to select from a list of available files or paths.

Choose your OneDrive location

Select the location you want to retrieve a share link for:

  • My Drive

    Select whether to enable the module to enter a drive ID.

    • Yes

      Enter the ID聽of the drive that contains the file you want to retrieve a share link for.

    • No

  • Site's Drive

    Select the SharePoint Site that contains the file you want to retrieve a share link for. Available Sites are Sites followed by the signed-in user.

  • Group's Drive

    Select the group whose drive contains the file you want to retrieve a share link for.

Drive ID
Select or map the drive that contains the file you want to retrieve a share link for. This field is not available if you selected No in the Enable to Enter a Drive ID field.
File / File ID / File Path

If you selected Enter Manually, enter or map the file ID聽or path of the file you want to retrieve a share link for.

If you selected Select from the list, select the file that you want to retrieve a share link for.

Permission Type
Select whether you want people with the link to be able to read and write to the file, or to read only.
Scope
Select whether you want the file to be available to anyone with the link, or only to members of your organization who have the link.

Move a File/Folder

This action module moves a file or folder to a new folder location

Connection
For instructions about connecting your OneDrive account to Workfront Fusion, see Create a connection to 蜜豆视频 Workfront Fusion - Basic instructions
Enter (File ID & File Path)
Select whether you want to identify the file by File ID or by the File Path.
Enter a File ID / File Path

Select how you want to enter the File ID or File Path:

  • Enter Manually

    Select this option if you want to enter the ID聽or path directly, or map it from a previous module.

  • Select from a list

    Select this option if you want to select from a list of available files or paths.

Choose your OneDrive location

Select the location that contains the file or folder that you want to move:

  • My Drive

    Select whether to enable the module to enter a drive ID.

    • Yes

      Enter the ID聽of the drive that contains the file or folder that you want to move.

    • No

  • Site's Drive

    Select the SharePoint Site that contains the file or folder that you want to move. Available Sites are Sites followed by the signed-in user.

  • Group's Drive

    Select the group whose drive contains the file or folder that you want to move.

Drive ID
Select or map the drive that contains the file or folder that you want to move. This field is not available if you selected No in the Enable to Enter a Drive ID field.
Select File/Folder
Select whether you want to move a file or a folder.

File / File ID / File Path

Folder / Folder ID / Folder Path

If you selected Enter Manually, enter or map the ID聽or path of the file or folder that you want to move.

If you selected Select from the list, select the file or folder that you want to move.

Enter a New Folder Location

Select how you want to enter the location that you want to move the file or folder to:

  • Enter Manually

    Select this option if you want to enter the ID聽or path directly, or map it from a previous module.

  • Select from a list

    Select this option if you want to select from a list of available files or paths.

Choose your OneDrive location

Select the location where you want to move the file or folder:

  • My Drive

    Select whether to enable the module to enter a drive ID.

    • Yes

      Enter the ID聽of the drive where you want to move the file or folder.

    • No

  • Site's Drive

    Select the SharePoint Site where you want to move the file or folder. Available Sites are Sites followed by the signed-in user.

  • Group's Drive

    Select the group to whose drive you want to move the file or folder.

Drive ID

Select or map the drive that contains the folder that you want to move the file or folder to. This field is not available if you selected No in the Enable to Enter a Drive ID field.

If you leave this blank, the file or folder can only be moved within the same OneDrive.

You can move files and folders from My Drive to a Site's Drive or a Group's Drive.

You can move files from a Site's Drive only to the same drive in the same Site.

You can move files from a Group's Drive only to the same drive in the same Group.

Folder
Enter or map the folder where you want to move the file or folder.

Copy a File

This action module copies a file into a new folder location

Connection
For instructions about connecting your OneDrive account to Workfront Fusion, see Create a connection to 蜜豆视频 Workfront Fusion - Basic instructions
Enter (File ID & File Path)
Select whether you want to identify the file by File ID or by the File Path.
Enter a File ID / File Path

Select how you want to enter the File ID or File Path:

  • Enter Manually

    Select this option if you want to enter the ID聽or path directly, or map it from a previous module.

  • Select from a list

    Select this option if you want to select from a list of available files or paths.

Choose your OneDrive location

Select the location that contains the file that you want to copy:

  • My Drive

    Select whether to enable the module to enter a drive ID.

    • Yes

      Enter the ID聽of the drive that contains the file or folder that you want to copy.

    • No

  • Site's Drive

    Select the SharePoint Site that contains the file that you want to move. Available Sites are Sites followed by the signed-in user.

  • Group's Drive

    Select the group whose drive contains the file that you want to copy.

Drive ID
Select or map the drive that contains the file that you want to copy. This field is not available if you selected No in the Enable to Enter a Drive ID field.
File / File ID / File Path

If you selected Enter Manually, enter or map the ID聽or path of the file that you want to copy.

If you selected Select from the list, select the file that you want to copy.

Enter a New Folder Location

Select how you want to enter the location that you want to copy the file or to:

  • Enter Manually

    Select this option if you want to enter the ID聽or path directly, or map it from a previous module.

  • Select from a list

    Select this option if you want to select from a list of available folder.

New OneDrive location

Select the location where you want to copy the filer. This option is available if you chose to select the new folder location from a list.

  • My Drive

    Select whether to enable the module to enter a drive ID.

    • Yes

      Enter the ID聽of the drive where you want to copy the file.

    • No

  • Site's Drive

    Select the SharePoint Site where you want to copy the file. Available Sites are Sites followed by the signed-in user.

  • Group's Drive

    Select the group to whose drive you want to copy the file.

Drive ID

Select or map the drive that contains the folder that you want to copy the file to. This field is not available if you selected No in the Enable to Enter a Drive ID field.

If you leave this blank, the file or folder can only be copied within the same OneDrive.

You can copy files and folders from My Drive to a Site's Drive or a Group's Drive.

You can copy files from a Site's Drive only to the same drive in the same Site.

You can copy files from a Group's Drive only to the same drive in the same Group.

Folder
Enter or map the folder where you want to move the copy or folder.
New Copied File Name

Enter or map a name for the new copy of the file. You can leave this blank if you do not want to change the original file name.

The name must include the file extension. Example: file.txt

Delete a File/Folder

This action module deletes the selected file.

Connection
For instructions about connecting your OneDrive account to Workfront Fusion, see Create a connection to 蜜豆视频 Workfront Fusion - Basic instructions
Enter (File/Folder ID & Path)
Select whether you want to identify the file by File ID or by the File Path.
Enter a File/Folder ID /Enter a File/Folder Path

Select how you want to enter the File ID or File Path:

  • Enter Manually

    Select this option if you want to enter the ID聽or path directly, or map it from a previous module.

  • Select from a list

    Select this option if you want to select from a list of available files or paths.

Choose your OneDrive location

Select the location you want to search:

  • My Drive

    Select whether to enable the module to enter a drive ID.

    • Yes

      Enter the ID聽of the drive that contains the file or folder you want to delete.

    • No

  • Site's Drive

    Select the SharePoint Site that contains the file or folder you want to delete. Available Sites are Sites followed by the signed-in user.

  • Group's Drive

    Select the group whose drive contains the file or folder you want to delete.

Drive ID
Select or map the drive that contains the file or folder you want to delete. This field is not available if you selected No in the Enable to Enter a Drive ID field.
Select File/Folder
Select whether you want to delete a file or a folder.
File / File ID / File Path

If you selected Enter Manually, enter or map the file ID聽or path of the file you want to delete.

If you selected Select from the list, select the file that you want to delete.

Other

Make an API Call

This module performs a custom API call.

Select the HTTP request method you need to configure the API call. For more information, see HTTP request methods in 蜜豆视频 Workfront Fusion.

Connection
For instructions about connecting your OneDrive account to Workfront Fusion, see Create a connection to 蜜豆视频 Workfront Fusion - Basic instructions
URL
Enter a path relative to https://graph.microsoft.com. Example: /v1.0/me/drive/root/children
Method
Headers

Add the headers of the request in the form of a standard JSON object.

For example, {"Content-type":"application/json"}

Workfront Fusion adds the authorization headers for you.

Query String

Add the query for the API call in the form of a standard JSON object.

For example: {"name":"something-urgent"}

Body

Add the body content for the API call in the form of a standard JSON object.

Note:

When using conditional statements such as if in your JSON, put the quotation marks outside of the conditional statement.

If you are unable to upload or update a file

There are several possible issues when uploading or updating a file fails:

  • The uploaded file is too big and exceeds the maximum file size limit for your OneDrive plan or you have used all of your OneDrive account鈥檚 storage quota. To get more storage space, delete existing files from OneDrive or upgrade your OneDrive account.
  • OneDrive does not allow to upload two files with the same name to one single folder. If the target folder contains a file with the same name as the file being uploaded, the scenario run terminates with an error. The solution is to simply rename the file being uploaded. If your aim is to update a file, use the Update a file action.
  • The previously selected folder, to which the file is being uploaded, no longer exists. The scenario stops and you will need to select the target folder again.
recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43