topic Search request http 400 error in APIs & Integrations

Search request http 400 error

AndreyK2478 — Tue, 05 Nov 2024 09:17:53 GMT

Hi,

I need to get calls from the last day. According to the docs I made the request:

curl --request POST \
--url https://api.hubapi.com/crm/v3/objects/calls/search \
--header 'authorization: Bearer MY_TOKEN' \
--header 'content-type: application/json' \
--data '{
"filterGroups": [
  {
    "filters": [
      {
        "propertyName": "createdAt",
        "value": "2024-11-05T00:00:00",
        "operator": "GTE"
      }
    ] 
  }
],
"limit": 200
}'

And got the following error:

{
  "status":"error",
  "message":"There was a problem with the request.","correlationId":"8b52abf3-b86a-4010-9b3e-511c27959e6e"
}

I wondered - what I did wrong. The error message is not clear.
How can I search by created date?

Thanks for any help.

Re: Search request http 400 error

WesQ — Tue, 05 Nov 2024 13:21:22 GMT

Hi @AndreyK2478 !
Whenever I encounter the, "There was a problem with the request" error. I try to check the JSON body of my request, because it's probably not what Hubspot API is expecting.

In your case, the date format "2024-11-05T00:00:00"is returning an error because it lacks the time zone offset, which HubSpot requires to correctly parse date-time strings. HubSpot typically expects dates in ISO 8601 format, which includes a time zone offset, such as "2024-11-05T00:00:00Z"

Try adding a Z at the end of your date format and see if it works.

I suspect also that you are using an incorrect property name. Try using "hs_createdate" instead of "createdAt"

{ "filterGroups": [ { "filters": [ { "propertyName": "hs_createdate", "value": "2024-11-05T00:00:00Z", "operator": "GTE" } ] } ] }

You can check property names using the properties API:

"/crm/v3/properties/events"

Reference to date format ISO 8601:

https://developers.hubspot.com/beta-docs/guides/api/crm/properties

Was I able to help answer your question? Help the community by marking it as a solution.

Re: Search request http 400 error

WesQ — Tue, 05 Nov 2024 14:31:32 GMT

Hi @AndreyK2478!
Whenever I encounter the, "There was a problem with the request" error. I try to check the JSON body of my request, because it's probably not what Hubspot API is expecting.

Try adding a Z at the end of your date format and see if it works.

I suspect also that you are using an incorrect property name. Try using "hs_createdate" instead of "createdAt"

You can check property names using the properties API:

"/crm/v3/properties/events"

Reference to date format ISO 8601:

https://developers.hubspot.com/beta-docs/guides/api/crm/properties

Was I able to help answer your question? Help the community by marking it as a solution.

Re: Search request http 400 error

WesQ — Tue, 05 Nov 2024 14:34:21 GMT

I am trying to reply but it seems my replies get deleted.

Re: Search request http 400 error

WesQ — Tue, 05 Nov 2024 14:35:56 GMT

{

"filterGroups": [

{

"filters": [

{

"propertyName": "hs_createdate",

"value": "2024-11-05T00:00:00Z",

"operator": "GTE"

}

]

}

]

}

Re: Search request http 400 error

WesQ — Tue, 05 Nov 2024 14:45:17 GMT

Testing reply

Re: Search request http 400 error

WesQ — Tue, 05 Nov 2024 14:47:07 GMT

{

"filterGroups": [

{

"filters": [

{

"propertyName": "hs_createdate",

"value": "2024-11-05T00:00:00Z",

"operator": "GTE"

}

]

}

]

}

Re: Search request http 400 error

WesQ — Tue, 05 Nov 2024 15:09:15 GMT

Hi @AndreyK2478!
Whenever I encounter the, "There was a problem with the request" error. I try to check the JSON body of my request, because it's probably not what Hubspot API is expecting.

Try adding a Z at the end of your date format and see if it works.

I suspect also that you are using an incorrect property name. Try using "hs_createdate" instead of "createdAt"

{
"filterGroups": [
{
"filters": [
{
"propertyName": "hs_createdate",
"value": "2024-11-05T00:00:00Z",
"operator": "GTE"
}
]
}
]
}

You can check property names using the properties API:

/crm/v3/properties/events

Reference to date format ISO 8601:

https://developers.hubspot.com/beta-docs/guides/api/crm/properties

Was I able to help answer your question? Help the community by marking it as a solution.

Re: Search request http 400 error

AndreyK2478 — Wed, 06 Nov 2024 09:46:36 GMT

Works with "hs_createdate", but the time format should be like:

"value": "2024-09-01T10:10:56.332Z"