How to accept variable amount of parameters in Google Sheets

Question

Im building a solution in which the amount of parameters added to a HTTP get request is variable. This means the url can carry 1 to n amount of parameters. The parameters in the URL are identified with a standard name and attached index. Here is a sample URL:

https://script.google.com/macros/s/xxxxxxx/exec?fileName=2020-12-15&fridgeItems=2&fridgeItem0=ValueOfFridgeItem0&fridgeItem1=ValueOfFridgeItem1

How do I interpret the variable amount of Parameters in my doGet() Function in .gs?

EDIT: I want to create with this request the header of a new google sheet. The variable amount of parameters are supposed to be the column headers. E.g. if the request contains 5 parameters, i want to add in the first row of the google sheet into column 1 to 5 the respective value of the parameters.

I tried following code but it is not working:

function doGet(request) {
var FileNameString = request.parameter.fileName; //name of the new .gs file
var FridgeItems = request.parameter.fridgeItems; //amount of parameters/column headers passed to .gs

var sheet = SpreadsheetApp.create(FileNameString);

   for(var i=0; i

user_10612011 · Answer

Goal:

When a GET request is made, you want to create a new spreadsheet whose name will be the value of the request parameter key fileName, and all the other values from all the other request parameters will be appended to the only sheet of the created spreadsheet.

Issues:

You don't know how to loop through the different request parameters.
You are providing a Sheet (that's what's returned by the method appendRow(rowContents)) as an argument of setValues(values). This is not a valid argument; you should provide a 2D array instead.

Solution:

Retrieve the value from fileName and remove this property from the object request.parameter, using the delete operator.
Since you want the values of the rest of parameters, you can use Object.values() to retrieve an array with these values.
Use Spreadsheet.appendRow() in order to append these values to the created spreadsheet.

Code snippet:

function doGet(request) {
  const parameters = request.parameter;
  const fileName = parameters.fileName;
  delete parameters.fileName;
  const headers = Object.values(parameters);
  const spreadsheet = SpreadsheetApp.create(fileName);
  spreadsheet.appendRow(headers);
  return ContentService.createTextOutput("Headers appended!");
}

Edit:

If you want to make sure the headers are set in the same order as in the query, you can use request.queryString instead, which returns the query string portion of the URL, so in this case would be like:

fileName=2020-12-15&fridgeItems=2&fridgeItem0=ValueOfFridgeItem0&fridgeItem1=ValueOfFridgeItem1

You could then use a combination of map and filter in order to retrieve the values (excluding the one corresponding to fileName):

function doGet(request) {
  const headers = request.queryString.split("&")
                                        .map(param => param.split("="))
                                        .filter(param => param[0] !== "fileName")
                                        .map(param => param[1]);
  const fileName = request.parameter.fileName;
  const sheet = SpreadsheetApp.create(fileName)
  sheet.appendRow(headers);
  return ContentService.createTextOutput("Headers appended!");
}