Download from OneDrive

Description

The Download From OneDrive activity automates the retrieval of files from a designated folder within a connected OneDrive account.
It supports filtering files using regular expressions and saves the matched files to a downstream processing path or storage system.

This is ideal for workflows requiring files stored in Microsoft OneDrive to be pulled into processing pipelines on a scheduled or event-driven basis.

Use case: A team shares Excel reports every Friday to a shared OneDrive folder. This activity can automatically fetch the latest .xlsx files each week for processing.

---

Input

Not Applicable

---

Output

Output Type	Format	Description
Files	Binary	Retrieved files from OneDrive
Data	JSON	File metadata including name, size, and path

---

Configuration Fields

Field Name	Required	Description
Connection	Yes	Connection details for authenticating with the OneDrive account.
Working Directory	Yes	The directory path inside OneDrive from which files should be downloaded.
Regex	No	Regular expression to match filenames for selective download.

---

Sample Input

Not Applicable

---

Sample Configuration

Field	Value
Connection	OneDrive - Finance Reports
Working Directory	/Shared/Weekly Reports
Regex	.*\.xlsx$

---

Sample Output

The following output represents files successfully retrieved from the specified OneDrive folder:

Remote File Name	File Name	Size	Status
report_july_1.xlsx	report_july_1.xlsx	1.8MB	[Download]
summary_week_27.csv	summary_week_27.csv	2.4MB	[Download]