Good day, about the fourth day I suffer. I can not find the actual way to connect to google docs Spreadsheets and extract data from them. I tried using Zend Gdata (downloaded from the site) to connect by specifying a username and password, an exception was raised: DOMDocument cannot parse XML ... (After reading it in the internet I came across more than once, because of the reason for updating google auth 1.0 - > auth 2.0, but not sure for sure). I tried the second option, according to google's instructions , where at the end you need to run a script from the command line and get the code, but in the end I got an error in the console. The third option, I used the instructions , but there was no Spreadsheets library for working with tables. I tried the options myself, samopisnye, but did not succeed. Tables are not mine, I can not edit them, there is only a link. If someone worked with this miracle or there is a link to a working resource, pliz help out. It would be ideal, of course, if there is a step-by-step instruction, I just need to pull out the table, in the form of an array or the whole, I’ll pull out everything I need with js.

  • I tried, according to google's instructions ... but in the end I gave an error in the console. , what mistake? - Max
  • Maxim Kind, this kind of error, in response to the verification code I sent: Fatal error: Uncaught exception 'GullHTp \ Exception \ RequestException' with mes sage 'cURL error 60: SSL certificate problem (see curl. haxx.se/libcurl/c/libcurl-errors.html ) 'in C: \ xampp \ htdocs \ temp.site \ google-api-php-client \ vendor \ guzzlehttp \ guzzle \ src \ Handler \ CurlFactor y.php: 187 Stack trace: - Peter Litvinovich
  • Continued: # 0 C: \ xampp \ htdocs \ temp.site \ google-api-php-client \ vendor \ guzzlehttp \ guzzle \ src \ Handler \ CurlFactory.php (150): GuzzleHttp \ Handler \ CurlFactory :: createRejection (Ob ject (GuzzleHttp \ Handler \ EasyHandle), Array) # 1 C: \ xampp \ htdocs \ temp.site \ google-api-php-client \ vendor \ guzzlehttp \ guzzle \ src \ Handler \ CurlFactory.php (103): GuzzleHttp \ Handler \ CurlFactory :: finishError (Object (GuzzleHttp \ Handler \ CurlHandler), Object (GuzzleHttp \ Handler \ EasyHandle), Object (GuzzleHttp \ Handler \ CurlFactory)) - Peter Litvinovich
  • Continued: # 2 C: \ xampp \ htdocs \ temp.site \ google-api-php-client \ vendor \ guzzlehttp \ guzzle \ src \ Handler \ CurlHandler.php (43): GuzzleHttp \ Handler \ CurlFactory :: finish (Object (Guzzl eHttp \ Handler \ CurlHandler) Object (GuzzleHttp \ Handler \ C in \ Hampp \ htdocs \ tem p.site \ google-api-php-client \ vendor \ guzzlehttp \ guzzle \ src \ Handler \ CurlFactory.ph p on line 187 - Peter Litvinovich

1 answer 1

Full Google documentation: spreadsheets.values .

  • Although the link can find the answer to the question, it is better to point out the most important thing here, and give the link as a source. If the page to which the link leads will be changed, the response link may become invalid. - From the queue of checks - br3t
  • The link leads to google api, if the page is changed, then the solution specified here will not work. - Mikhail Zamkevich
  • @MikhailZamkevich, the function name is the answer regardless of the link. - Qwertiy ♦