Google Apps Script Web App authenticate on external website

Question

I need to implement a Google Apps Script app that is used to login on a website and then if the authentication process succeed on that website the user should receive a message in the google script sidebar.

For example: the user enters his email and password and then he press the Login button, then he should be logged in on the website if the credentials are correct.

Let me know if I need to provide more details on this... I am new with Google Apps Script and I really need some help with this login process. Thank you!

I tried to implement the following code but I receive the following error message when executing the login function:

Request failed for https://example.com/login returned code 405.

HTML file:

<div class="form-auth">
  <label class="inline">username</label>
  <input type="text" placeholder="Insert Email"/>
</div>
<div class="form-auth">
  <label class="inline">password</label>
  <input placeholder="Insert Password"/>
</div>
<button class="btn-default">Login</button>

Google Script file:

function onOpen() {
  SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
      .createMenu('Menu')
      .addItem('Show sidebar', 'showSidebar')
      .addToUi();
}

function showSidebar() {
  var html = HtmlService.createHtmlOutputFromFile('login')
      .setSandboxMode(HtmlService.SandboxMode.IFRAME)
      .setTitle('SDR Tag Governance')
      .setWidth(300);
  SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
      .showSidebar(html);
}

function login() {
  var payload =
   {
     "username" : "[email protected]",
     "password" : "myPassword",
   };
  var options =
   {
     "method" : "post",
     "payload" : payload,
     "followRedirects" : false
   };
  var login = UrlFetchApp.fetch("https://example.com/login" , options);
  var sessionDetails = login.getAllHeaders()['Set-Cookie'];
}

Status 405 means method not allowed, Maybe your url does not require what you are sending it. Did you try doing the same login call from browser using ajax? While doing from browser console be sure you are on the same domain i.e example.com unless you have CORS disabled. — m5khan
– m5khan, Commented Jun 8, 2016 at 5:28

Valip · Accepted Answer · 2016-06-08 10:10:38Z

2

Fixed this by adding headers option:

  var headers = {
    'Connection':'keep-alive',
    'Content-Type':'application/json;charset=utf-8',
    'Accept':'application/json, text/plain, */*',
    'Cookie':'...',
  }

answered Jun 8, 2016 at 10:10

Valip

4,66025 gold badges91 silver badges157 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Google Apps Script Web App authenticate on external website

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related