# -*- coding: utf-8 -*-
# This file is auto-generated, don't edit it. Thanks.
import os
import sys
import json
from typing import List
from alibabacloud_dingtalk.doc_1_0.client import Client as dingtalkdoc_1_0Client
from alibabacloud_tea_openapi import models as open_api_models
from alibabacloud_dingtalk.doc_1_0 import models as dingtalkdoc__1__0_models
from alibabacloud_tea_util import models as util_models
from alibabacloud_tea_util.client import Client as UtilClient
class Sample:
def __init__(self):
pass
@staticmethod
def create_client() -> dingtalkdoc_1_0Client:
"""
Initialize the account Client with a Token
@return: Client
@throws Exception
"""
config = open_api_models.Config()
config.protocol = 'https'
config.region_id = 'central'
return dingtalkdoc_1_0Client(config)
@staticmethod
def main(
args: List[str],
) -> None:
client = Sample.create_client()
create_filter_view_headers = dingtalkdoc__1__0_models.CreateFilterViewHeaders()
create_filter_view_headers.x_acs_dingtalk_access_token = '<your access token>'
criteria_value_key_conditions_0 = dingtalkdoc__1__0_models.CriteriaValueConditions(
operator='less',
value='20'
)
criteria_value_key = dingtalkdoc__1__0_models.CriteriaValue(
filter_type='condition',
visible_values=[
'123'
],
conditions=[
criteria_value_key_conditions_0
],
condition_operator='or',
background_color='#FF0000',
font_color='#FF0000'
)
criteria = {
'criteriaValueKey': criteria_value_key
}
create_filter_view_request = dingtalkdoc__1__0_models.CreateFilterViewRequest(
operator_id='ppgAxxx',
name='Sales data filter',
range='A1:E20',
criteria=criteria
)
try:
client.create_filter_view_with_options('e54Lq3xxx', 'Sheet1', create_filter_view_request, create_filter_view_headers, util_models.RuntimeOptions())
except Exception as err:
if not UtilClient.empty(err.code) and not UtilClient.empty(err.message):
# err contains the code and message attributes, which help developers locate the issue
pass
@staticmethod
async def main_async(
args: List[str],
) -> None:
client = Sample.create_client()
create_filter_view_headers = dingtalkdoc__1__0_models.CreateFilterViewHeaders()
create_filter_view_headers.x_acs_dingtalk_access_token = '<your access token>'
criteria_value_key_conditions_0 = dingtalkdoc__1__0_models.CriteriaValueConditions(
operator='less',
value='20'
)
criteria_value_key = dingtalkdoc__1__0_models.CriteriaValue(
filter_type='condition',
visible_values=[
'123'
],
conditions=[
criteria_value_key_conditions_0
],
condition_operator='or',
background_color='#FF0000',
font_color='#FF0000'
)
criteria = {
'criteriaValueKey': criteria_value_key
}
create_filter_view_request = dingtalkdoc__1__0_models.CreateFilterViewRequest(
operator_id='ppgAxxx',
name='Sales data filter',
range='A1:E20',
criteria=criteria
)
try:
await client.create_filter_view_with_options_async('e54Lq3xxx', 'Sheet1', create_filter_view_request, create_filter_view_headers, util_models.RuntimeOptions())
except Exception as err:
if not UtilClient.empty(err.code) and not UtilClient.empty(err.message):
# err contains the code and message attributes, which help developers locate the issue
pass
if __name__ == '__main__':
Sample.main(sys.argv[1:])
