google Ads

[maryamznegui]

Hello,
im trying to generate a report of historical metrics data from keyword plan service from google Ads and im getting below error :
my docker image is running python 3.9 and based on below error it looks there an issue with grpcio lib
Any idea about this?
PS: i tried the same script in my machine with python 3.10 and is working fine

[2023-05-18, 12:04:22 UTC] {logging_interceptor.py:271} WARNING - Request made: ClientCustomerId: None, Host: googleads.googleapis.com, Method: /google.ads.googleads.v13.services.KeywordPlanService/GenerateHistoricalMetrics, RequestId: None, IsFault: True, FaultMessage: None
[2023-05-18, 12:04:22 UTC] {taskinstance.py:1768} ERROR - Task failed with exception
Traceback (most recent call last):
File "/usr/local/lib/python3.9/site-packages/airflow/operators/python.py", line 175, in execute
return_value = self.execute_callable()
File "/usr/local/lib/python3.9/site-packages/airflow/operators/python.py", line 192, in execute_callable
return self.python_callable(*self.op_args, **self.op_kwargs)
File "/usr/local/airflow/dags/googleads/googleads_keyword_planner.py", line 34, in generate_historical_metrics
response = keyword_plan_service.generate_historical_metrics(keyword_plan=str(resource_name))
File "/usr/local/lib/python3.9/site-packages/google/ads/googleads/v13/services/services/keyword_plan_service/client.py", line 848, in generate_historical_metrics
response = rpc(
File "/usr/local/lib/python3.9/site-packages/google/api_core/gapic_v1/method.py", line 113, in call
return wrapped_func(*args, **kwargs)
File "/usr/local/lib/python3.9/site-packages/google/api_core/grpc_helpers.py", line 72, in error_remapped_callable
return callable_(*args, **kwargs)
File "/usr/local/airflow/.local/lib/python3.9/site-packages/grpc/_interceptor.py", line 247, in call
response, ignored_call = self._with_call(request,
File "/usr/local/airflow/.local/lib/python3.9/site-packages/grpc/_interceptor.py", line 290, in _with_call
return call.result(), call
File "/usr/local/airflow/.local/lib/python3.9/site-packages/grpc/_interceptor.py", line 146, in result
raise self._exception
File "/usr/local/airflow/.local/lib/python3.9/site-packages/grpc/_interceptor.py", line 274, in continuation
response, call = self._thunk(new_method).with_call(
File "/usr/local/airflow/.local/lib/python3.9/site-packages/grpc/_interceptor.py", line 301, in with_call
return self._with_call(request,
File "/usr/local/airflow/.local/lib/python3.9/site-packages/grpc/_interceptor.py", line 290, in _with_call
return call.result(), call
File "/usr/local/airflow/.local/lib/python3.9/site-packages/grpc/_interceptor.py", line 146, in result
raise self._exception
File "/usr/local/airflow/.local/lib/python3.9/site-packages/grpc/_interceptor.py", line 274, in continuation
response, call = self._thunk(new_method).with_call(
File "/usr/local/airflow/.local/lib/python3.9/site-packages/grpc/_interceptor.py", line 301, in with_call
return self._with_call(request,
File "/usr/local/airflow/.local/lib/python3.9/site-packages/grpc/_interceptor.py", line 287, in _with_call
call = self._interceptor.intercept_unary_unary(continuation,
File "/usr/local/lib/python3.9/site-packages/google/ads/googleads/interceptors/exception_interceptor.py", line 99, in intercept_unary_unary
self._handle_grpc_failure(response)
File "/usr/local/lib/python3.9/site-packages/google/ads/googleads/interceptors/exception_interceptor.py", line 71, in _handle_grpc_failure
raise self._get_error_from_response(response)
File "/usr/local/airflow/.local/lib/python3.9/site-packages/grpc/_interceptor.py", line 274, in continuation
response, call = self._thunk(new_method).with_call(
File "/usr/local/airflow/.local/lib/python3.9/site-packages/grpc/_channel.py", line 1041, in with_call
state, call, = self._blocking(request, timeout, metadata, credentials,
File "/usr/local/airflow/.local/lib/python3.9/site-packages/grpc/_channel.py", line 1010, in _blocking
call = self._channel.segregated_call(
File "src/python/grpcio/grpc/_cython/_cygrpc/channel.pyx.pxi", line 496, in grpc._cython.cygrpc.Channel.segregated_call
File "src/python/grpcio/grpc/_cython/_cygrpc/channel.pyx.pxi", line 366, in grpc._cython.cygrpc._segregated_call
File "src/python/grpcio/grpc/_cython/_cygrpc/channel.pyx.pxi", line 360, in grpc._cython.cygrpc._segregated_call
File "src/python/grpcio/grpc/_cython/_cygrpc/channel.pyx.pxi", line 218, in grpc._cython.cygrpc._call
File "src/python/grpcio/grpc/_cython/_cygrpc/channel.pyx.pxi", line 246, in grpc._cython.cygrpc._call
File "src/python/grpcio/grpc/_cython/_cygrpc/channel.pyx.pxi", line 89, in grpc._cython.cygrpc._operate
File "src/python/grpcio/grpc/_cython/_cygrpc/tag.pyx.pxi", line 64, in grpc._cython.cygrpc._BatchOperationTag.prepare
File "src/python/grpcio/grpc/_cython/_cygrpc/operation.pyx.pxi", line 37, in grpc._cython.cygrpc.SendInitialMetadataOperation.c
File "src/python/grpcio/grpc/_cython/_cygrpc/metadata.pyx.pxi", line 43, in grpc._cython.cygrpc._store_c_metadata
File "src/python/grpcio/grpc/_cython/_cygrpc/grpc_string.pyx.pxi", line 40, in grpc._cython.cygrpc._encode
TypeError: Expected str, not <class 'int'>

thank you !

[potiuk]

You did not provide any information on the provider/ads version used. But given you are using v13 it must be your code, not Google Ads operator, so yo shoudl direct the question to Google ads team I thin. Thiere is nothing airflow-y in here.