Get failed payments from invoice

API Q&A
#1

Hello,

I’m reviewing the Table Schema and I don’t see a way to pull the failed payments for an invoice. Like what is shown on this page (https://xxx.infusionsoft.com/app/payment/viewPaymentHistoryForInvoice?invoiceId=XXXXXX).

Does anyone where these are stored?

Thanks!

#2

Hi @Austin_Biggs, I don’t think we allow access to the table that those PayPlanPayAttempts are stored in. I would recommend running a failed payment report in the application itself, saving it as a saved search, and then retrieving that report via the xmlrpc SearchService.getSavedSearchResultsAllFields.