topic Re: Deal Search API - filtering last modified date in APIs & Integrations

Deal Search API - filtering last modified date

Stanza — Fri, 03 Dec 2021 03:13:43 GMT

Hi,

I have the search API:

https://api.hubapi.com/crm/v3/objects/deals/search?hapikey=[API_KEY]

{ "filterGroups": [ { "filters": [ { "value": "7695775", "operator": "EQ", "propertyName": "dealstage" }, { "value": "hs_lastmodifieddate", "operator": "GTE", "propertyName": "1638316800" } ] } ], "properties": [ "dealname" ] }

I get the following error:

{ "status": "error", "message": "There was a problem with the request.", "correlationId": "24709551-9717-4d21-b969-f4a2442ac88e" }

I have tried seconds and milliseconds but get the same error.

Any ideas ?

I have tried using the epoch time converter but no luck.

Re: Deal Search API - filtering last modified date

RMones — Fri, 03 Dec 2021 11:44:06 GMT

Hi @Stanza ,

You have to swap the value and propertyName. You mixed the value and propertyName aths_lastmodifieddate:

{
"value": "hs_lastmodifieddate",
"operator": "GTE",
"propertyName": "1638316800"
}

to

{
"propertyName": "hs_lastmodifieddate",
"operator": "GTE",
"value": "1638316800"
}

Regards, Ronald

Re: Deal Search API - filtering last modified date

dennisedson — Fri, 03 Dec 2021 15:40:00 GMT

Spot on @RMones !

Also, make sure you are working with a unix timestamp in milliseconds!

Re: Deal Search API - filtering last modified date

Stanza — Mon, 06 Dec 2021 02:49:52 GMT

yes - have sorted this oiut - there were multiple tickets from me about this - I have to created another one since the first got tagged as spam - dunno why.