Data360 Analyze

 View Only

  • 1.  HTTP node to GET files from SharePoint365

    Employee
    Posted 11-18-2020 00:05

    Hello,

    I would like to know if we can sen HTTP request to SharePoint using the HTTP node. If it is possible, may I know how? I wonder if anyone ever try and succeed using HTTP nodes to connect to SharePoint and get the file from SharePoint.



  • 2.  RE: HTTP node to GET files from SharePoint365

    Employee
    Posted 11-25-2020 07:44

    The HTTP node can be used to access services using REST APIs - so it could be used to access file data in SharePoint (though I've not tried it myself).

    The documentation on the SharePoint REST API is here:

    Working with folders and files with REST | Microsoft Docs

     

    This is the API to retrieve a file:

    GET https://{site_url}/_api/web/GetFolderByServerRelativeUrl('/Folder Name')/Files('{file_name}')/$value
    Authorization: "Bearer " + accessToken

    You would need to obtain your access token before the API could be used.

    There is a roadmap candidate item to create nodes to access SharePoint365. However, this is not assigned to a target release at this time.

     



  • 3.  RE: HTTP node to GET files from SharePoint365

    Employee
    Posted 11-26-2020 06:05

    To send GET request in HTTP nodes, the body should be empty. I have tried bearer but failed.