OneDrive Input Tool

Use the Microsoft OneDrive Input tool to read files stored in a OneDrive instance into Designer. See Microsoft OneDrive to learn about authentication configurations and known limitations. More information about Microsoft OneDrive can be found on the Microsoft OneDrive documentation site.

Gallery tool

This tool is not automatically installed with Designer. To use this tool, download it from the Alteryx Analytics Gallery.

Configure the tool

In Input Config, click Select to select a file from your OneDrive instance.
Click the Select button to display a file picker with the file system data from your OneDrive instance. Expand the directories to view their respective files and directories. Directories cannot be selected and only one file may be selected.
When a new file selection is made in the File Picker, the selected file box will display the path to the selected file. The selection displayed in this box cannot be manually edited and must be edited through the file picker.
Select a File format.
- Avro: Sets the file format to Avro. See Microsoft OneDrive to learn about authentication configurations and known limitations.
- CSV:
  - Use Code Page Selection to select the encoding of the data from the file.
  - Use Field Delimiter Selection to select a field delimiter between fields. Options are Comma, Pipe, Space, or Tab.
  - Select the First Row Contains Names check box to set the first row of data as column headers.
  - Use Max Field Length to set the maximum length of each field, allowing control over string cut off.
  - Quote Character determines quote character. Options are Backtick, Double Quote, and Quote.
  - Use Start data on line to select which line to start the import.
- JSON:
  - Select Force JSON String Values to force all values of the JSON input file to have string types.
  - Use Max Field Length to set the maximum length of each field, allowing control over string cut off.
Run the workflow.