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:
3

Hi @maxg

it depends on what the sharepoint API is configured to output. You may want to research the correct API endpoint to fetch the binary file. If you’re working with the API v1 you might find this helpful:

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.