Filter HubSpot data to configure a delta export

A delta export retrieves only those matching records that were changed or created since the previous flow ran or a specified date. Certain HubSpot API requests do offer the Delta export type as a built-in option. However, integrator.io is not always able to set the HubSpot query parameters to check the “last exported” (lastExportDateTime) value that it typically relies on to export only unsynced records. 

As a safeguard, you can achieve full delta functionality in v3 of the HubSpot API with the following steps: 

Companies API

1. Create a HubSpot export with the following settings:
   • API version: v3
   • API name: CRM API: Companies
   • API endpoint: Search for Companies
2. In the Configure body parameters section, click Launch. The Search parameters window opens.
3. Enter the following code in the filterGroups section:

[
  {
    "filters": [
      {
        "propertyName": "hs_lastmodifieddate",
        "operator": "GT",
        "value": "{{lastExportDateTime}}"
      }
    ]
  }
]

4. Save and close the filter, and run the flow.

Contacts API

1. Create a HubSpot export with the following settings:
   • API version: v3
   • API name: CRM API: Contacts
   • API endpoint: Search for Contacts
2. In the Configure body parameters section, click Launch. The Search parameters window opens.
3. Enter the following code in the filterGroups section:

[
  {
    "filters": [
      {
        "propertyName": "lastmodifieddate",
        "operator": "GT",
        "value": "{{lastExportDateTime}}"
      }
    ]
  }
]

4. Save and close the filter, and run the flow.

Note: The Contacts API uses the field 'lastmodifieddate' whereas the Companies API and the Deals API use 'hs_lastmodifieddate'.

Deals API

1. Create a HubSpot export with the following settings:
   • API version: v3
   • API name: CRM API: Deals
   • API endpoint: Search for Deals
2. In the Configure body parameters section, click Launch. The Search parameters window opens.
3. Enter the following code in the filterGroups section:

[
  {
    "filters": [
      {
        "propertyName": "hs_lastmodifieddate",
        "operator": "GT",
        "value": "{{lastExportDateTime}}"
      }
    ]
  }
]

4. Save and close the filter, and run the flow.