Hi, I am having an issue with setting up a custom report for Google Search Console. I followed the instruction in this documentation page from Airbyte. The parameters I used for the custom report are:

{'name': 'page_query', 'dimensions': ['page', 'query']}

but I get an errors when I try to setup a connection. Please note that it works fine without the custom report. Do you have any ideas? Appreciate your help!

im having issues with search console as well. Just wondering if you are using oauth?

@wp I am using service account

@[DEPRECATED] Marcos Marx turned this thread into Zendesk ticket 3016 to ensure timely resolution!

Hi Hiep! Are you seeing any other errors/logs when the connection fails?

hi Nataly, I cant see any errors/logs on the UI. The only thing I can see is the errors I showed in the screenshot

What about the server logs from the Airbyte instance? Are you deploying it locally? I need more information to help you resolve this in addition to the screenshot, unfortunately!

i have same problem

Hi Francisco, I was out yesterday, so thank you for your patience. Could you please give me the full logs? The ones you have posted don't have all the info I need.

Hi @Nataly Merezhuk (Airbyte) I managed to get the log from our dev-ops engineer. Please see the below

2022-11-10 10:45:49 INFO i.a.s.p.j.LoggingJobErrorReportingClient(reportJobFailureReason):23 - Report Job Error -> workspaceId: 7c2d9d60-98f2-4701-b0ef-37653707d809, dockerImage: airbyte/source-google-search-console:0.1.16, failureReason: io.airbyte.config.FailureReason@3f9c0228[failureOrigin=<null>,failureType=system_error,internalMessage={'name': 'page_query', 'dimensions': ['page', 'query']} is not of type 'array'

Failed validating 'type' in schema:
    {'items': {'properties': {'dimensions': {'items': {'minLength': 1,
                                                       'type': 'string'},
                                             'type': 'array'},
                              'name': {'minLength': 1, 'type': 'string'}},
               'required': ['name', 'dimensions'],
               'type': 'object'},
     'type': 'array'}

On instance:
    {'dimensions': ['page', 'query'], 'name': 'page_query'},externalMessage=Something went wrong in the connector. See the logs for more details.,metadata=io.airbyte.config.Metadata@a69725a[additionalProperties={attemptNumber=null, jobId=null, from_trace_message=true}],stacktrace=Traceback (most recent call last):
  File "/airbyte/integration_code/main.py", line 13, in <module>
    launch(source, sys.argv[1:])
  File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/entrypoint.py", line 123, in launch
    for message in source_entrypoint.run(parsed_args):
  File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/entrypoint.py", line 108, in run
    catalog = self.source.discover(self.logger, config)
  File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 72, in discover

Hello! So it looks like a type error - the connector is expecting a JSON array in the custom reports input:

internalMessage={'name': 'page_query', 'dimensions': ['page', 'query']} is not of type 'array'

Could you try

[{"name": "page_query", "dimensions": ["page", "query"]}]

I think this is a matter of tweaking what you put in that input.

it works, thanks a ton @Nataly Merezhuk (Airbyte)

No problem!