topic Re: ARB Subscription Reporting in Integration and Testing

ARB Subscription Reporting

spinon23 — Fri, 07 Jan 2011 19:19:52 GMT

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

Re: ARB Subscription Reporting

Elaine — Tue, 11 Jan 2011 00:34:11 GMT

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-ARBGetSubscriptionStatus-Available-on-8-24/td-p/4824

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-getTransactionDetails/td-p/5962

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

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

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

Re: ARB Subscription Reporting

spinon23 — Tue, 11 Jan 2011 18:29:38 GMT

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.

Re: ARB Subscription Reporting

Britinusa — Fri, 04 Mar 2011 15:01:31 GMT

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)

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.

Re: ARB Subscription Reporting

Elaine — Tue, 15 Mar 2011 21:16:22 GMT

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

Re: ARB Subscription Reporting

bmoomaw — Fri, 13 May 2011 19:12:20 GMT

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.

Re: ARB Subscription Reporting

Michelle — Mon, 16 May 2011 17:24:59 GMT

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

Re: ARB Subscription Reporting

railsmonster — Mon, 06 Jun 2011 11:59:08 GMT

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

Re: ARB Subscription Reporting

sucre — Tue, 25 Oct 2011 09:26:43 GMT

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.

Re: ARB Subscription Reporting

TJPride — Tue, 25 Oct 2011 15:37:43 GMT

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.

Re: ARB Subscription Reporting

sucre — Wed, 26 Oct 2011 03:29:12 GMT

Hi TJPride,

Thanks for your reply.

"call back URL", what is that? Is it silent post URL.But actually i don't want to use that feature.

My C# test codes as bellow:

ReportingGateway _reportGateway = new ReportingGateway(ConfigurationManager.AppSettings["ApiLogin"], ConfigurationManager.AppSettings["TransactionKey"], ServiceMode.Test);

List<Transaction> transactions = _reportGateway.GetUnsettledTransactionList();

There are many fields in the instance of Transaction, but there is no subscriptionId in it, how can i get it from the transaction according to its transactionId or other related field.

Appreciate for your help.

Re: ARB Subscription Reporting

TJPride — Wed, 26 Oct 2011 03:35:48 GMT

As far as I know, the transaction details API doesn't give that information. Therefore, the only way to get it is to store it as the transactions go through, using the silent post URL. Up to you whether you which option you hate more - not having the information, or having to mess with silent post.

Re: ARB Subscription Reporting

sucre — Wed, 26 Oct 2011 04:25:45 GMT

Thanks for your reply.

I think I have got the answer, appreciate for your help.

Re: ARB Subscription Reporting

shanaver — Tue, 12 Jun 2012 22:22:20 GMT

Elaine,

Is there a timeframe for adding the subscription ID & subscription paynum to the getTransactionDetailsRequest response?

It's been over a year since this simple feature request was submitted to your product development group. It's a huge gap in this API - an API that was only even offered after years of requests from developers.

I think I should point out that there are better options for us developers these days - like Stripe, for example, who realize it's us who are implementing these payment solutions. When our requests fall on deaf ears - like this simple addition to the response - we feel like Authorize is basically telling us to get lost and f' off.

Re: ARB Subscription Reporting

Michelle — Mon, 18 Jun 2012 16:51:47 GMT

Hi shanaver,

Unfortunately, no, this has not yet been added, and I don't have an estimated timeframe for when it will be. Our development teams are aware of the need though, I can assure you of that much. We take feedback from the community very seriously and pass on every suggestion for new features to our developers.

Thanks,

Michelle

Developer Community Manager

Re: ARB Subscription Reporting

jclamp — Sat, 20 Apr 2013 10:44:54 GMT

I just wanted to second this. We had a server outage recently. (Actually our ssl went out and silent post was posting to that so we lost a bunch of posts). I downloaded a CSV of batch settlements for the couple of days of outage but it does not contain subscription id. I tried using gettransactiondetail but it does not contain subscription id. I loaded the csv into mysql and did a query and found over 1000 transaction ids missing. But right now there's no way for me to figure out what transaction goes with what subscription. It's very sad. I simply can not find a way to get our records up to date. There should be a way to do this. Please if someone can respond.

Re: ARB Subscription Reporting

TJPride — Mon, 22 Apr 2013 16:35:49 GMT

The Transaction Details API returns customer ID and email, so if you filled those in on the ARB subscription, you should be able to match up the transactions that way. Theoretically - it's been a while since I messed with ARB. If you didn't include any customer identifying information, you're kind of out of luck.