We currently have a POC that requires for us to ingest a file from sharepoint through NIFI (REST API). When we tried using the SP documentation the SP team confirmed that our URL is correct <sp_url>/_api/Web/Lists. But it provides a failure code 503: Service Unavailable.
1.) Given that the authentication we used is correct? Is there a different way of requesting a GET request (access token, client credential, etc?
2.) Should we request Firewall to be open between NIFI cluster and SharePoint site?
3.) Has anyone tried this before? If yes, can you provide a sample configuration of the INVOKEHTTP processor and the sample output?