HubSpot: Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
(Created page with "=Date fields= Using API v3, For a date only field, you need to explicitly set the date to midnight UTC <syntaxhighlight lang="vb"> Function ScriptedField ScriptedField=Form...")
 
No edit summary
Line 1: Line 1:
=Date fields=
=Date fields=
Using API v3, For a date only field, you need to explicitly set the date to midnight UTC
Using API v3, For a date only field, you need to explicitly set the date to midnight UTC
<syntaxhighlight lang="vb">
<syntaxhighlight lang="vb">
Line 7: Line 6:
End Function
End Function
</syntaxhighlight>
</syntaxhighlight>
=Updating Contacts=
When updating contacts, if you are matching on email address, you must be sure NOT to pass in a blank email address.  HubSpot will not know which contact to update and will update a random contact with incorrect data.

Revision as of 07:20, 31 July 2021

Date fields

Using API v3, For a date only field, you need to explicitly set the date to midnight UTC

Function ScriptedField
  ScriptedField=FormatDate("@@ORG:date_entered@@", "yyyy-MM-ddT00:00:00Z")
End Function

Updating Contacts

When updating contacts, if you are matching on email address, you must be sure NOT to pass in a blank email address. HubSpot will not know which contact to update and will update a random contact with incorrect data.