REST API for Transactions (Payments) by Date

Is there any way to get at the payments table with the REST APIs without OrderIDs? I’d like to create a reconciliation script between our Auth.net Gateway and Keap Payments. The valuable Ref Num field that’s available on the Keap Payments report is being elusive to me on the REST API. Thanks for any help!

Hi @Jeff_Santoro, thanks for checking in on this.

That’s one of the identified gaps in REST v2. Accessing payments in that way is being tracked in our known issues tracker.

I’ll be sure to share an update here as soon as we have more information.

Thanks for the quick reply! There isn’t much for details other than GAP and last update date (no update details). Should I plan on building my reconciliation engine off the back of XML-RPC and then have ample time to upgrade/convert before those endpoints are pulled? I’m trying to get the lay of the land here in terms of my development efforts and timeline against XML-RPC going away and REST V2 being a viable replacement for it. Thanks in advance.

Thanks for thinking ahead on this! The team has confirmed we’ll be working on closing this gap in REST v2, and the plan is to roll it out before XML-RPC is sunset. We’ll keep you posted as things progress.