Error of Search Contact API when response over 10,000 contacts

pmaxodoo — Tue, 05 Apr 2022 09:33:51 GMT

Hi all,

I met this error and i dont know why. I search the lastmodified contact after a timestamp:

public_object_search_request = PublicObjectSearchRequest(filter_groups=[{"filters":[{"value":"1649130562421",

"propertyName":"lastmodifieddate",

"operator":"GTE"}]}],

sorts=["DESCENDING"],

properties=["id"],

limit=100,

after=9900)
try:
api_response = client.crm.contacts.search_api.do_search(public_object_search_request=public_object_search_request)

pprint(api_response)
except ApiException as e:
print("Exception when calling search_api->do_search: %s\n" % e)

Resonpse:

"total": 10010,

"results": []

"paging": {
"next": {
"after": "10000"
}
}

After this response, I call this request:

public_object_search_request = PublicObjectSearchRequest(filter_groups=[{"filters":[{"value":"1649130562421",

"propertyName":"lastmodifieddate",

"operator":"GTE"}]}],

sorts=["DESCENDING"],

properties=["id"],

limit=100,

after=10000)
try:
api_response = client.crm.contacts.search_api.do_search(public_object_search_request=public_object_search_request)

pprint(api_response)
except ApiException as e:
print("Exception when calling search_api->do_search: %s\n" % e)

Then I got this response:

HTTP 400

{
"status": "error",
"message": "There was a problem with the request.",
"correlationId": "2e7a35b9-dc8b-4cb5-8db8-4a573efe7cfc"
}

What am I doing wrong here?

Thank you so much!!!!

Re: Error of Search Contact API when response over 10,000 contacts

dennisedson — Tue, 05 Apr 2022 17:14:21 GMT

If you look in the docs, there is actually a limit of the Search API with results over 10k. When you hit that limit, you can expect a 400 error.

pmaxodoo — Wed, 06 Apr 2022 02:29:37 GMT

Thanks, @dennisedson. My fault for not reading all the docs carefully.

dennisedson — Wed, 06 Apr 2022 02:37:20 GMT

No worries! Hope you can refactor your code accordingly!