onedrive download fails with error 401

[mrrudy]

Bug Description

other onedrive operations up to get a file work, however when trying to download error 401 is thrown. using same credentials, self-hosted instance. other users seemed to report similar issue.

{
  "errorMessage": "Authorization failed - please check your credentials",
  "errorDescription": "Unauthenticated",
  "errorDetails": {
    "rawErrorMessage": [
      "401 - \"{\\\"error\\\":{\\\"code\\\":\\\"unauthenticated\\\",\\\"message\\\":\\\"Unauthenticated\\\"}}\""
    ],
    "httpCode": "401"
  },
  "n8nDetails": {
    "nodeName": "Microsoft OneDrive1",
    "nodeType": "n8n-nodes-base.microsoftOneDrive",
    "nodeVersion": 1,
    "resource": "file",
    "operation": "download",
    "time": "13.12.2024, 21:44:23",
    "n8nVersion": "1.71.3 (Self Hosted)",
    "binaryDataMode": "default",
    "stackTrace": [
      "NodeApiError: Authorization failed - please check your credentials",
      "    at ExecuteContext.microsoftApiRequest (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/nodes/Microsoft/OneDrive/GenericFunctions.ts:47:9)",
      "    at processTicksAndRejections (node:internal/process/task_queues:95:5)",
      "    at ExecuteContext.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/nodes/Microsoft/OneDrive/MicrosoftOneDrive.node.ts:121:22)",
      "    at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/src/Workflow.ts:1394:8)",
      "    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/src/WorkflowExecute.ts:1173:27",
      "    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/src/WorkflowExecute.ts:1894:11"
    ]
  }
}

To Reproduce

add Microsoft OneDrive download file node, put as ID either static string id (from OneDrive URL) or get it from previous node like getChildren: folder (which works with the same credentials without issues).

Expected behavior

file download into data binary field

Operating System

debian 12.8

n8n Version

1.71.3

Node.js Version

v18.19.0

Database

SQLite (default)

Execution mode

main (default)

[Joffcom]

Hey @mrrudy,

We have created an internal ticket to look into this which we will be tracking as "N8N-7963"