I'm not sure I have an answer to your question. I do have an answer to mine.
I was trying to push up an Excel file to my SharePoint Site that is http and not https.
The format is:
Note: do not add http: to the front of that path
and if you have a space in your Library Name or other parts of the path then you need to add %20 where the space would be.