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)
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