Hi,
I am trying to search a record based on filter group as below :
Search payload: {
“filterGroups”: [
{
“filters”: [
{
“propertyName”: “hs_timestamp”,
“operator”: “LT”,
“value”: “1779782465623”
},
{
“propertyName”: “soft_delete”,
“operator”: “EQ”,
“value”: “false”
}
]
}
],
“properties”: [
“hs_object_id”,
“hssync_timestamp”
],
“limit”: 100
}
2026-05-26 13:31:10 | INFO | src.hubspot_client | Search URL: https://api.hubapi.com/crm/objects/2026-03/2-61751477/search
Result in hubspot client in soft delete method [{‘id’: ‘56430316726’, ‘properties’: {‘hs_createdate’: ‘2026-05-26T08:00:43.665Z’, ‘hs_lastmodifieddate’: ‘2026-05-26T08:01:10.243Z’, ‘hs_timestamp’: ‘2026-05-26T08:01:05.623Z’}, ‘createdAt’: ‘2026-05-26T08:00:43.665Z’, ‘updatedAt’: ‘2026-05-26T08:01:10.243Z’, ‘archived’: False, ‘url’: ‘HubSpot’}
There are currently 140 records in hubspot and we are currently searching the stale records with the above condition and marking those record’s column “delete flag” to true. So we are using first search and then update api. But problem here is SEARCH API is not working fine as it retrun records for the given epoch time which it should not return.
Any suggestion for the same.
Thanks
Hey @Rna81,
Thanks for taking the time to post in the Community!
I’d like to tag in a few experts here to see what we might be able to troubleshoot together. @Mike_Eastwood, @SteveHTM, and @stefen - do any of you have ideas on why the SEARCH API is not working?
Shane, Senior Community Moderator
It seems issue is with search index because it is getting delay. Any workaround it to resolve apart from time.sleep(60) between the 2 calls (upsert and archive/soft delete).
Thanks