TypeError: Cannot read property 'parameter' of undefined (line 11, file "Code") in app script

Question

    function doGet(e){
handleFunction(e);

}

function doPost(e){
handleFunction(e);

}



function handleFunction(request){



var name = request.parameter.name;

var number = request.parameter.number;
var ss =    SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1afoMQY/edd=0");



 var sheet = ss.getSheetByName('South Clubhouse');
  var rowContent = sheet.appendRow([name,number]);
}

I tried running it through postman several times I doesn't work. The params aren't working. What should I do to make it work properly?

Your code did work for me when I tested it. Could you provide more information? Which line is causing this issue? Because the line "11" has nothing on it. — Jescanellas
– Jescanellas, Commented Mar 10, 2020 at 11:13

Anees Hameed · Accepted Answer · 2020-03-07 17:58:22Z

2

doPost and doGet deals with payload in different ways.

function doGet(e){
  var data = e.parameter;
  handleFunction(data);
}

function doPost(e){
  var data = e.parameter.data
  handleFunction(data);
}

function handleFunction(data){
  var name = data.name;
  var number = data.number;
  var ss =   
    SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1afoMQY/edd=0");
  var sheet = ss.getSheetByName('South Clubhouse');
  sheet.appendRow([name,number]);
}

answered Mar 7, 2020 at 17:58

Anees Hameed

6,6322 gold badges43 silver badges45 bronze badges

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

1 Comment

Cooper Over a year ago

I don't mean to be argumentative but I don't think that's correct. But I could be wrong.

Collectives™ on Stack Overflow

TypeError: Cannot read property 'parameter' of undefined (line 11, file "Code") in app script

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related