Error with ZohoCRM source on 'Modified_Time'

Summary

The user is experiencing an error with the ZohoCRM source related to ‘Modified_Time’. The error is causing the source process to exit with a non-zero code. The issue seems to be with finding the ‘Modified_Time’ field in the records. The user is seeking help on how to identify which streams are causing this error.


Question

2024-05-02 08:56:09 source > SourceZohoCrm runtimes:
Syncing stream incremental_accounts_zoho_crm_stream 0:00:41.090534
Syncing stream incremental_activities_zoho_crm_stream 0:13:10.976471
Syncing stream incremental_calls_zoho_crm_stream 0:06:50.599790
Syncing stream incremental_campaigns_zoho_crm_stream 0:00:00.441336
Syncing stream incremental_contacts_zoho_crm_stream 0:00:47.534422
Syncing stream incremental_events_zoho_crm_stream 0:01:22.886895
Syncing stream incremental_leads_zoho_crm_stream 0:00:19.489974
Syncing stream incremental_price__books_zoho_crm_stream 0:00:00.203201
Syncing stream incremental_products_zoho_crm_stream 0:00:08.906158
Syncing stream incremental_purchase__orders_zoho_crm_stream 0:00:00.247728
Syncing stream incremental_quotes_zoho_crm_stream 0:00:00.307906
Syncing stream incremental_sales__orders_zoho_crm_stream 0:00:00.694354
Syncing stream incremental_solutions_zoho_crm_stream 0:00:00.221120
Syncing stream incremental_tasks_zoho_crm_stream 0:00:41.945528
2024-05-02 08:56:10 source > 'Modified_Time'
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 131, in launch
    for message in source_entrypoint.run(parsed_args):
  File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/entrypoint.py", line 122, in run
    for message in generator:
  File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 114, in read
    stream_is_available, error = stream_instance.check_availability(logger, self)
  File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/core.py", line 190, in check_availability
    return self.availability_strategy.check_availability(self, logger, source)
  File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/availability_strategy.py", line 45, in check_availability
    get_first_record_for_slice(stream, stream_slice)
  File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/utils/stream_helper.py", line 38, in get_first_record_for_slice
    return next(records_for_slice)
  File "/airbyte/integration_code/source_zoho_crm/streams.py", line 90, in read_records
    latest_cursor_value = datetime.datetime.fromisoformat(record[self.cursor_field])
KeyError: 'Modified_Time'
2024-05-02 08:56:10 platform > readFromSource: source exception
io.airbyte.workers.internal.exception.SourceException: Source process exited with non-zero exit code 1
        at io.airbyte.workers.general.BufferedReplicationWorker.readFromSource(BufferedReplicationWorker.java:378) ~[io.airbyte-airbyte-commons-worker-0.58.0.jar:?]
        at io.airbyte.workers.general.BufferedReplicationWorker.lambda$runAsyncWithHeartbeatCheck$3(BufferedReplicationWorker.java:242) ~[io.airbyte-airbyte-commons-worker-0.58.0.jar:?]
        at java.base/java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1804) ~[?:?]```
Anyway i always got this error for ZohoCRM source.. but i can find which streams are error on 'Modified_Time', do you have any idea how to find out?

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1714640847283709) if you want to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
["error", "zohocrm-source", "modified-time", "streams", "source-exception"]
</sub>