Azure / Azure/Azure-DataFactory

HubSpot connector, wrong source field type on depricated field

Open
#266 2 comments 1 reaction 0 assignees View on GitHub
Dominant language
PowerShell
Stars
529
Forks
623
PR merge metrics
No merged PRs in 30d

Description

Hi Guys

In the hubspot connector, could we correct the data type for column "Options_Double_Data" from "boolean" to "string" against the two datasets
"Hubspot"."Company_Properties_Options"
"Hubspot"."Deal_Properties_Options"

both produce the same error using Copy Data into a new table, see below.

Note that the source table "Hubspot"."Contact_Properties_Options" has an identical structure and imports without issue due to the "Options_Double_Data" column being correctly specified as a string, the offending field is actually depricated by hubspot, so would make more sense to exclude it entirely.

also of note is that even if i delete the mapping for the specific column in the copy data task this error still occurs due to the incorrect source data set specification.

Easy one to fix i suspect
-------------------------------------------------------------------------------
Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][Hubspot] (120) Error converting 0.0 to type boolean.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][Hubspot] (120) Error converting 0.0 to type boolean.,Source=HubspotODBC_sb64.dll,'

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.