Download file/folder from sharepoint using Curl/Wget automatically

Question

I have been trying to use Curl and wget to download file from Sharepoint. I am planning to make it as Script which runs automatically everyday and download the file from URL.

I tried using CURL with following command

curl -O --user Myusername:Mypassword https://OurDomain.sharepoint.com/_XXX&file=IPS_cleaned.xlsx&action=default

But it gave me error about SSL connection. I got to know that there is some existing bug in CURL 7.35 So i downgraded it to 7.22. But still gives me same error.

I also tried using Wget

wget --user=Myusername --password=MyPassword --no-check-certificate https://OurDomain.sharepoint.com/_XXX&file=IPS_cleaned.xlsx&action=default

But it still gives me error -- Unable to establish SSL connection

Can someone please let me know how i can accomplish my task

UPDATE

I was able to resolve the error in CURL. Below is the command that i gave

curl -O -L --sslv3 -A "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/525.13 (KHTML, like Gecko) Chrome/0.A.B.C Safari/525.13" --user Myusername:Mypassword 'https://OurDomain.sharepoint.com/_%7BB21r-9CA2-345DEF%7D&file=IPS_cleaned.xlsx&action=default'

Now what it downloads is a file, which when i open it shows me Login page of Sharepoint. It does not download the actual excel file.

Any reason?

Answer 1

Another potential solution to this involves taking your sharepoint link and replacing the text after the '?' with download=1:

This: https://my.sharepoint.com/:u:/g/XXX/XXXX-bunchofRandomText?e=kRlVi

Becomes this: https://my.sharepoint.com/:u:/g/XXX/XXXX-bunchofRandomText?download=1

Now, you can just:

wget https://my.sharepoint.com/:u:/g/XXX/XXXX-bunchofRandomText?download=1

*Note, this example used a single file and a link where anyone with the link could access the file (no credentials required)