HTTP Request To Read and Write Excel Files To/From SharePoint

Questions
,
1

Hello, I am trying to read an excel file from Microsoft sharePoint and manipulate it and then rewrite it and upload back into SharePoint. To do this I am using the HTTP request node which I connected to Sharepoint via Oauth2.

The issue arising is that once I read the excel document by pasting the URL into the URL field of the HTTP request node - it outputs a long string which I convert to JSON but then upon writing it to a new file it just exports as a blank excel sheet. In other similar workflows I have seen the HTTP node read the excel file into a binary data type which does not seem to automatically happen on my end. Because of this I think there may be an issue with the HTTP request node.

Thank you!

Please see workflow below:

  • **n8n version: 1.66.0
  • **Running n8n via (n8n cloud):
  • **Operating system: MacOS
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system: