h5YRLFaZ

1<?php
2//...
3public function get($collection="My Friendly Sheet Name",$sheet="",$range="") {
4	$api    = (isset($_GET["sheet"])) ? true:false;
5	$result = [];
6
7	$keys   = array("collection","sheet","range");
8	foreach ($keys as $k) {
9		$$k = (isset($_GET[$k])) ? $_GET[$k]:$$k;
10        if (!$$k) $result = ["success"=>false,"msg"=>"Missing key: $k"];
11	}
12
13    if (!$result) {
14    	$spreadsheetId = $this->collection[$collection];
15        $range  = "$sheet!$range";
16        $result = $this->_sheets->spreadsheets_values->get($spreadsheetId, $range, ['majorDimension' => 'ROWS']);
17	}
18
19	echo json_encode($result);
20}
21//...
22?>