There may be scenarios where traditional TIBCO Scribe® Online filtering methods used to limit HubSpot data, such as using a Filter or Net Change dates, do not work.  You can use a HubSpot Smart List to work around this problem.

In this example the goal is to limit records from the Contact entity.  Assume you want to process only changes to contacts that were newly created.  The issue is that mass changes can be made to Contacts in HubSpot causing the ChangeDate to be updated.  This causes extra records to be processed when using the Process only records created or updated since last run option on the Query Block Net Change tab.  To solve this issue use a Smart List instead of using the Process only records created or updated since last run option, as follows:

Generate a Smart List using the appropriate criteria in HubSpot.
https://knowledge.hubspot.com/lists-user-guide/how-to-create-a-list-of-your-contacts
 

Creating A Smart Contact List
 

In HubSpot, create a New Smart Contact List and start adding filters/properties.



Add the appropriate Filters to the List.


 
Save the List. Note that the List ID is in the URL.



In TIBCO Scribe® Online, use the list in the source Query Block by specifying the list ID on the Filter tab.





In the Query Block Include tab select ContactListMember.



 
Retrieve Contact information with a Lookup Block by filtering on the VID and selecting the appropriate Fields to return.


 

Map the appropriate fields.  The list of contacts in the Query Block is determined by the filters in the HubSpot Contact List.


 

How to use HubSpot Smart Lists for filtering and processing Contact records.