Hi, i'm having troubles with monday connector: ``...
# replication-troubleshooting
e
Hi, i'm having troubles with monday connector:
Copy code
2022-10-12 09:22:30 [44msource[0m > Encountered an exception while reading stream items
Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/requests/models.py", line 971, in json
    return complexjson.loads(self.text, **kwargs)
  File "/usr/local/lib/python3.9/json/__init__.py", line 346, in loads
    return _default_decoder.decode(s)
  File "/usr/local/lib/python3.9/json/decoder.py", line 337, in decode
    obj, end = self.raw_decode(s, idx=_w(s, 0).end())
  File "/usr/local/lib/python3.9/json/decoder.py", line 355, in raw_decode
    raise JSONDecodeError("Expecting value", s, err.value) from None
json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 115, in read
    yield from self._read_stream(
  File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 165, in _read_stream
    for record in record_iterator:
  File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 254, in _read_full_refresh
    for record in records:
  File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py", line 417, 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 336, in _send_request
    return backoff_handler(user_backoff_handler)(request, request_kwargs)
  File "/usr/local/lib/python3.9/site-packages/backoff/_sync.py", line 105, in retry
    ret = target(*args, **kwargs)
  File "/usr/local/lib/python3.9/site-packages/backoff/_sync.py", line 105, in retry
    ret = target(*args, **kwargs)
  File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py", line 291, in _send
    if self.should_retry(response):
  File "/airbyte/integration_code/source_monday/source.py", line 55, in should_retry
    is_complex_query = response.json().get("errors")
  File "/usr/local/lib/python3.9/site-packages/requests/models.py", line 975, in json
    raise RequestsJSONDecodeError(e.msg, e.doc, e.pos)
requests.exceptions.JSONDecodeError: Expecting value: line 1 column 1 (char 0)
2022-10-12 09:22:30 [44msource[0m > Finished syncing items
✍️ 1
u
@[DEPRECATED] Marcos Marx turned this message into Zendesk ticket 2815 to ensure timely resolution!
s
Hey there, I'm seeing on the
items
stream you are hitting http error 429 "Call limit exceeded":
Copy code
2022-10-11 20:40:15 [44msource[0m > Syncing stream: items 
2022-10-11 20:40:23 [44msource[0m > Backing off _send(...) for 30.0s (airbyte_cdk.sources.streams.http.exceptions.DefaultBackoffException: Request URL: <https://api.monday.com/v2?query=query+%7B+items+%28limit%3A100%2Cpage%3A2%29+%7B+assets%7Bid%7D%2Cboard%7Bid%7D%2Ccolumn_values%7Bid%2Cvalue%2Cadditional_info%2Ctext%2Ctitle%2Ctype%7D%2Ccreated_at%2Ccreator_id%2Cgroup%7Bid%7D%2Cid%2Cname%2Cparent_item%7Bid%7D%2Cstate%2Csubscribers%7Bid%7D%2Cupdated_at%2Cupdates%7Bid%7D+%7D+%7D>, Response Code: 429, Response Text: {"error_code":"ResolverCallsExceeded","status_code":429,"error_message":"Call limit exceeded for Resolvers::Pulses","error_data":{"error_reason":"automations.history.failed_trigger_details.error_reason.api_rate_limit"}})
2022-10-11 20:40:23 [44msource[0m > Caught retryable error 'Request URL: <https://api.monday.com/v2?query=query+%7B+items+%28limit%3A100%2Cpage%3A2%29+%7B+assets%7Bid%7D%2Cboard%7Bid%7D%2Ccolumn_values%7Bid%2Cvalue%2Cadditional_info%2Ctext%2Ctitle%2Ctype%7D%2Ccreated_at%2Ccreator_id%2Cgroup%7Bid%7D%2Cid%2Cname%2Cparent_item%7Bid%7D%2Cstate%2Csubscribers%7Bid%7D%2Cupdated_at%2Cupdates%7Bid%7D+%7D+%7D>, Response Code: 429, Response Text: {"error_code":"ResolverCallsExceeded","status_code":429,"error_message":"Call limit exceeded for Resolvers::Pulses","error_data":{"error_reason":"automations.history.failed_trigger_details.error_reason.api_rate_limit"}}' after 1 tries. Waiting 30 seconds then retrying...
We have an open github issue about this stream, please comment and add your logs if possible so that the fix can be designed effectively. Thanks for posting here to let the community know.
e
yes, that warning starts at the beginning of the process, what I can see is the part of `
Copy code
raise RequestsJSONDecodeError(e.msg, e.doc, e.pos)
requests.exceptions.JSONDecodeError: Expecting value: line 1 column 1 (char 0)
that was the error
s
Hey, the github issue was updated -- it looks like this stream is no longer supported by Monday as of Oct 3 😞 The workaround for this error would be to disable the stream.