Documentation

    Dropbox

    Read data files from Dropbox into a Strata flow, and save results as new files or by replacing a file.

    Before you start

    • A Dropbox account with access to the folder and files. Team spaces are supported, but files must go in a writable member or team folder.
    • Permissions Oplema asks for: account_info.read, files.metadata.read and files.content.read from Input. Output adds files.content.write.
    • Requests to Dropbox come from Oplema's servers, not your browser. Oplema doesn't promise a fixed IP address; contact us if you need to allowlist.

    Connect

    1. In Strata, select an Input block to read, or an Output block to write.
    2. Set Source to Connectors. On an Output block the same control is Destination.
    3. In the connector dropdown below it, choose Dropbox.
    4. Open the Connection dropdown and choose Create new connection.
    5. Set Name (optional). Without a name, the connection is labeled dropbox plus the date and time.
    6. Select Connect to Dropbox. Dropbox'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 Dropbox.

    A connection made from Input can only read. To write with it, select it in the Output block, then select Reconnect to Dropbox; Oplema keeps its existing permissions and adds write access.

    Read

    SettingWhat it does
    FolderBrowse your Dropbox. The list starts at your current folder and includes a way to go up one level.
    FileOnly these types are listed: csv, csv.gz, tsv, txt, json, jsonl, ndjson, parquet, arrow, ipc, xls, xlsx, xlsm, xlsb, duckdb.
    File settingsShown 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.

    Files that Dropbox marks as not downloadable are hidden.

    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

    MessageWhat to do
    The Dropbox file changed. Run again to use the latest version.Someone changed the file after you selected it. Run again.
    Choose a writable Dropbox folderThe folder is read-only for you. Pick another.
    The selected Dropbox file is unavailable or cannot be downloadedThe file was moved or can't be downloaded. Pick another.
    Dropbox: <detail> (HTTP <code>, request <id>) Choose a writable member or team folder; the team-space root may not accept files.Save inside a folder, not at the team-space root.
    Dropbox upload completion could not be confirmed. Check the destination before running again.Look at the file in Dropbox first.
    This transfer exceeds the free 50 MB and the available usage creditsThe 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.