Marketo Rest API. Querying by fitler type returns error 1003 "Too many results match the filter" if matches found are more than 1000 | Community
Skip to main content
October 11, 2016
Question

Marketo Rest API. Querying by fitler type returns error 1003 "Too many results match the filter" if matches found are more than 1000

  • October 11, 2016
  • 1 reply
  • 5692 views

We are recently seen this issue when using the rest API. Currently we have 1002 records matching this criteria. Initially it was suggested that specifying the batchSize field would fix the issue. However this is not the case. So far I have not been able to find any documentation around this behavior non provided by Marketo. I was only able to find one other mention of this behavior in listed in the github readmen page for a Python implementation of the Marketo Rest API (https://github.com/segmentio/marketo-rest-python/blob/master/README.md).

A couple of questions:

1- Is this an expected behavior?

2- If so. Is there a work around for this issue?

Request:

GET [Removed].mktorest.com/rest/v1/leads.json?filterType=testID&fields=id&filterValues=1&batchSize=300 HTTP/1.1

Authorization: bearer [Removed]

Host: [Removed].mktorest.com

Response:

HTTP/1.1 200 OK

Server: nginx

Date: Tue, 11 Oct 2016 15:10:59 GMT

Content-Type: application/json;charset=UTF-8

Content-Length: 121

Connection: keep-alive

{"requestId":"48db#157b44bf4c0","success":false,"errors":[{"code":"1003","message":"Too many results match the filter"}]}

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

SanfordWhiteman
Level 10
October 11, 2016

This limit is documented. I guess I would ask why you're using a lookup key that's so far from unique, and what you're trying to do with the data. If you're trying to do a batch update (perhaps of this very field?) you can use a webhook instead.

If you describe your setup + requirements further we can give better advice.

October 11, 2016

Thanks for your answer. Before anything. Could you provided me to the link documenting this behavior?

Thank you.

SanfordWhiteman
Level 10
October 11, 2016

Y'know, I might just have known about this from experience and a Community post, not the official docs. Regardless, it isn't going away. :)