We have 2 millions prospects in our Pardot account and we want to get some of the prospects. How to get those prospects based on custom field? We use Pardot API version 4 in our code base, but there's no search criteria by custom field.
I was trying to query all of our prospects by code, output mode equals simple and filter all custom field by a value, due to each query has a 200 results limit, I have to do this process many times. But during the running of the code, it stops at some point and I couldn't keep continue query that unless running from the beginning. There's no problem with daily API call limit and api_key timeout, I checked them.
Is there any better way to get that? Thanks