OneDrive: Shared With Me icon

OneDrive: Shared With Me

List, pick, or query PRF sheet in shared OneDrive files
Join our community

Actions6

Overview

This node interacts with OneDrive shared files, allowing users to list shared files, pick a specific shared file, query Excel worksheets within shared files, clear the token cache, and force re-login for authentication. It is useful for workflows that need to access and manipulate shared OneDrive documents, especially Excel files, for data extraction and processing.

Use Case Examples

  1. List all shared files in OneDrive to select a file for further processing.
  2. Pick a specific shared Excel file shared with the user and extract data from a specified worksheet.
  3. Query specific columns from an Excel worksheet in a shared file based on filters like description, submitter, PRF number, status, and date.
  4. Clear the cached authentication tokens to reset the authentication state when needed.

Properties

Name Meaning
Operation The action to perform on OneDrive shared files, such as listing files, picking a file, querying sheets, clearing token cache, or forcing re-login.

Output

JSON

  • success - Indicates if the operation was successful.
  • message - Descriptive message about the operation result.
  • timestamp - Timestamp of when the operation was performed.
  • name - Name of the shared file (for list and pick operations).
  • id - ID of the selected shared file.
  • userCode - User code for device authentication (for re-login).
  • verificationUri - Verification URL for device authentication (for re-login).
  • whatsappSent - Indicates if a WhatsApp notification was sent (for authentication steps).
  • whatsappNumber - WhatsApp number to which the 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 can be resolved by using the 'Clear Token Cache' or 'Force Re-login' operations.
  • File not found errors occur if the selected file ID does not match any shared files; ensure the file is shared and selected correctly.
  • WhatsApp notification failures may happen if the WhatsApp API URL or number is not configured properly; check credentials and network connectivity.

Links

Discussion