I'm trying to call a corporate Sharepoint REST API in order to retrieve a list data. When I use the browser I'm able to call the API (I use Restlet Client to test) provided I log first into the Sharepoint site.

I already succeeded to create a console program that asks me for the user/password by a second browser screen, but I'm looking for a solution that handles the http traffic necessary to authenticate automatically to the Sharepoint, without any human intervention.

This example (Make a RESTful API Call to SharePoint Online from Console program) goes really close, but it fails with a "Data Encryption Key (DEK) has not been uploaded to the site" error.

Does anyone know how to connect directly into the Sharepoint REST API without having to install/configure anything in the Sharepoint server?

PS: It's an Office 365 Sharepoint site, and I have access only to a specific subsite.

  • What version of SharePoint are you using?
    – Chris Romp
    Jan 25, 2018 at 18:13
  • Hi Chris, it's an Office 365 Sharepoint for a big corporation
    – tcbrazil
    Jan 25, 2018 at 18:23

1 Answer 1


I'm not sure how well SharePoint actually supports 'console programs' other than PowerShell...

But with PowerShell it does generally ask for a credentials input like you specified. https://technet.microsoft.com/en-us/library/fp161372.aspx

To automate this you would probably have to use CSOM, but check out the PnP SAML/ CSOM solution here


Or This Question over on stack overflow

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.