how to filter the rows I read from google-sheets with Java API

Question

Is there a way to use Google-sheet API to read only rows with empty cell in column X ?

This is the way i read from google-sheets today but I don't see any "filter" method.

    final ValueRange values = service.spreadsheets()
            .values()
            .get(spreadSheetId, range)
            .execute();

Answer 1

You may check the ConditionType then use the BLANK.

The cell's value must be empty. Supported by conditional formatting and filters. Requires no ConditionValues.

Here's another reference: FilterCriteria which you may use for showing/hiding rows in a filter or filter view. Use the hiddenValues[] (Values that should be hidden.) and the condition (A condition that must be true for values to be shown.) fields.