Zend GData Google Spreadsheets Error – The Dreaded 400 Error ‘We’re sorry, a server error occurred’!

By Cornel
9 · 01 · 11
google · Google Apps · Google Spreadsheets · PHP · Troubleshooting · Zend GData

Finally Found a solution to the following Error Message when inserting a new Row into a worksheet:

Expected response code 200, got 400 We’re sorry, a server error occurred. Please wait a bit and try again.

The Fix: Your column header values must be lower case, they can’t be Capitalized!

so this:

array("Name"=>"YOURNAME",
      "Email"=>"youremail@fakeemail.com");

Must be converted to resemble:

array("name"=>"YOURNAME",
      "email"=>"youremail@fakeemail.com");

I hope this helps. Took me a day of researching to find this fix.

h/t: http://www.ayasoftware.com/content/magento-how-work-google-spreadsheets

Latest Articles

New Year’s Resolutions for Your Site

by | Jan 10, 2020 |

2020 has arrived, and the desire to make positive changes in order to better your site has come with it! With a new digital decade upon us, it’s time to stop and think about how you can elevate your site and your business. Here are a few site “resolutions” to consider...

read more

Tips to “Sleigh” Your Holiday E-Commerce

by | Oct 25, 2019 |

    From the latest Google Livestream on October 16, 2019, we learned some tips in order to spruce up our holiday marketing plans. The holiday season is a great time for small businesses to attract new customers and bring back previous ones and following...

read more

Give Your Website a Refresh

by | Mar 11, 2019 | ,

From the latest Google Livestream from March 6, 2019, we learned the 5 ways in which we can hit the ‘refresh’ button on our website. If you feel like your site is not getting much traffic, is not performing well or just needs an overall spring cleanup, then these 5...

read more

5 Reasons to Switch to the J2SE 5 Platform

by | Jun 15, 2018 |

The J2SE 5.0 platform released back in the early 2000s with a purpose of adding new features to the existing Java framework. There have been multiple updates that enabled it to work based on real-world models. In addition, the testing of software running on this kit...

read more