This is indeed very helpful.
For clarity, the data I'm trying to access is not a google app. It has it's own (secure) WSDL and database. So, I want to pull data from there into a google spreadsheet, with script inside the spreadsheet. Essentially, my question is:
If for a google app, the code is:
https://www.google.com/accounts/ClientLogin
Authorization: GoogleLogin auth=yourAuthValue
Where would I find the language to do this for the application that I want to pull data from? Would I have to request that directly from the developers of the application, or would it be in the WSDL, or is there a standard?
Basically, to access the WSDL, I need to log-in. I need to know how to add the log-in information to my SOAP call. I'm very new to this, but I'm a zippy learner! Thanks for your help.