This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
This article is part of the Tool Mastery Series, a compilation of Knowledge Base contributions to introduce diverse working examples for Designer Tools. Here we’ll delve into uses of the OneDrive Tools on our way to mastering the Alteryx Designer:
The OneDrive tools do not come installed standard with Alteryx. To install them, you can find them here, or by searching for “OneDrive” in the Alteryx Gallery.
Connecting to OneDrive:
There are two different modes for authentication depending on whether the OneDrive account you'd like to connect to is Personal or for Business. For either form of authentication, you will have to register a new application with Microsoft and create a Client ID. If the account type is business, you will also need to generate a secret key.
2. When prompted, sign in with your account credentials.
3. Find My applications and click Add an app:
4. Enter your app's name and click Create
5. Once the app is created, an application ID will automatically be created. This is the Client ID that is used in Alteryx to log into the app.
6. If you are using the application for a OneDrive Business account (organization account) you will need to generate a password. This will be entered as well as the Client ID when logging in from the OneDrive tool in Alteryx:
7. Next, you will need to choose the platform that the app will be using to connect. Choose Web:
8. Once the platform is added, the configuration options for the platform will appear. Make sure the checkbox for “Allow Implicit Flow” is selected and use the standard Microsoft redirect URL for the Redirect URL. The Logout URL is not necessary for this application:
9. After you have created the platform, you will have to set permissions for the application. There are at least two delegated permissions required to use the tool (Files.ReadWrite, and offline_access). You can add and remove permissions by selecting the “Add” button. This will show a list of permissions that you can then check if you wish to grant them to the application.
Note* You can achieve necessary permission for the application by selecting other permissions as well. The permissions listed above are the bare minimum for the Alteryx tool to access OneDrive.
Error when reading in JSON: “list index out of range”
Check to make sure that JSON formatting within the files is correct.
By now, you should have expert-level proficiency with the OneDrive Input and Output tools! If you can think of a use case we left out, feel free to use the comments section below! Consider yourself a Tool Master already? Let us know at email@example.com if you’d like your creative tool uses to be featured in the Tool Mastery Series.
Stay tuned with our latest posts everyTool Tuesday by followingAlteryx on Twitter! If you want to master all the Designer tools, considersubscribing for email notifications.