OneDrive
Read data files from your own OneDrive into a Strata flow, and save results as new files or by replacing a file. SharePoint sites aren't supported.
Before you start
- A Microsoft account with a OneDrive. Oplema uses only the signed-in person's drive.
- Permissions Oplema asks for:
Files.Readandoffline_accessfrom Input. Output asks forFiles.ReadWrite. - Work and school accounts may need an administrator to allow the app.
- Requests to OneDrive come from Oplema's servers, not your browser. If your OneDrive account restricts access by network, it must allow them. Oplema doesn't promise a fixed IP address; contact us if you need to allowlist.
Connect
- In Strata, select an Input block to read, or an Output block to write.
- Set Source to Connectors. On an Output block the same control is Destination.
- In the connector dropdown below it, choose OneDrive.
- Open the Connection dropdown and choose Create new connection.
- Set Name (optional). Without a name, the connection is labeled
microsoftplus the date and time. - Select Connect to OneDrive. Microsoft's own sign-in opens in a popup. Approve access there.
The popup closes, the new connection is selected and the pickers below it load. If access later expires or you need more permissions, select the connection, then select Reconnect to OneDrive.
A connection made from Input can only read. To write with it, select it in the Output block, then select Reconnect to OneDrive; Oplema keeps its existing permissions and adds write access.
Read
| Setting | What it does |
|---|---|
| Folder | Browse your OneDrive. The list starts at your current folder and includes a way to go up one level. |
| File | Only these types are listed: csv, csv.gz, tsv, txt, json, jsonl, ndjson, parquet, arrow, ipc, xls, xlsx, xlsm, xlsb, duckdb. |
| File settings | Shown for the file type you picked, the same as for a local file: Sheet, Area, Range and Headers for Excel; Separator, Headers, Starting row and Import settings for delimited text; Records for JSON; Table for DuckDB. |
Select Refresh data to download the file again. An Excel file counts as the whole workbook, even if you read one sheet.
Write
Set Write to one of these. Output has no append mode for files.
- Create new file: pick a Folder, a Filename and a Format, and set If file exists to Fail or Keep both.
- Replace selected file: pick a Folder and a File. The name and location stay. Oplema checks the file hasn't changed since you selected it. For
.xlsx, choose an Excel tab or create one with Tab name; other tabs are kept.
Format offers CSV, compressed CSV, JSON array, JSON Lines, Parquet, Arrow IPC and Excel workbook. Output writes when you run the flow.
Limits and billing
- Reads: the first 50 MB of each download is free. After that, each download costs $0.01 per GB from your usage. Failed reads aren't charged, and a read stops when your usage runs out.
- Writes: the first 50 MB of each write is free. After that, each write costs $0.01 per GB from your usage, and a write stops when your usage runs out. For Excel the whole workbook counts.
See Billing for who pays and how usage works.
Troubleshooting
| Message | What to do |
|---|---|
The OneDrive file changed. Run again to use the latest version. | Someone changed the file after you selected it. Run again. |
OneDrive download failed (<code>). Refresh the file or reconnect Microsoft. | Select Refresh data, or Reconnect to OneDrive. |
OneDrive upload completion is uncertain. Check the destination before running again. | Look at the file in OneDrive first. |
OneDrive upload stopped making progress. Run again after checking the destination. | Check the file, then run again. |
Choose a OneDrive folder | Pick a Folder. |
This transfer exceeds the free 50 MB and the available usage credits | The read or write passed 50 MB and your usage ran out. Add usage, or move less data. |
Prepare your data. Build it in Strata.
Strata opens in your browser, with no account.