OneDrive Input Tool Icon

OneDrive Input Tool

Version:
Current
Last modified: January 03, 2020

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.

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. Click 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. Click Login.

Tool Configuration

  1. In Input Config, click Select to select 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.