OneDrive Input Tool Icon

OneDrive Input Tool

Version:
Current
Last modified: July 29, 2020

Use Microsoft OneDrive Input to 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.

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

Log in to OneDrive

You can log in to OneDrive with a personal or business Account type.

Log in to OneDrive Personal

  1. In Account type, select OneDrive personal.
  2. In Client ID, enter your application key. See Microsoft OneDrive to learn about authentication configurations and known limitations.
  3. Select Login.

Log in to OneDrive for Business

  1. In Account type, select OneDrive business.
  2. In Client ID, enter your application key. See Microsoft OneDrive to learn about authentication configurations and known limitations.
  3. Enter the secret key.
  4. Select Login.

Configure the Tool

  1. In Input Config, use Select to choose a file from your OneDrive instance.
  2. 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.
  3. 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.
  4. Select a File format (see tabs below).
  5. Run the workflow.

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.
Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.