Export Objects from HubSpot

This task will export objects from HubSpot, and optionally export other associated objects too. The results will be output to an XML file.

Settings

Connection

Required
The HubSpot connection to use. See Connecting to HubSpot.

Export Settings

Required
These settings are used to determine whether new, modified or all records will be exported.

  • Date Created - Only records created after this date will be exported. The date will update automatically each time the task runs.
  • Date Modified - Only records modified after this date will be exported. The date will update automatically each time the task runs.
  • Export Modified, New or All Records - Used to choose which records should be included in the export. Please note that the 'Modified' setting will also export any new records.

Filter Groups

Optional
These settings allow you to specify filters to apply to the export, so that only certain records are returned. It consists of a list of filter groups. Each filter group contains a list of filters. The following settings can be found within an individual filter:

  • High Value - This setting is only used in conjunction with the Between operator, and must be left blank when using any other operator. This represents the maximum value.
  • Operator - Choose the type of comparison to perform on against the specified property and value. The available options are: Equals, Not Equals, Less Than, Less Than Or Equals, Greater Than, Greater Than Or Equals, Between, In, Not In, Has Value, Has No Value, Contains Token, Does Not Contain Token
  • Property Name - Enter the internal name of the property. Please note that you can't use the label that is seen in the front end of HubSpot.
  • Value - Specify the value you want to filter on. When using the Between operator, this represents the minimum value. This must be left blank when using the In, Not In, Has Value and Has No Value operators.
  • Values - This setting is only used in conjunction with the In and Not In operators, and must be left blank when using any other operator. This is where you enter the list of values to filter on.

The list of filters within each group will be combined using an AND operator. Each filter group will be combined using an OR operator.

Object Settings

Required
These settings are used to determine which objects and properties should be exported from HubSpot.

  • Associations (Optional) - Enter a list of associated object types you would like to export from HubSpot. The same 3 settings apply to associated objects as described here, so you can build up a hierarchical structure of objects to export from HubSpot.
  • Object Type (Required) - Select the object type you would like to export from HubSpot.
  • Properties (Required) - Select which properties you would like to export from HubSpot for this type of object. You can either choose the 'Export All Properties' option, or you can choose the 'Export Selected Properties' option and pick specific properties from the list of available properties.

Page Size

Required
The number of records to request at a time from HubSpot. The maximum is 100.

Zynk Settings

See Common Task Settings

Examples

A sample output file is shown below. This shows an export of specific properties from the contacts object, and specific properties from the associated company object.

<?xml version="1.0" encoding="utf-8"?>
<HubSpotObjects xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <HubSpotObject>
    <Id>151</Id>
    <Properties>
      <Property Name="address" Value="6-8 Charlotte Square" />
      <Property Name="city" Value="Newcastle" />
      <Property Name="country" Value="United Kingdom" />
      <Property Name="createdate" Value="2024-02-27T12:18:49.676Z" />
      <Property Name="email" Value="[email protected]" />
      <Property Name="fax" />
      <Property Name="firstname" Value="John" />
      <Property Name="hs_object_id" Value="151" />
      <Property Name="lastmodifieddate" Value="2024-04-10T14:44:16.614Z" />
      <Property Name="lastname" Value="Smith" />
      <Property Name="mobilephone" />
      <Property Name="phone" Value="+441913037279" />
      <Property Name="state" Value="Tyne &amp; Wear" />
      <Property Name="website" Value="http://www.zynk.com" />
      <Property Name="zip" Value="NE1 4XF" />
    </Properties>
    <Associations ObjectType="companies">
      <Association>
        <Id>10329680826</Id>
        <Type>contact_to_company</Type>
        <HubSpotObject>
          <Id>10329680826</Id>
          <Properties>
            <Property Name="createdate" Value="2024-02-28T16:12:17.026Z" />
            <Property Name="hs_lastmodifieddate" Value="2024-03-20T14:40:45.957Z" />
            <Property Name="hs_object_id" Value="10329680826" />
            <Property Name="name" Value="Zynk Software Limited" />
            <Property Name="ownername" />
            <Property Name="website" Value="zynk.com" />
          </Properties>
          <CreatedAt>2024-02-28T16:12:17.026Z</CreatedAt>
          <UpdatedAt>2024-03-20T14:40:45.957Z</UpdatedAt>
          <Archived>false</Archived>
          <ArchivedAt xsi:nil="true" />
        </HubSpotObject>
      </Association>
    </Associations>
    <CreatedAt>2024-02-27T12:18:49.676Z</CreatedAt>
    <UpdatedAt>2024-04-10T14:44:16.614Z</UpdatedAt>
    <Archived>false</Archived>
    <ArchivedAt xsi:nil="true" />
  </HubSpotObject>
</HubSpotObjects>