hubspot contacts capitalisation changed

  • 39Views
  • Last Post 01 November 2021
0
votes
Bart Jonk posted this 18 October 2021

There has been a change at Skyvia  where you seem to have changed that name of the 'Last Name' to 'Last name' (you sort of changed from Camel Case to Title case....). We now have a number of records in the database where either the one or the other field is filled: 

 

select count (*) from hubspotv."Contacts" where "First Name" is null and "First name" is not null; 

select count (*) from hubspotv."Contacts" where "First name" is null and "First Name" is not null; 

 

select count (*) from hubspotv."Contacts" where "Last Name" is null and "Last name" is not null; 

select count (*) from hubspotv."Contacts" where "Last name" is null and "Last Name" is not null; 

 

select count (*) from hubspotv."Contacts" where "Phone Number" is null and "Phone number" is not null; 

select count (*) from hubspotv."Contacts" where "Phone number" is null and "Phone Number" is not null; 

this is annoying, can you change this? 


Order By: Standard | Newest | Votes
0
votes
Olena Romanchuk posted this 21 October 2021

Hello Bart, 

Thank you for contacting our Skyvia support team. 
The request has been forwarded to our development team for the investigation.
I will let you know the result as soon as I get feedback from the team.  


Best regards,

Olena

 

Technical Support Engineer

0
votes
Olena Romanchuk posted this 01 November 2021

Hello Bart, 

Our developers have checked the package and HubSpot connector from their side. 
There were no changes in our Hubspot connector lately. 
As we can see, the changes to column names were applied on HubSpot account level. The changes may have been manual or caused by a localization applied to the Contacts object. 

In this case we recommend you to reset the LastSyncTime parameter, activate the Create Tables, Drop Tables options and run the package. In this case the full replication will be performed and the tables will be dropped and created  


Best regards,

Olena

Technical Support Engineer




Close