Ha! I see your crappy UI in PeopleSoft, with hard to automate edge cases, and I raise you multiple SharePoint instances! Ante up at your peril in this game :/)
I've managed to automate SharePoint data uploads and downloads using the SOAP API.
I have too, and the OP got Peoplesoft to work.
But ... my goodness the effort compared to a proper jason APInis huge and compared to just web scraping HTML. I mean there is a word file someone just uploaded. That's three clicks