Unfortunately the API doesn't support retrieving values based on filters. The filters control how the spreadsheet data is presented in the application, but the underlying cells remain in place, and that is what the API operates on.
- Eric On Monday, December 4, 2017 at 10:06:37 AM UTC-5, Arun wrote: > > 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.
