Alteryx Tool. The latest version is available from the Alteryx Analytics Gallery.
To configure a connection to Microsoft OneDrive, register a web application with Microsoft.
|Type of Support||
Read & Write
The only file types supported are CSV, JSON, and Avro.
JSON Input to Avro Output-when a workflow reads a JSON input file and intends to write the data back to an Avro file, the user must check the option to Force JSON string values on the input tool.
The Output tool will hang at 50% while pushing the data to OneDrive but will still reach 100% once completed.
The Microsoft Azure Data Lake, OneDrive, and Dynamics CRM connectors support authentication via Microsoft user credentials (i.e., email and password). In interactive workflows, it is not currently possible to authenticate with different Microsoft user accounts across these connectors. This limitation does not impact scheduled workflows. In the case that you are authenticated with a Microsoft user account in one of these connectors and then try to authenticate in another connector with a different Microsoft user account, you will see an error message pop-up similar to the following:
To resolve this issue, follow one of these recommendations:
- The Azure Active Directory Administrator can grant the necessary permissions to one user account. For example, the administrator can ensure a user's account can access all the services needed for their workflow.
- Log out of any connectors that are authenticated to a different Microsoft user account before trying to log in.
- Avoid using end user authentication when possible. Use Service-to-Service authentication in the Azure Data Lake connectors and Application login authentication in the Dynamics CRM connectors.