Look for examples of how to use the FilterCriteria Google Sheets API object

Question

I'm trying to figure out how to build AddFilterViewRequestin the Google Sheets API. However, there seems to be no good examples that I can find in any programming language that demonstrates how it is used.

In particular, I am trying to understand the object FilterCriteria, and I need to install hiddenValuesand conditionin.

In my application, I am trying to create a filter that will only show rows in which the cell in the selected column is not empty. I can do this manually in the Google Sheets editor, and I want to replicate the same settings in my program.

This is the code as it is ...

Request request = new Request();
request.AddFilterView = new AddFilterViewRequest();
request.AddFilterView.Filter = new FilterView();
request.AddFilterView.Filter.FilterViewId = 0;
request.AddFilterView.Filter.Title = "Hide rows with errors";
request.AddFilterView.Filter.Range = new GridRange();
request.AddFilterView.Filter.Range.SheetId = 0;
request.AddFilterView.Filter.Range.StartColumnIndex = 8;
request.AddFilterView.Filter.Range.EndColumnIndex = 9;
FilterCriteria criteria = new FilterCriteria();
//criteria.Condition = BooleanCondition;
criteria.HiddenValues = new List<string>();
//criteria.HiddenValues.Add("item");
IDictionary<string, FilterCriteria> criteriaDictionary = new Dictionary<string, FilterCriteria>();
//criteriaDictionary.Add("string", criteria);
request.AddFilterView.Filter.Criteria = criteriaDictionary;

, , - , . , string criteriaDictionary.

Answer 1

, - , . , ...

FilterCriteria criteria = new FilterCriteria();
criteria.Condition = new BooleanCondition();
criteria.Condition.Type = "NOT_BLANK";

IDictionary<string, FilterCriteria> criteriaDictionary = new Dictionary<string, FilterCriteria>();
criteriaDictionary.Add("8", criteria);

Request request = new Request();
request.AddFilterView = new AddFilterViewRequest();
request.AddFilterView.Filter = new FilterView();
request.AddFilterView.Filter.FilterViewId = 0;
request.AddFilterView.Filter.Title = "Hide rows with errors";
request.AddFilterView.Filter.Range = range1;
request.AddFilterView.Filter.Criteria = criteriaDictionary;
requests.Add(request);

, 8, , ( ). , , .

Answer 2

, (, - ), " , API, - , . FilterView ( , ).