Source Pipedrive - Do not recognize the right data type of a stream field

[quangdvn-sun]

Connector Name

Pipedrive

Connector Version

0.1.17

What step the error happened?

During the sync

Revelant information

When syncing product_fields, Pipedrive connector auto detect some fields data type as number even though the data contains "true" and "false" value, which causes the sync flow failed

product_fields consists of numbers of boolean fields

Relevant log output

100038 (22018): Numeric value 'false' is not recognized
  compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_tables/XXXXX/PRODUCT_FIELDS_OPTIONS.sql,retryable=<null>,timestamp=1687152540064], io.airbyte.config.FailureReason@443adae1[failureOrigin=normalization,failureType=system_error,internalMessage=100038 (22018): Numeric value 'false' is not recognized,externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@1dc57d82[additionalProperties={attemptNumber=2, jobId=7518, from_trace_message=true}],stacktrace=AirbyteDbtError:

Contribute

• [ ] Yes, I want to contribute

[quangdvn-sun]

This is likely the root cause,

"options": {
      "type": ["null", "array"],
      "items": {
        "type": "object",
        "properties": {
          "id": {
            "type": ["null", "boolean", "integer"]
          },
          "label": {
            "type": ["null", "string"]
          }
        }
      }
    }

options.id allows boolean value but somehow Airbyte only check if it's an integer value