Support Questions

Find answers, ask questions, and share your expertise

Import files from Sharepoint

New Contributor

Hello,

 

For our project we need to download excel files from sharepoint 2013 in order to insert them into a database.  nifi is installed in a debian machine. Can someone help me I dont know how to use the API sharepoint in nifi ( or any other solution)

1 REPLY 1

Super Collaborator

Though I don't know too much about sharepoint, it seems they have an API that allows for HTTP Get requests. Look carefully at the hidden section on this page: https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/get-to-know-the-sharepoint-rest-service?t...

 

Based on the above you could use both the GetHTTP processor or the InvokeHTTP processor with a get method.

 

If this is the wrong way to access sharepoint, my general advice:

1. Figure out how sharepoint allows any program (whether it is nifi, python,...) to extract data.

2. From here it should be comparatively easy to figure out which processor you need to do this

 

 


- Dennis Jaheruddin

If this answer helped, please mark it as 'solved' and/or if it is valuable for future readers please apply 'kudos'.
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.