Salesforce null date fields with json definition of {"anyOf":[{"type":"string","format":"date-time"}

Connector Questions & Issues
, ,
1

:wave: I’m receiving null dates for all date fields from salesforce. The data is populated in the raw files ,but during the normalization process, all dates get read as null.

  • Is this your first time deploying Airbyte?: No

  • OS Version / Instance: Ubuntu, Windows or MacOS… are some example remove it with yours

  • Memory / Disk: you can use something like 4Gb / 1 Tb

  • Deployment: Docker

  • Airbyte Version: What version are you using now?
    Airbyte Version: 0.40.0-alpha
    Source: Salesforce (0.2.5)
    Destination: BigQuery (1.1.14)

  • Step: Issue happens when trying to sync any field with the definition of {“anyOf”:[{“type”:“string”,“format”:“date-time”} in the salesforce connector json schema. All date fields appear as null in BigQuery. When reading the logs, there is a warning for each of the fields that is appearing as null.

2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column CloseDate at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column CreatedDate at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column LastViewedDate at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column SystemModstamp at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column LastActivityDate at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column LastModifiedDate at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column Checkback_Date__c at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column LastReferencedDate at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column Contract_End_Date__c at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column Contract_Start_Date__c at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column POC_Expiration_Date__c at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column Trade_Negotiation_Date__c at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column Potential_Interest_Date__c at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column Diagnosis_Discovery_Date__c at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column Discovery_Meeting_Set_On__c at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column Discovery_Meeting_Set_For__c at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column Proof_of_Concept_End_Date__c at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column Perscription_Proposal_Date__c at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column Techincal_Demo_Review_Date__c at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column Proof_of_Concept_Start_Date__c at Opportunity
2022-08-22 18:09:55 e[42mnormalizatione[0m > WARN: Unknown type for column Last_Activity_Completed_Date__c at Opportunity
2

Can you update the Salesforce connector to latest version? 1.0.15