1 Support questions or comments

• 
  May 6, 2021
  savsani Purchased

  Que.-1
  
  What is quota or usage limit for google apps script?
  
  I couldn't find exactly here: https://developers.google.com/apps-script/guides/services/quotas
  
  Can you let me know for this one, how much free requests it is offering for this type of API?
  
  Que.-2
  
  Google Sheets API v3 is going to shutdown on June 8, 2021 We have any impact of it on this API?
  
  Que.-3
  
  Suppose I have a column named category where i have three categories like cat1, cat2, cat3 How can i get json data filter by specific category like cat1 data only?
• 
  May 6, 2021
  alidemir Author

  Hi savsani,
  
  
  First of all, there is no limit to adding or reading data to SpreadSheet.
  
  1-
  Throwing a request takes an average of 1 second.
  
  2-
  This API is independent of Google Sheets API v3 and will not be affected.
  
  3-
  Entering an ID is enough to get a data:
  [123, "Data 1", "Data 2", "Data 3"]
  In this way, we will be able to access all the data in the row.
  
  So there is no method yet to get it as JSON.
  I did this and uninstall it back because I thought it was slow.
  I think I'll add it again, so if user want can use it.
  
  A support within the pillars might be good. I will evaluate them.
  
  Thanks.
• 
  May 11, 2021
  alidemir Author

  @savsani,
  
  I brought JSON support for adding, reading and updating.
  Download and update you will find information in the documents.
  
  If you can't update it, let me know.