Formulas are generally expressions used to make calculations easier in Google Sheets. Here, we can use formulas to query a Data Source with fixed values. You can make a query by referencing a single cell or a group of cells. These formulas can be specified in the Suffix URLs and Body section.
While making a query, formulas are surrounded by three plus signs
"+++" to indicate that they are not a part of the URL.
A formula would look something like this
+++Sheet2!A2+++– This represents the cell
A2in the Sheet with the name
+++Sheet2!A3:A6+++– This represents the cells ranged from
A6in the Sheet with the name
Single cell referencing
To make a query referenced with a single cell value, provide the cell reference (For example: SheetName!A2) in the Suffix URL by enclosing the formula with three plus signs
"+++" on both sides.
If you want to make a request with referencing a cell in the Suffix URL (Lets say A3 in the above table) then it would be,
/users/+++Sheet1!A3+++– This would generate the URL like
/users?id=+++Sheet1!A3+++– This would be
Cell requests can also be made in the POST and PUT methods in the request body.
Multiple cell referencing
Multiple cell referencing is similar to single cell references. Except that the range is specified with a colon ” : “.
Lets say, we want to query by referencing the cells from A3 to A6. The formula for this would be
Making multiple cell referencing in Body,
You can also make queries by referencing from multiple columns like,
/users?gender=+++Sheet1!D2:D5+++&status=+++Sheet1E2:E5+++– This makes three request (one request per row) each having
statusfrom both columns