PayPal TransactionSearch API: How to page through results if there are more than 100 matches

Question

As described in the doc (https://developer.paypal.com/webapps/developer/docs/classic/api/merchant/TransactionSearch_API_Operation_SOAP/), "The maximum number of transactions that can be returned from a TransactionSearch API call is 100."

So what is the recommended approached if I want to page through all the results? I suppose I could shorten the time rage until it fits less than 100 results but that's really lame...

Answer 1

When transaction search has more than 100 transaction, PayPal sends 100 transaction with ACK as SuccessWithWarning.

When you get ACK = SuccessWithWarning, get timestamp of last transaction from the result. Now make another transaction search call with STARTDATE equal to last transaction's timestamp.

Continue till you get ACK = Success.

Hope this helps.