OneDrive Output Tool
Use the OneDrive Output tool to write files from Designer to OneDrive. Go to Microsoft OneDrive to learn about known limitations. More information about Microsoft OneDrive can be found on the Microsoft OneDrive documentation site.
To maintain full functionality of the OneDrive data connector, note compatibility with Designer.
Connector Version 2.0.1 and Later | Designer version 2021.3.3 and later. |
Connector Version 2.0.0 | Designer versions 2021.2.1-2021.3.1. |
Note
This tool is not automatically installed with Designer. To use this tool, download it from the Alteryx Community.
Sign In to OneDrive
The OAuth method is used for authentication, so you can either use the default Alteryx application by selecting Sign in via Internet Browser or you can provide your own API application by selecting Provide authentication information. Go to Microsoft OneDrive for more information on how to create an API application.
To schedule your workflow on Server when using the Cloud services, you need to select Use Service Principal after selecting Provide authentication information so that your token has an extended expiration, and you need to provide your own API application.
Sign In via Internet Browser
- In Authentication Method, select Sign in via Internet Browser.
- Click Connect.
- Enter your credentials and sing in.
Provide Authentication Information
- In Account type, select OneDrive business.
- Enter Client IDenter your application key. Go to Microsoft OneDrive to learn about authentication configurations and known limitations.
- Enter your secret key.
- Select Login.
Select a File
- Select which files to display in the Files to display dropdown menu. Options are Personal Files, Recent, and Shared with me.
- Select the folder the file in the file tree or search for it by its name. You can also enter the file path in the File Path field.
- Use Existing File Action in the Options tab to select the handling of an existing file.
- Rename: The Rename option will rename the file (appending a unique number to the end of the filename.)
- Overwrite: Overwrite option will delete the existing file and write the new file contents.
- Append: Append option will add the new data to the existing file.
- Abort: When Abort is selected, the file will not upload if there is another file with the same name.
Warning
If you select the Overwrite or Append options in Existing File Action, the updated sheet becomes the first sheet in the file. This can impact tools using the order numbers of sheets.
Add a Folder
- Navigate to the folder where you want to add a folder.
- Click Add Folder.
- Select By Name and type the name of the new folder. Designer adds the folder without the need to run the workflow.
- Select By Field to add multiple folders based on a specified field from the data.
- Enter the name of the new files in the File Name field.
Important
The File Name field requires the file name including the file type extension.
- Run the workflow to add the folders.
Add a File
- Navigate to the folder where you want to add a file.
- Click Add File.
- Select By Name and enter the name of the new file.
Note
The File Name field requires the file name including the file type extension.
- Select By Field to add multiple files based on a specified field from the data.
- Run the workflow to add the file.
Select a File Format
The file format is detected automatically when you select a file. To read multiple files from a folder and its subfolders, you need to manually select the file type in the Options tab.
XLSX
- Data Range options specify which sheets contain the data. Options are By Sheet Name and By Field.
Warning
If you select the By Field option, multiple sheets will be created and named based on the value selected in Select Field.
- Enter the cell in Start in cell to specify the start of data output.
- Select Write headers to include headers in the output data.
- Select Code Page to determine the encoding of the data.
CSV
- Use Max Field Length to set the maximum length of each field, allowing control over string cut off.
- Use Field Delimiter to select a field delimiter between fields. Options are Comma, Semicolon, Tab, Pipe, Space or Custom delimiter.
- Select Write headers to include headers in the output data.
- Use Quote Character to select a format of the quote. Options are None, Single, Quote, Double, Quote, or Custom.
- Select Code Page to determine the encoding of the data.
YXDB
No options.