I can successfully limit Contacts to return only those with a "Last Modified Date" > some date, but for ContactPropertiesHistory, it is returning the entire table, which is quite large. Is there any way to limit it to the most recent? I am using the Advanced Mode SQL Query with the HubSpot Query connector for both. For (working) Contacts, I'm using Select * from Contacts WHERE "Last Modified Date" >= '${updated_at}'. For (returns all) ContactPropertiesHistory, I'm using: Select * from ContactPropertiesHistory WHERE "Timestamp" '${updated_at}'. Thanks in advance for any help!
Hi @DHaze
I had a look into this for you and we would require a bit of a closer look into it, I have raised a support case on your behalf, the support team will be in contact soon.
Kind regards, Joe