When data has been entered into HubSpot in an incorrect format, you might receive the error shown below when working with the HubSpot Connector:
 
Date Format error – “Unable to format the data” from HubSpot Source Connector
Unable to format the data '{
  "value": "10:31 PM UTC"
}' for Contact.hs_analytics_first_timestamp.
 
In this error message the value was not in a valid date format. This error can display in either a Query Block on the Preview tab or in the Execution History Detail for a Solution.

Some HubSpot fields are read only and are intended to be set or populated by HubSpot. Due to a HubSpot issue, sometimes users have entered invalid data in one of these fields. When the field is read by the TIBCO Scribe® Online HubSpot Connector, HubSpot detects the incorrect field properties and the error is generated. For more information, search for the error or its components in the HubSpot support webpage.

For additional information, see the following in the TIBCO Scribe® Online Help:  TIBCO Scribe® Online Connector For HubSpot

When data has been entered into HubSpot in an incorrect format, you might receive a data format error.