Source Zendesk Sell: Type Error for Calls stream

[speckm]

Connector Name

source-zendesk-sell

Connector Version

0.1.0

What step the error happened?

During the sync

Revelant information

The connector treats the field "phone_number" as "number". But phone numbers in Zendesk Sell are strings, including hyphens adn + like +49-123-1232323. On sync the connector fails as the data types in the database to not fit with the data type of the connector. We are transporting zendesk-sell to bigquery. Other data types work well.

See output log line "normalization > Bad double value: +49 170 555???

I shortened the number in the log to protect our customers.

I think the "fix" would be to update

https://github.com/airbytehq/airbyte/blob/master/airbyte-integrations/connectors/source-zendesk-sell/source_zendesk_sell/schemas/calls.json to

.
.
.
    },
    "phone_number": {
      "type": ["null", "string"]
    },
.
.
.

Relevant log output

2023-08-25 10:22:38 normalization > 8 of 16 OK created table model zendesk_source.tags...................................................................... [CREATE TABLE (6.0 rows, 1.3 KB processed) in 2.69s]
2023-08-25 10:22:38 normalization > 13 of 16 START table model zendesk_source.users......................................................................... [RUN]
2023-08-25 10:22:38 normalization > 1 of 16 OK created table model zendesk_source.orders.................................................................... [CREATE TABLE (2.2k rows, 359.5 KB processed) in 3.27s]
2023-08-25 10:22:38 normalization > 7 of 16 OK created table model zendesk_source.tasks..................................................................... [CREATE TABLE (21.0 rows, 8.2 KB processed) in 3.03s]
2023-08-25 10:22:38 normalization > 14 of 16 START table model zendesk_source.contacts...................................................................... [RUN]
2023-08-25 10:22:38 normalization > 15 of 16 START table model zendesk_source.visits........................................................................ [RUN]
2023-08-25 10:22:38 normalization > 5 of 16 OK created table model zendesk_source.deals..................................................................... [CREATE TABLE (2.2k rows, 1.9 MB processed) in 3.35s]
2023-08-25 10:22:38 normalization > 16 of 16 START incremental model zendesk_source.calls................................................................... [RUN]
2023-08-25 10:22:38 normalization > 9 of 16 OK created table model zendesk_source.products.................................................................. [CREATE TABLE (52.0 rows, 19.5 KB processed) in 2.67s]
2023-08-25 10:22:38 normalization > 11 of 16 OK created table model zendesk_source.notes.................................................................... [CREATE TABLE (789.0 rows, 300.3 KB processed) in 2.75s]
2023-08-25 10:22:38 normalization > 10 of 16 OK created table model zendesk_source.text_messages............................................................ [CREATE TABLE (2.0 rows, 901.0 Bytes processed) in 2.78s]
2023-08-25 10:22:38 normalization > 12 of 16 OK created table model zendesk_source.visit_outcomes........................................................... [CREATE TABLE (4.0 rows, 620.0 Bytes processed) in 2.81s]
2023-08-25 10:22:38 normalization > 15 of 16 OK created table model zendesk_source.visits................................................................... [CREATE TABLE (0.0 rows, 0 processed) in 2.63s]
2023-08-25 10:22:38 normalization > 13 of 16 OK created table model zendesk_source.users.................................................................... [CREATE TABLE (22.0 rows, 10.8 KB processed) in 2.88s]
2023-08-25 10:22:38 normalization > 14 of 16 OK created table model zendesk_source.contacts................................................................. [CREATE TABLE (1.7k rows, 1.4 MB processed) in 2.98s]
2023-08-25 10:22:38 normalization > 16 of 16 ERROR creating incremental model zendesk_source.calls.......................................................... [ERROR in 6.73s]
2023-08-25 10:22:38 normalization > Finished running 15 table models, 1 incremental model in 12.49s.
2023-08-25 10:22:38 normalization > Completed with 1 error and 0 warnings:
2023-08-25 10:22:38 normalization > Database Error in model calls (models/generated/airbyte_incremental/zendesk_source/calls.sql)
2023-08-25 10:22:38 normalization >   Bad double value: +49 170 555????
2023-08-25 10:22:38 normalization > Done. PASS=15 WARN=0 ERROR=1 SKIP=0 TOTAL=16

Contribute

• Yes, I want to contribute

[marcosmarxm]

Closed by #29830