ARB Subscription Reporting

[spinon23]

I was reviewing the ARB API and I do not currently see a way to retrieve history for an ARB. I need to display all payments that have been processed. Is there someway that I can do this using that API or do I need to be looking at something else. I was hoping there would be some simple reporting interface that I could use but I didn't see anything for that either.

Thank you

[Elaine · Accepted solution]

It is not currently possible to query an ARB subscriptions transaction history via API. The only available post-activity API call that can be made to an ARB subscription right now is the ARBGetSubscriptionStatus discussed here: http://community.developer.authorize.net/t5/News-and-Announcements/New-ARB-Call-ARBGetSubscriptionSt...

You can call transaction history in general however. The Reporting API's are discussed in the following threads:

http://community.developer.authorize.net/t5/News-and-Announcements/New-API-Call-getTransactionDetail...

http://community.developer.authorize.net/t5/News-and-Announcements/New-API-Call-getSettledBatchList/...

http://community.developer.authorize.net/t5/News-and-Announcements/New-API-Call-getTransactionList/t...

In addition, there has been discussion regarding adding functionality to the Reporting API for ARB specific calls, however at this time there aren't any included in the API. At this time, all of your ARB transaction history should be obtained from your merchant transaction receipts, your ARB Daily Transaction Summaries and your merchant interface.

Thank you,

Elaine

[spinon23]

Thanks for the reply. I didn't think I saw anything for that but wanted to make sure.

I will just keep an eye out for the proposed changes to reporting. Hopefully then it will have what I need.

[Britinusa]

If our goal is to retrieve ARB subscription renewals so that we can integrate the data from a.net to our own data. Then, am I correct in thinking that at present we have to use the Reporting API.

eg.

• use getSettledBatchListRequest  to get the Batches that occured during the requested data range.
• use GetTransactionListRequest to get the Transaction info for all items in each batch.

However, there is no reference in the GetTransactionListRequest to either the Subscription ID or the Customer ID

(Subscription ID is generated by a.net at time of initial ARB creation)

(Customer ID is generated by the developer at the time of the initial ARB creation)

Without at least one of those ID's we cannot tie the data from the reports to our internal data.

Any chance that either Customer ID or Subscription ID be included in the response if specifically requested.

eg. in the request have something like my suggested optional include fields (shown in red below)

<includeCustomerID>true</includeCustomerID>

<includeSubscriptionID>true</includeSubscriptionID>

If anyone has already figured out how to download via the API the ARB transactions with a reference to the Customer ID or Subscription ID please chime in.

[Elaine]

This is a feature request that has been submitted to our product development group. At this time, it is not possible to retrieve ARB subscription data programmatically. Data can be collected on your server when it is created or updated or you can manually view your account for this information.

Thank you,

Elaine

[bmoomaw]

Hello.. Elaine, can you suggest any timeframe for when this product feature will be implemented?  Or is there another group at Authorize.net whom i might contact to find out a bit more about the scheduling?  thanks.

[Michelle]

Hi bmoomaw,

Unfortunately I cannot give you any kind of timeframe--no one here really can. But I can assure you that our development teams are well aware of the need and expressed desire for such a feature.

Thanks,

Michelle

Developer Community Manager

[railsmonster]

Hi guys!

I’m using SilentPostUrl & TransactionDetailsApi for get all information about transactions.
But, we want to use only Transaction Details API.

Does it possable to get SubscriptionPaynum via TransactionDetails API (without SilentPostUrl)?

I posted this question to support (developer@authorize.net) many times! But, I have no answer! )
Maybe, somebody knows? )

Thanks, Ruslan

[sucre]

HI, Michelle:

      Till now, is it possible to get the subscriptionId according to a transactionId?

      If it is possible, please give me some sample codes(c#) for that, if it is impossible, how can i get the ARB transaction result with the exception of silent post?

     Please reply ASAP, thank you very much.

[TJPride]

Just pass some internal ID of your own either in field refId or in a custom field, that way when the callback URL is triggered by a payment, you can look up the ID in your internal database and match it up with the subscription ID. Essentially, you'd create the subscription record in your db first, pass the record ID to Authorize.net, update the subscription record with the subscription ID. From then on you're golden - every callback passes the record ID and the record ID takes you to the subscription ID.