Actions6
Overview
This node integrates with OneDrive to manage and interact with files shared with the user. It supports operations such as listing all shared files, picking a specific shared file, querying data from Excel worksheets within shared files, clearing cached authentication tokens, and forcing re-authentication. It is particularly useful for workflows that require accessing and processing shared OneDrive files, such as extracting data from Excel sheets or managing shared documents.
Use Case Examples
- Listing all files shared with the user to display or process them.
- Selecting a specific shared Excel file to extract data from a particular worksheet.
- Querying specific rows and columns from an Excel worksheet in a shared file based on custom filters.
- Clearing cached tokens to resolve authentication issues or force a fresh login.
Properties
| Name | Meaning |
|---|---|
| Operation | The action to perform on shared OneDrive files, such as listing files, picking a file, querying sheets, clearing cache, or forcing re-login. |
| File Type | Filter shared files by their extension when picking or querying files. |
| File | Select the shared file to operate on, identified by drive and item IDs. |
| Sheet Name | Specify the worksheet name within the selected Excel file to query or extract data from. |
| Description contains | Filter PRF queries by matching text in the description field. |
| Submitter contains | Filter PRF queries by matching text in the submitter field. |
| PRF No equals | Filter PRF queries by exact PRF number. |
| Status contains | Filter PRF queries by matching text in the status field. |
| Additional Keywords | Comma-separated keywords to further filter PRF queries. |
| Date Submit (exact) | Filter PRF queries by exact submission date (YYYY-MM-DD). |
| Cache Duration (minutes) | Duration to cache downloaded files before refreshing, used in querying operations. |
| Columns to Extract | Select one or more columns from the worksheet to extract data from. |
Output
JSON
name- Name of the shared file or worksheet item.id- Identifier of the selected file.success- Indicates success status of operations like clearing cache or re-login.message- Descriptive message about the operation result.timestamp- Timestamp of the operation result.userCode- User code for device authentication when required.verificationUri- URL for device authentication verification.whatsappSent- Indicates if WhatsApp notification was sent for authentication.whatsappNumber- Phone number to which WhatsApp notification was sent.whatsappError- Error message if WhatsApp notification failed.
Dependencies
- Microsoft Graph API for OneDrive access
- An API key credential for OneDrive device flow authentication
- Optional WhatsApp API for sending authentication messages
Troubleshooting
- Authentication failures due to expired or invalid tokens; resolved by using the 'Force Re-login' operation or clearing token cache.
- File not found errors when the selected file ID does not match any shared files; ensure correct file selection.
- Issues with WhatsApp notifications not sending due to misconfigured WhatsApp API URL or phone number; check credentials and logs for errors.
- Errors in querying Excel worksheets if the sheet name or column names are incorrect or missing; verify selections before execution.
Links
- Microsoft Graph OneDrive API - Official documentation for OneDrive API used for file operations.
- OAuth 2.0 Device Code Flow - Explanation of the device code authentication flow used for OneDrive access.