Eduardo Aviles
10/13/2022, 6:52 PM2022-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 itemsuser
10/13/2022, 7:07 PMSunny Hashmi (Airbyte)
10/13/2022, 8:39 PMitems stream you are hitting http error 429 "Call limit exceeded":
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.Eduardo Aviles
10/14/2022, 1:11 AMraise RequestsJSONDecodeError(e.msg, e.doc, e.pos)
requests.exceptions.JSONDecodeError: Expecting value: line 1 column 1 (char 0)
that was the errorSunny Hashmi (Airbyte)
10/14/2022, 8:36 PM