Failed to pull data from Shopify

Airbyte version: 0.39.23-alpha
OS Version / Instance: GCP Ubuntu 22.04 LTS
Deployment: Docker
Source Connector and version: Shopify 0.1.37
Destination Connector and version: Mysql 0.5.13

I am getting error on time sync. On case raw data and normalization too…

Here is normalization error:

2022-06-16 07:18:36 normalization > 07:18:31.133803 [error] [MainThread]:   ) as user_id,
2022-06-16 07:18:36 normalization > 07:18:31.134448 [error] [MainThread]:       cast(curr...' at line 84
2022-06-16 07:18:36 normalization > 07:18:31.135066 [error] [MainThread]:   compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/airbyte_shopify/transactions.sql
2022-06-16 07:18:36 normalization > 07:18:31.135707 [info ] [MainThread]: 
2022-06-16 07:18:36 normalization > 07:18:31.136343 [error] [MainThread]: Database Error in model order_refunds_refund_line_items (models/generated/airbyte_incremental/airbyte_shopify/order_refunds_refund_line_items.sql)
2022-06-16 07:18:36 normalization > 07:18:31.137057 [error] [MainThread]:   1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json) as line_item,
2022-06-16 07:18:36 normalization > 07:18:31.137647 [error] [MainThread]:       cast(total_tax as 
2022-06-16 07:18:36 normalization > 07:18:31.138289 [error] [MainThread]:       float
2022-06-16 07:18:36 normalization > 07:18:31.138908 [error] [MainThread]:   ) as total_tax,
2022-06-16 07:18:36 normalization > 07:18:31.139495 [error] [MainThread]:       cast...' at line 111
2022-06-16 07:18:36 normalization > 07:18:31.140133 [error] [MainThread]:   compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/airbyte_shopify/order_refunds_refund_line_items.sql
2022-06-16 07:18:36 normalization > 07:18:31.140773 [info ] [MainThread]: 
2022-06-16 07:18:36 normalization > 07:18:31.141397 [error] [MainThread]: Database Error in model order_refunds_transactions (models/generated/airbyte_incremental/airbyte_shopify/order_refunds_transactions.sql)
2022-06-16 07:18:36 normalization > 07:18:31.142119 [error] [MainThread]:   1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json) as receipt,
2022-06-16 07:18:36 normalization > 07:18:31.142736 [error] [MainThread]:       cast(user_id as 
2022-06-16 07:18:36 normalization > 07:18:31.143399 [error] [MainThread]:       signed
2022-06-16 07:18:36 normalization > 07:18:31.144009 [error] [MainThread]:   ) as user_id,
2022-06-16 07:18:36 normalization > 07:18:31.144604 [error] [MainThread]:       cast(curr...' at line 127
2022-06-16 07:18:36 normalization > 07:18:31.145228 [error] [MainThread]:   compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/airbyte_shopify/order_refunds_transactions.sql

Raw data full log:
logs-74.txt (423.7 KB)

The error was:

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 127, in launch for message in source_entrypoint.run(parsed_args): File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/entrypoint.py", line 118, in run for message in generator: File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 123, in read raise e File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 114, in read yield from self._read_stream( File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 159, in _read_stream for record in record_iterator: File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 248, in _read_full_refresh for record in records: File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py", line 373, in read_records response = self._send_request(request, request_kwargs) File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py", line 337, in _send_request return backoff_handler(user_backoff_handler)(request, request_kwargs) File "/usr/local/lib/python3.9/site-packages/backoff/_sync.py", line 110, in retry ret = target(*args, **kwargs) File "/usr/local/lib/python3.9/site-packages/backoff/_sync.py", line 110, in retry ret = target(*args,**kwargs) File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py", line 299, in _send response.raise_for_status() File "/usr/local/lib/python3.9/site-packages/requests/models.py", line 960, in raise_for_status raise HTTPError(http_error_msg, response=self)requests.exceptions.HTTPError: 404 Client Error: Not Found for url: https://<yourshopify>.myshopify.com/admin/api/2021-07/shopify_payments/balance/transactions.json?limit=250&order=id+asc&since_id=0

I created issue https://github.com/airbytehq/airbyte/issues/14065 to investigate and solve the problem.
Are you able to manual try to hit this endpoint and see the headers/response from Shopify? This will give us some clues about how to solve it.

You can see that here is missing meaning.

https:// yourshopify .myshopify.com/admin/api/2021-07/shopify_payments/balance/transactions.json?limit=250&order=id+asc&since_id=0

When I am trying reach manually, using my Shopify name, it is asking for user and pass.
I am not sure witch user/pass I need to use. As my regular Shopify one doesn’t work…

possible reason is log URL as yourshopify is not replaced with meaning…

You must build the cURL call correctly with your api token, only requesting the endpoint will fail.