title: Google Sheets API Failing with 500
body: <p>I made this URL public a few years ago as a way to retrieve data. It was working yesterday. Today my site is crashing as it relies on this data, but google is now returning a 500 error if I try to retrieve it programmatically (through axios).</p>
  
  <p><a href="https://spreadsheets.google.com/feeds/list/1DLAVN3q758sPohCFeZlVSVRZKXzEser1SIsQnH2mvrw/ogwtdyp/public/basic?hl=en_US&amp;alt=json" rel="nofollow noreferrer">https://spreadsheets.google.com/feeds/list/1DLAVN3q758sPohCFeZlVSVRZKXzEser1SIsQnH2mvrw/ogwtdyp/public/basic?hl=en_US&amp;alt=json</a></p>
  
  <p>I have also created a code sandobox with react to demonstrate: <a href="https://codesandbox.io/embed/xjmy9vl2z4" rel="nofollow noreferrer">https://codesandbox.io/embed/xjmy9vl2z4</a></p>
  
  <p>However, I am still able to view the response in the browser if I am logged in.</p>
  
  <p>Did google recently change their API so that it is no longer possible to retrieve data this way? Is there a way to configure my axios request in such a way to continue retrieving this data?</p>
  
  <p>UPDATE:</p>
  
  <p>Issue is being tracked here: <a href="https://issuetracker.google.com/issues/131613284" rel="nofollow noreferrer">https://issuetracker.google.com/issues/131613284</a></p>
  
  <p>According to the support team: "The engineering team believes they have located the source of the problem and are rolling back to a previous build in order to resolve issue. Please stand by."</p>
  
  <p><a href="https://issuetracker.google.com/issues/131613284#comment109" rel="nofollow noreferrer">https://issuetracker.google.com/issues/131613284#comment109</a></p>
  
  <p>UPDATE:</p>
  
  <p>It seems like the issue has been resolved by rolling back to a previous build. I am no longer experiencing these issues. The link above, and the code sandbox example are both functioning. Reading the forum, it seems like others are also no longer experiencing issues. If you are still experiencing issues, I would encourage opening another (perhaps more specific) post or issue.</p>