Source Zoho: throwing `start_datetime` invalid format error

kabilan-dt commented 2 years ago

Environment

Airbyte version: 0.39.14-alpha
OS Version / Instance: GCP n1-standard-4
Deployment: Docker
Source Connector and version: ZohoCRM 0.1.0
Destination Connector and version: Bigquery 1.1.11
Step where error happened: Setup new connection

Current Behavior

After entering all the client id, client secret, refresh token, start date and other information, I can see the check_connection api pass and the create api fails with the error "Errors: $.start_datetime: 2022-01-01 is an invalid date-time"

Expected Behavior

The connector should be created.

Logs

{"message":"The provided configuration does not fulfill the specification. Errors: json schema validation failed when comparing the data to the json schema. \nErrors: $.start_datetime: 2022-01-01 13:00:00 is an invalid date-time \nSchema: \n{\n \"type\" : \"object\",\n \"title\" : \"Zoho Crm Configuration\",\n \"$schema\" : \"http://json-schema.org/draft-07/schema#\",\n \"required\" : [ \"client_id\", \"client_secret\", \"refresh_token\", \"environment\", \"dc_region\", \"edition\" ],\n \"properties\" : {\n \"edition\" : {\n \"enum\" : [ \"Free\", \"Standard\", \"Professional\", \"Enterprise\", \"Ultimate\" ],\n \"type\" : \"string\",\n \"title\" : \"Zoho CRM Edition\",\n \"default\" : \"Free\",\n \"description\" : \"Choose your Edition of Zoho CRM to determine API Concurrency Limits\"\n },\n \"client_id\" : {\n \"type\" : \"string\",\n \"title\" : \"Client ID\",\n \"description\" : \"OAuth2.0 Client ID\",\n \"airbyte_secret\" : true\n },\n \"dc_region\" : {\n \"enum\" : [ \"US\", \"AU\", \"EU\", \"IN\", \"CN\", \"JP\" ],\n \"type\" : \"string\",\n \"title\" : \"Data Center Location\",\n \"description\" : \"Please choose the region of your Data Center location. More info by this <a href=\\"https://www.zoho.com/crm/developer/docs/api/v2/multi-dc.html\\\">Link\"\n },\n \"environment\" : {\n \"enum\" : [ \"Production\", \"Developer\", \"Sandbox\" ],\n \"type\" : \"string\",\n \"title\" : \"Environment\",\n \"description\" : \"Please choose the environment\"\n },\n \"client_secret\" : {\n \"type\" : \"string\",\n \"title\" : \"Client Secret\",\n \"description\" : \"OAuth2.0 Client Secret\",\n \"airbyte_secret\" : true\n },\n \"refresh_token\" : {\n \"type\" : \"string\",\n \"title\" : \"Refresh Token\",\n \"description\" : \"OAuth2.0 Refresh Token\",\n \"airbyte_secret\" : true\n },\n \"start_datetime\" : {\n \"type\" : [ \"null\", \"string\" ],\n \"title\" : \"Start Date\",\n \"format\" : \"date-time\",\n \"examples\" : [ \"2000-01-01\", \"2000-01-01 13:00\", \"2000-01-01 13:00:00\", \"2000-01-01T13:00+00:00\", \"2000-01-01T13:00:00-07:00\" ],\n \"description\" : \"ISO 8601, for instance: YYYY-MM-DD, YYYY-MM-DD HH:MM:SS+HH:MM\"\n }\n },\n \"additionalProperties\" : false\n}","exceptionClassName":"io.airbyte.server.errors.BadObjectSchemaKnownException","exceptionStack":["io.airbyte.server.errors.BadObjectSchemaKnownException: The provided configuration does not fulfill the specification. Errors: json schema validation failed when comparing the data to the json schema. ","Errors: $.start_datetime: 2022-01-01 13:00:00 is an invalid date-time ","Schema: ","{"," \"type\" : \"object\","," \"title\" : \"Zoho Crm Configuration\","," \"$schema\" : \"http://json-schema.org/draft-07/schema#\","," \"required\" : [ \"client_id\", \"client_secret\", \"refresh_token\", \"environment\", \"dc_region\", \"edition\" ],"," \"properties\" : {"," \"edition\" : {"," \"enum\" : [ \"Free\", \"Standard\", \"Professional\", \"Enterprise\", \"Ultimate\" ],"," \"type\" : \"string\","," \"title\" : \"Zoho CRM Edition\","," \"default\" : \"Free\","," \"description\" : \"Choose your Edition of Zoho CRM to determine API Concurrency Limits\""," },"," \"client_id\" : {"," \"type\" : \"string\","," \"title\" : \"Client ID\","," \"description\" : \"OAuth2.0 Client ID\","," \"airbyte_secret\" : true"," },"," \"dc_region\" : {"," \"enum\" : [ \"US\", \"AU\", \"EU\", \"IN\", \"CN\", \"JP\" ],"," \"type\" : \"string\","," \"title\" : \"Data Center Location\","," \"description\" : \"Please choose the region of your Data Center location. More info by this <a href=\\"https://www.zoho.com/crm/developer/docs/api/v2/multi-dc.html\\\">Link\""," },"," \"environment\" : {"," \"enum\" : [ \"Production\", \"Developer\", \"Sandbox\" ],"," \"type\" : \"string\","," \"title\" : \"Environment\","," \"description\" : \"Please choose the environment\""," },"," \"client_secret\" : {"," \"type\" : \"string\","," \"title\" : \"Client Secret\","," \"description\" : \"OAuth2.0 Client Secret\","," \"airbyte_secret\" : true"," },"," \"refresh_token\" : {"," \"type\" : \"string\","," \"title\" : \"Refresh Token\","," \"description\" : \"OAuth2.0 Refresh Token\","," \"airbyte_secret\" : true"," },"," \"start_datetime\" : {"," \"type\" : [ \"null\", \"string\" ],"," \"title\" : \"Start Date\","," \"format\" : \"date-time\","," \"examples\" : [ \"2000-01-01\", \"2000-01-01 13:00\", \"2000-01-01 13:00:00\", \"2000-01-01T13:00+00:00\", \"2000-01-01T13:00:00-07:00\" ],"," \"description\" : \"ISO 8601, for instance: YYYY-MM-DD, YYYY-MM-DD HH:MM:SS+HH:MM\""," }"," },"," \"additionalProperties\" : false","}","\tat io.airbyte.server.apis.ConfigurationApi.execute(ConfigurationApi.java:860)","\tat io.airbyte.server.apis.ConfigurationApi.createSource(ConfigurationApi.java:433)","\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)","\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)","\tat java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)","\tat java.base/java.lang.reflect.Method.invoke(Method.java:568)","\tat org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)","\tat org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124)","\tat org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167)","\tat org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:219)","\tat org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79)","\tat org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:469)","\tat org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:391)","\tat org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:80)","\tat org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:253)","\tat org.glassfish.jersey.internal.Errors$1.call(Errors.java:248)","\tat org.glassfish.jersey.internal.Errors$1.call(Errors.java:244)","\tat org.glassfish.jersey.internal.Errors.process(Errors.java:292)","\tat org.glassfish.jersey.internal.Errors.process(Errors.java:274)","\tat org.glassfish.jersey.internal.Errors.process(Errors.java:244)","\tat org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)","\tat org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:232)","\tat org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680)","\tat org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394)","\tat org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346)","\tat org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366)","\tat org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319)","\tat org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205)","\tat org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763)","\tat org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:569)","\tat org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)","\tat org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1377)","\tat org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)","\tat org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:507)","\tat org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)","\tat org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1292)","\tat org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)","\tat org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)","\tat org.eclipse.jetty.server.Server.handle(Server.java:501)","\tat org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)","\tat org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556)","\tat org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)","\tat org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273)","\tat org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)","\tat org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)","\tat org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)","\tat org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)","\tat org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)","\tat org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)","\tat org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)","\tat org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375)","\tat org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806)","\tat org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938)","\tat java.base/java.lang.Thread.run(Thread.java:833)","Caused by: io.airbyte.validation.json.JsonValidationException: json schema validation failed when comparing the data to the json schema. ","Errors: $.start_datetime: 2022-01-01 13:00:00 is an invalid date-time ","Schema: ","{"," \"type\" : \"object\","," \"title\" : \"Zoho Crm Configuration\","," \"$schema\" : \"http://json-schema.org/draft-07/schema#\","," \"required\" : [ \"client_id\", \"client_secret\", \"refresh_token\", \"environment\", \"dc_region\", \"edition\" ],"," \"properties\" : {"," \"edition\" : {"," \"enum\" : [ \"Free\", \"Standard\", \"Professional\", \"Enterprise\", \"Ultimate\" ],"," \"type\" : \"string\","," \"title\" : \"Zoho CRM Edition\","," \"default\" : \"Free\","," \"description\" : \"Choose your Edition of Zoho CRM to determine API Concurrency Limits\""," },"," \"client_id\" : {"," \"type\" : \"string\","," \"title\" : \"Client ID\","," \"description\" : \"OAuth2.0 Client ID\","," \"airbyte_secret\" : true"," },"," \"dc_region\" : {"," \"enum\" : [ \"US\", \"AU\", \"EU\", \"IN\", \"CN\", \"JP\" ],"," \"type\" : \"string\","," \"title\" : \"Data Center Location\","," \"description\" : \"Please choose the region of your Data Center location. More info by this <a href=\\"https://www.zoho.com/crm/developer/docs/api/v2/multi-dc.html\\\">Link\""," },"," \"environment\" : {"," \"enum\" : [ \"Production\", \"Developer\", \"Sandbox\" ],"," \"type\" : \"string\","," \"title\" : \"Environment\","," \"description\" : \"Please choose the environment\""," },"," \"client_secret\" : {"," \"type\" : \"string\","," \"title\" : \"Client Secret\","," \"description\" : \"OAuth2.0 Client Secret\","," \"airbyte_secret\" : true"," },"," \"refresh_token\" : {"," \"type\" : \"string\","," \"title\" : \"Refresh Token\","," \"description\" : \"OAuth2.0 Refresh Token\","," \"airbyte_secret\" : true"," },"," \"start_datetime\" : {"," \"type\" : [ \"null\", \"string\" ],"," \"title\" : \"Start Date\","," \"format\" : \"date-time\","," \"examples\" : [ \"2000-01-01\", \"2000-01-01 13:00\", \"2000-01-01 13:00:00\", \"2000-01-01T13:00+00:00\", \"2000-01-01T13:00:00-07:00\" ],"," \"description\" : \"ISO 8601, for instance: YYYY-MM-DD, YYYY-MM-DD HH:MM:SS+HH:MM\""," }"," },"," \"additionalProperties\" : false","}","\tat io.airbyte.validation.json.JsonSchemaValidator.ensure(JsonSchemaValidator.java:83)","\tat io.airbyte.server.handlers.SourceHandler.validateSource(SourceHandler.java:272)","\tat io.airbyte.server.handlers.SourceHandler.createSource(SourceHandler.java:88)","\tat io.airbyte.server.apis.ConfigurationApi.lambda$createSource$27(ConfigurationApi.java:433)","\tat io.airbyte.server.apis.ConfigurationApi.execute(ConfigurationApi.java:854)","\t... 53 more"],"rootCauseExceptionClassName":"java.lang.Class","rootCauseExceptionStack":["io.airbyte.validation.json.JsonValidationException: json schema validation failed when comparing the data to the json schema. ","Errors: $.start_datetime: 2022-01-01 13:00:00 is an invalid date-time ","Schema: ","{"," \"type\" : \"object\","," \"title\" : \"Zoho Crm Configuration\","," \"$schema\" : \"http://json-schema.org/draft-07/schema#\","," \"required\" : [ \"client_id\", \"client_secret\", \"refresh_token\", \"environment\", \"dc_region\", \"edition\" ],"," \"properties\" : {"," \"edition\" : {"," \"enum\" : [ \"Free\", \"Standard\", \"Professional\", \"Enterprise\", \"Ultimate\" ],"," \"type\" : \"string\","," \"title\" : \"Zoho CRM Edition\","," \"default\" : \"Free\","," \"description\" : \"Choose your Edition of Zoho CRM to determine API Concurrency Limits\""," },"," \"client_id\" : {"," \"type\" : \"string\","," \"title\" : \"Client ID\","," \"description\" : \"OAuth2.0 Client ID\","," \"airbyte_secret\" : true"," },"," \"dc_region\" : {"," \"enum\" : [ \"US\", \"AU\", \"EU\", \"IN\", \"CN\", \"JP\" ],"," \"type\" : \"string\","," \"title\" : \"Data Center Location\","," \"description\" : \"Please choose the region of your Data Center location. More info by this <a href=\\"https://www.zoho.com/crm/developer/docs/api/v2/multi-dc.html\\\">Link\""," },"," \"environment\" : {"," \"enum\" : [ \"Production\", \"Developer\", \"Sandbox\" ],"," \"type\" : \"string\","," \"title\" : \"Environment\","," \"description\" : \"Please choose the environment\""," },"," \"client_secret\" : {"," \"type\" : \"string\","," \"title\" : \"Client Secret\","," \"description\" : \"OAuth2.0 Client Secret\","," \"airbyte_secret\" : true"," },"," \"refresh_token\" : {"," \"type\" : \"string\","," \"title\" : \"Refresh Token\","," \"description\" : \"OAuth2.0 Refresh Token\","," \"airbyte_secret\" : true"," },"," \"start_datetime\" : {"," \"type\" : [ \"null\", \"string\" ],"," \"title\" : \"Start Date\","," \"format\" : \"date-time\","," \"examples\" : [ \"2000-01-01\", \"2000-01-01 13:00\", \"2000-01-01 13:00:00\", \"2000-01-01T13:00+00:00\", \"2000-01-01T13:00:00-07:00\" ],"," \"description\" : \"ISO 8601, for instance: YYYY-MM-DD, YYYY-MM-DD HH:MM:SS+HH:MM\""," }"," },"," \"additionalProperties\" : false","}","\tat io.airbyte.validation.json.JsonSchemaValidator.ensure(JsonSchemaValidator.java:83)","\tat io.airbyte.server.handlers.SourceHandler.validateSource(SourceHandler.java:272)","\tat io.airbyte.server.handlers.SourceHandler.createSource(SourceHandler.java:88)","\tat io.airbyte.server.apis.ConfigurationApi.lambda$createSource$27(ConfigurationApi.java:433)","\tat io.airbyte.server.apis.ConfigurationApi.execute(ConfigurationApi.java:854)","\tat io.airbyte.server.apis.ConfigurationApi.createSource(ConfigurationApi.java:433)","\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)","\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)","\tat java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)","\tat java.base/java.lang.reflect.Method.invoke(Method.java:568)","\tat org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)","\tat org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124)","\tat org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167)","\tat org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:219)","\tat org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79)","\tat org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:469)","\tat org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:391)","\tat org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:80)","\tat org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:253)","\tat org.glassfish.jersey.internal.Errors$1.call(Errors.java:248)","\tat org.glassfish.jersey.internal.Errors$1.call(Errors.java:244)","\tat org.glassfish.jersey.internal.Errors.process(Errors.java:292)","\tat org.glassfish.jersey.internal.Errors.process(Errors.java:274)","\tat org.glassfish.jersey.internal.Errors.process(Errors.java:244)","\tat org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)","\tat org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:232)","\tat org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680)","\tat org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394)","\tat org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346)","\tat org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366)","\tat org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319)","\tat org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205)","\tat org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763)","\tat org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:569)","\tat org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)","\tat org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1377)","\tat org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)","\tat org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:507)","\tat org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)","\tat org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1292)","\tat org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)","\tat org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)","\tat org.eclipse.jetty.server.Server.handle(Server.java:501)","\tat org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)","\tat org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556)","\tat org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)","\tat org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273)","\tat org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)","\tat org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)","\tat org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)","\tat org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)","\tat org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)","\tat org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)","\tat org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)","\tat org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375)","\tat org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806)","\tat org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938)","\tat java.base/java.lang.Thread.run(Thread.java:833)"]}

Steps to Reproduce

Enter all the necessary details
Create the connector
Find the api calls in the network tab

marcosmarxm commented 2 years ago

Thanks for reporting this @kabilan-dt I added the issue in connector backlog. The Zoho CRM is an alpha connector and can take a time until get this solved. You can also submit a PR yourself to fix it.

bibimorlet commented 1 year ago

I have the same issue:

It doesn't pass the json schema validator with a start_datetime 2023-06-04T00:00:00 (In fact, according to this page https://json-schema.org/understanding-json-schema/reference/string.html#dates-and-times, "date-time" format in a json schema accepts fields in the following formats: '2023-06-04T00:00:00Z' or '2023-06-04T00:00:00±00:00')
It does pass the json schema validator with a start_datetime 2023-06-04T00:00:00Z but I get this error during the stream sync (like in this issue #17098):
```
File "/airbyte/integration_code/source_zoho_crm/streams.py", line 110, in request_headers
last_modified_dt = datetime.datetime.fromisoformat(last_modified)
ValueError: Invalid isoformat string: '2023-06-04T00:00:00Z'
```
(Maybe because, according to this page https://docs.python.org/3/library/datetime.html#datetime.datetime.fromisoformat, Airbyte is not running with python 3.11 ?)

octavia-squidington-iii commented 7 months ago

At Airbyte, we seek to be clear about the project priorities and roadmap. This issue has not had any activity for 180 days, suggesting that it's not as critical as others. It's possible it has already been fixed. It is being marked as stale and will be closed in 20 days if there is no activity. To keep it open, please comment to let us know why it is important to you and if it is still reproducible on recent versions of Airbyte.

octavia-squidington-iii commented 6 months ago

This issue was closed because it has been inactive for 20 days since being marked as stale.

valentiniqidi commented 6 months ago

Same problem

airbytehq / airbyte