function loadResults(currentNumber)
{
// following PUT is for updating a cell
//PUT var url = “https://sheetsu.com/apis/v1.0su/{sheetsu API}/{column_name}/{value}?{column_name}={new_value)”;
var pastSearch = local.getItem("pastSearch");
var url = "https://sheetsu.com/apis/v1.0su/{SheetsuAPI}/{column_name}/
//building full URL for updating a cell as in example above
//currentNumber passed in from another function, this would be whatever you wanted to update cell with
var urlfull = url + pastSearch + “?Column=” + currentNumber;
local.setItem(“pastSearch”,currentNumber);
//saves the new cell value as you need the cell value to tell sheetsu what cell to look for
//calls sheetsu url with method put. I tried sending a JSON string with it as described in the sheetsu doc but couldnt get that to work so I built the URL string
fetch(urlfull, {method: ‘put’})
}
That example is for PUT and updating a single cell. GET or adding a row with POST should be even easier. I used the Postman API program on windows to test API calls. When you make a call in that program is shows you what the correct URL it used was. You can also use Hurl.it to test API calls.
{column_name} = first cell in column
{value} = sheetsu searches down the column with column_name for value
{sheetsu_api} will be given to you when you make a sheetsu.com account and share whatever spreadsheet your working with.
https://docs.sheetsu.com/?html--javascript#search-spreadsheet is the sheetsu doc to go over what calls you can use