Anyone know Java/Google script?

IronWolf

I'm trying to write a simple bit of script in Google sheets that will log into a website for me and grab the cookie from the header, but it isn't working. Is there anyone that knows the language and what could be wrong?

var payload =
   {
     "user_login" : "free",
     "user_pass" : "password",
   };
  var options =
   {
     "method" : "post",
     "payload" : payload,
     "followRedirects" : false
   };
  var login = UrlFetchApp.fetch("https://example.com/wp-login.php" , options);
  var sessionDetails = login.getAllHeaders()['Set-Cookie'];

Sooler

Which bit isn't working? The log in or getting the cookie?

IronWolf

Sooler wrote: »

Which bit isn't working? The log in or getting the cookie?

The login

I found some better code specifically for wordpress, but still not working

var options = {
      "method": "post",
      "payload": {
      "log": "free",
      "pwd": "password",
      "wp-submit": "Login"
      },
      "followRedirects": false
   };
  var login = UrlFetchApp.fetch("http://example.com/wp-login.php" , options);
   var text = login.getContentText(); 
Logger.log(text);
  var cookie = login.getAllHeaders()['Set-Cookie'];
  Logger.log(cookie);

The webpage output is just the login form and cookie doesn't exist.

I've tried it without redirects=false as well and still the same problem.

fannyadams

you're missing a comma but I can't see where exactly.

IronWolf

fannyadams wrote: »

you're missing a comma but I can't see where exactly.

How do you know that's the problem?
I've looked through and can't see anywhere that a comma is missing :S

IronWolf

Nevermind, I found an alternate solution using basic authentication if anyone is interested

http://stackoverflow.com/questions/23546255/how-to-use-urlfetchapp-with-credentials-google-scripts

The cookies thing just never seemed to work

Sooler

This method has a bit more code for working with cookies

http://stackoverflow.com/questions/19567105/how-to-fetch-a-wordpress-admin-page-using-google-apps-script