Azure / Azure/Azure-DataFactory
HubSpot connector, wrong source field type on depricated field
- 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
Assessment
This issue has not been assessed yet.