ERP Bridge
Search
⌃K

Data Preparation

Properties of the following types: checkbox, multiple checkboxes, dropdown select, radio select and HubSpot user, the data should match one of the internal values of the property, otherwise, the flow
When you are in the phase of preparation of data to be inserted in HubSpot, please consider the data-format that is accepted by HubSpot itself (official documentation). Dates are accepted in two different formats for date and time values.
  1. 1.
    The first format is ISO 8601 formatted strings. Depending on the type of data, these will be one of two different formats:
    • For values that represent a specific date, the complete date format will be used: YYYY-MM-DD (e.g. 2020-02-29)
    • For values that represent a specific data and time, the complete data plus hours, minutes, seconds, and a decimal fraction of a second format will be used: YYYY-MM-DDThh:mm:ss.sTZD (e.g. 2020-02-29T03:30:17.000Z). Note that all times will be represented in UTC, so the values will always use the UTC designator 'Z.'
  2. 2.
    The second format is UNIX-formatted timestamps in milliseconds. Timestamp values will be treated as if they are set in UTC time. For example, the timestamp value 1427997766000 translates to April 2nd, 2015, 2:02:46 PM EDT (Eastern Daylight Saving Time) or 02 Apr 2015 18:02:46 UTC. Time values will be represented with the ISO 8601 value in responses, but the APIs will accept either format.
Last modified 2mo ago