search

asimlqt / php-google-spreadsheet-client

A PHP library for accessing and manipulating Google Spreadsheets
Other
543 stars 154 forks source link

Fatal error: Uncaught Google\Spreadsheet\Exception\BadRequestException: #168

Closed nekromoff closed 5 years ago

nekromoff commented 7 years ago

new lines added for readability:

<?xml version='1.0' encoding='UTF-8'?>
<entry xmlns='http://www.w3.org/2005/Atom' xmlns:gsx='http://schemas.google.com/spreadsheets/2006/extended'>
<id>https://spreadsheets.google.com/feeds/list/1j0N4Lgp4tDwR7xPWinL9g5qap3vW8dHjKq-nuj_uWzw/od6/private/full/cpzh4</id><updated>2016-10-18T15:07:17.430Z</updated>
<category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#list'/>
<title type='text'>XXX YYY</title>
<content type='text'>d4: 4, d5: 9, d6: 9</content><link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/1j0N4Lgp4tDwR7xPWinL9g5qap3vW8dHjKq-nuj_uWzw/od6/private/full/cpzh4'/>
<link rel='edit' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/1j0N4Lgp4tDwR7xPWinL9g5qap3vW8dHjKq-nuj_uWzw/od6/private/full/cpzh4/adohmdg'/><gsx:meno>XXXX YYY</gsx:meno><gsx:d1>
</gsx:d1><gsx:d2></gsx:d2><gsx:d3></gsx:d3><gsx:d4>4</gsx in /var/www/html/basecamp/vendor/asimlqt/php-google-spreadsheet-client/src/Google/Spreadsheet/DefaultServiceRequest.php on line 359
nekromoff commented 7 years ago

bump, still happening on complex sheets, where: if (vlookup ... ( importrange .... is used, in this order

adddz commented 5 years ago

@nekromoff Were you able to find a solution? I get the same error when I'm writing thousands of rows into a Google Spreadsheet document from my app.

nekromoff commented 5 years ago

Better internet connection only. Slow wifi seems to cause this error