Retrieve data from a custom object using property updatedAt

Developer Support APIs & Integrations
1

I’m trying to retrieve the latest data from a custom object based on updates to the custom property ‘hs_property’.

Currently, I download all the data from my custom object and then filter out those that have differences in the ‘hs_property’ property by querying

/crm/v3/objects/my_custom_object?properties=hs_property&propertiesWithHistory=hs_property.

When I download the history of ‘hs_property’, I can obtain the following data:

"propertiesWithHistory": { 
"hs_property": [ 
{ "value": "91733425", 
"timestamp": "2023-08-01T20:24:16.167Z", 
"sourceType": "CRM_UI_BULK_ACTION", 
"sourceId": "userId:45938323", 
"updatedByUserId": 45938323 }, 
{ "value": "91734878", 
"timestamp": "2023-07-24T19:12:50.465Z", 
"sourceType": "AUTOMATION_PLATFORM", 
"sourceId": "enrollmentId:657628440960;actionExecutionIndex:0" }, ...

And with the timestamp, I can obtain the latest records.

Is there a way to create a filter using https://api.hubapi.com/crm/v3/objects/my_custom_object/search that can search within ‘hs_property.timestamp’ or something similar?

I mean, searching for an attribute within a property of a custom object:

"filterGroups": [ { "filters": [ 
{ "propertyName": "hs_property.timestamp", 
"operator": "GTE", 
"value": 1693348220000 } 
] } ]
2

Hey, @IsaiasFlat :waving_hand: Thanks for your question. You are not missing an option. This one will fall under “currently not possible”.

We can use properties with the Search API, but not use their sub-properties like timestamp, as additional filters.

I understand why this would be a useful addition to the options in those endpoints.

Best,

Jaycee

3

Thank you for the reply.

Understood, thank you.