title: google apps script doGet
body: <p>I'm having problems with this code.  Google deprecated several pieces that were working. Now when making a new sheet and trying to use the old code, I get errors and can't find the way to make changes with the documentation at google.</p>
  
  <pre><code>function doGet(e) {
  
      //This is not working?
  
      if (typeof e.parameter.id  == 'undefined'){     
          return no_id(e) // The URL doesn't have an ?id=345 on the end!
      }
  
      var id = parseInt( e.parameter.id ) // This is the id of the row in the spreadsheet.
  
      //Script properties is changed and I think it is now: PropertyService.getScriptProperties() // Get the data from the spreadsheet and get the row that matches the id
  
      var this_spreadsheet_id = ScriptProperties.getProperty('this_spreadsheet_id')
      var ss = SpreadsheetApp.openById(this_spreadsheet_id)
      var sheet = ss.getSheetByName("Sheet1")
      var range = sheet.getDataRange()
      var last_row = range.getLastRow()
      var last_column = range.getLastColumn()
  
      for(i = 2; i &lt;= last_row ; i++){
  
          var this_row = sheet.getRange(i,1 , 1, last_column)
          var values = this_row.getValues()[0]
          var row_id = parseInt( values[0] )
  
          //row id == id is not working either
  
          if ( row_id == id){        
              var title = values[5]
              var details = values[8]
              var status_txt = values[7]
  
              Logger.log( "STATUS: " + status )
  
              var image_url = values[4]
          }
      }
  }
  </code></pre>
  
  <p>Any idea's would be great!</p>
  
  <p>Thanks,</p>