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 cached authentication tokens, and force a re-login to refresh authentication. It is particularly useful for workflows that need to access and process data from shared OneDrive Excel files, such as querying specific worksheets or extracting columns from those sheets. The 'Force Re-login' operation initiates a device code authentication flow, sending a user code and verification URL via WhatsApp to facilitate re-authentication.

Use Case Examples

  1. A user wants to list all Excel files shared with them on OneDrive to select one for data processing.
  2. A workflow needs to query specific columns from a worksheet in a shared Excel file to extract relevant data.
  3. When the authentication token expires, the user can trigger a force re-login to refresh the token via device code authentication, with notifications sent through WhatsApp.

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 the operation result.
  • authenticationDetails
    • userCode - User code for device authentication (in re-login operation).
    • verificationUri - Verification URL for device authentication (in re-login operation).
    • message - Instructional message for the user during authentication.
  • name - Name of the shared file (in list or pick operations).
  • id - ID of the selected shared file (in pick operation).
  • whatsappSent - Indicates if the WhatsApp notification was sent successfully (in re-login operation).
  • whatsappError - Error message if WhatsApp notification failed (in re-login operation).

Dependencies

  • Microsoft Graph API for OneDrive access
  • An API key credential for OneDrive device flow authentication
  • WhatsApp API for sending authentication messages

Troubleshooting

  • Authentication failures may occur if the device code is not entered in time; users should promptly follow the verification URL and enter the user code.
  • WhatsApp message sending failures can happen if the WhatsApp API URL or phone number is not configured correctly in credentials.
  • File not found errors occur if the selected file ID does not match any shared files; ensure the file is shared and the ID is correct.
  • Token cache clearing might not find any cache if no tokens are stored; this is informational and not an error.

Links

Discussion