topic Questions about new Reporting API in Integration and Testing

Questions about new Reporting API

tproell — Fri, 22 Oct 2010 19:44:50 GMT

I'm looking for a way to run a nightly settlement report via an API, but the new reporting options seem to only allow me to query the results of a Batch or a specific transaction. What I'd like to be able to do is get the data for all transactions within a specified date range. TransactionID, transaction type, amount, etc. My application currently processes individual transactions in real time using hte AIM integration.

My goal is to create a nightly reconciliation between my application and the data from Authorize.Net.

Is there a way to do this via an API?

Re: Questions about new Reporting API

stymiee — Fri, 22 Oct 2010 20:02:20 GMT

Sure, just use the new batch reporting API call to get the transaction IDs within the specified date range and then use the new transaction report API to get the specific information you are looking for from each transaction in the batch settlement report.

Pseudo code:

Get Batch Report
Foreach transaction
    Make transaction API call
    Get transaction information

Re: Questions about new Reporting API

fiftyandfifty — Wed, 27 Oct 2010 18:38:34 GMT

We have the same problem. We don't see transaction details in the batch API call response.

Check the example posted on the Authorize side:

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

There are no ID's in that example either.

Re: Questions about new Reporting API

Michelle — Fri, 29 Oct 2010 22:30:39 GMT

Hey there,

Check out our latest release here. This should help you with your issue as this release ties all three calls together so you can get what you need.

Thanks,

Michelle

Developer Community Manager

Re: Questions about new Reporting API

fiftyandfifty — Wed, 15 Dec 2010 23:59:15 GMT

That does solve the problem we are having of connecting the three but now my issue lies with getTransactionDetails not having all the data the Silent Post gets. The one I need is SUBSCRIPTION ID so the transactions your API finds can be tied to the user's Subscription. Thoughts?

Re: Questions about new Reporting API

stymiee — Thu, 16 Dec 2010 14:21:08 GMT

You're not capturing the subscription ID when the subscription is created?

Re: Questions about new Reporting API

fiftyandfifty — Thu, 16 Dec 2010 18:50:16 GMT

We have the subscription ID but when you look at a transaction detail, it doesn't have the subscription ID tied to it. So how do I use the API to find ARB subscriptions and add them to our system if the transaction detail doesn't tell me what Subscription ID the transaction belongs to?

Re: Questions about new Reporting API

stymiee — Thu, 16 Dec 2010 19:38:14 GMT

Gotcha. So you're looking for the link to connect the two. Hopefully someone who is more familiar with the reporting API can make a suggestion.

Re: Questions about new Reporting API

Trevor — Fri, 17 Dec 2010 23:05:52 GMT

Unfortunately there is no way currently to retreive the subscription ID with a transaction details request. This is certainly something that may be added, but I don't have any kind of timeline that I can provide. My best recomendation for the moment is to make use of the invoice number field so that you can keep track of which subscription goes with which transaction. You can specify your own invoice number when creating a subscription and this will end up int he transaction details for each transaction that it generates.

Re: Questions about new Reporting API

mtipom — Mon, 12 Sep 2011 20:07:41 GMT

Just curious if any headway has been made on this issue (tying tranactions to subscriptions). I have been using the invoice number for this, but was curious if this would soon be available through the API. Thanks.

Re: Questions about new Reporting API

TJPride — Mon, 12 Sep 2011 22:20:12 GMT

I just use the callback page to associate charges with subscriptions. Perhaps not as elegant if you want to use the transaction details API for everything, but it works.

Re: Questions about new Reporting API

Michelle — Thu, 15 Sep 2011 21:16:16 GMT

Hey mtipom,

No, we have not yet added any ARB subscription info into the reporting API. But we've definitely passed that feedback on to our development teams.

Thanks,

Michelle

Developer Community Manager