I have tried to use SheetsAPI to interact with my google sheets and i could do that. API brings in all the records based on my range.Now i would like to apply filter while reading the sheets and retrieve the data based on my query not the whole records. Is there a way to do it?
I am using the get() to retrieve the records. String spreadsheetId = "someId"; String range = "CSP!A2:AF"; ValueRange response = service.spreadsheets().values().get(spreadsheetId, range).execute(); -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
