topic Get all customer transactions report in Integration and Testing

Get all customer transactions report

saplyng — Mon, 06 Nov 2023 19:37:14 GMT

For legal purposes I'm trying to use the API to get all of a customer's transactions. Through the website Transaction Search it's possible to search for everything using the MerchantCustomerID, but the closest thing exposed through the API is using the CustomerProfileID in the getTransactionListForCustomerRequest. However, this only gets the first transactions that were created through the API and none of the subsequent recurring billing ones that should belong to that customer. And using the ARBGetSubscriptionRequest limits the results to the last 20 transactions under the specified subscription, with no ability to paginate, so it would be unreliable to complete a customer transaction report.

So, is there some way to generate a complete customer transaction report through the API or possibly a way to expose the MerchantCustomerID Search that's already available through the website to the API?

Re: Get all customer transactions report

marine2026 — Tue, 07 Nov 2023 03:00:51 GMT

I'm guessing that you looked through the Transaction Reporting docs.. but in case you didn't.

https://developer.authorize.net/api/reference/index.html#transaction-reporting

Re: Get all customer transactions report

saplyng — Tue, 07 Nov 2023 17:52:24 GMT

Any given customer's payments could span potentially hundreds of batches over the time span they were a customer and the getTransactionListForCustomerRequest function only returns the first transaction made through the API not all the transactions the customer has that were recurring. Similarly, the ARBGetSubscriptionRequest only provides the 20 most recent transactions with no options for pagination.