View All Docs
Product overview
Account overview
Integrations
Transforms
Security
Hide Navigation
Product overview
Account overview
Integrations
Transforms
Security

Pull from OneDrive

The Pull from OneDrive step gives you the ability to pull in datasets from your Microsoft OneDrive files.

Connect your OneDrive account

To connect your OneDrive account, click Authorize to login with your Microsoft account credentials.

Selecting a file

To select the specific file you want to work with:

  1. Select the drive - the dropdown will show all drives that you have access to
  2. Search for the specific file you’re looking for - you can enter a term or paste in the entire file name. The dropdown will show all matching files
  3. The first matching file will automatically appear in the Results view. You can select a specific sheet, for files with multiple

File types supported

  • XLS, XLSX*
  • CSV (comma (,) delimiter)
  • TSV (tab delimiter)
  • JSON
  • XML

Helpful tips

  • This step pulls data in exactly as it is shown in OneDrive. Formatted dates and numbers will be pulled in and shown in their formatted state. Visual formatting, such as colors, font changes, or sizing will not show up in Parabola.
  • Any changes you make to the OneDrive file will be automatically updated when you run a Flow, or manually updated if you click the refresh icon to the right of the step's name.
  • *The Microsoft API has a size limit for Excel workbooks of 100 MB. Attempting to pull an Excel workbook greater than 100 MB will result in an error, and you will be prompted to reduce the size of your workbook. This does not apply to .xls file extensions, only .xlsx.

Related Recipes

Send to OneDrive

The Send to Microsoft OneDrive step gives you the ability to automate sending custom datasets to OneDrive. You can create a new file or update a file by having the dataset overwrite or append (add on) to an existing file.

Connect your OneDrive account

To connect your OneDrive account, click Authorize to login with your Microsoft account credentials.

Custom settings

First, select whether to create a new file, or update an existing file.

Create a new file:

Select the file type, and enter a file name. Then, indicate which drive the file should be saved to. Within a drive, you can either save to the root of the drive (default), or search for a specific folder to save to.

Send to OneDrive: create a new file

Update an existing file:

First, choose the file you want to update by selecting a drive. Then, search for the file by name.

Once your file is selected, you can decide how to update it:

  1. Replace entire file - all file types
  2. Append to bottom - Excel files only

(Note, you can specify which sheet of an Excel file to update.)

Send to OneDrive: update an existing file

File types supported

  • XLSX
  • CSV (comma (,) delimiter)
  • TSV (tab delimiter)
  • JSON
  • XML

Helpful tips

  • Updates to Excel workbooks can take up to several minutes to be reflected in OneDrive.
  • The Microsoft API has a size limit for Excel workbooks of 100 MB or 1,048,576 rows by 16,384 columns. (Read about other limits here.)
  • If the size of the workbook you want to update already exceeds 100 MB or the max row and column limit, the API will return an error when Parabola attempts to fetch workbook metadata.
  • If you are overwriting a worksheet and the data you're sending exceeds 100 MB or the max row and column limit, the Flow calculation will return an error. If you are appending to a worksheet and the data you're sending exceeds the remaining space of your workbook or will result in max row and column limit being exceeded, the Flow calculation will also return an error. In both cases you will be prompted to reduce the size of either your workbook or input data.

Related Recipes