topic Re: ARB Transaction Details API and Customer Link? in Integration and Testing

ARB Transaction Details API and Customer Link?

Knuckles2002 — Mon, 06 Aug 2012 20:30:45 GMT

Hello All,

I am using Authorize.net's Transaction Details API with Classic ASP with the following sample code that works!

I have a Classic ASP Script that goes out to Authorize.net's Transaction Detail API to see what customers have declined. The script work great except for two issues I have.

1. How do you show itemized items ex: Response.Write objResponse.selectSingleNode("/*/api:declineCount").Text

2. I can't figure out how I could link this info with my customers. My database stories the customer's Subscription ID but it doesn't seem to be included in the Output of the API.

Any help or suggestions great appreciated!

Thanks in advance for the help!

Francis G

************************************************************
* SCRIPT BELOW TO PULL TRANSACTION DETAILS...
************************************************************

strXML = "<?xml version=""1.0"" encoding=""utf-8""?>"
strXML = strXML & "<getSettledBatchListRequest xmlns="AnetApi/xml/v1/schema/AnetApiSchema.xsd">"
strXML = strXML & "<merchantAuthentication>"
strXML = strXML & "<name>XXXXXXXXX</name>"
strXML = strXML & "<transactionKey>XXXXXX</transactionKey>"
strXML = strXML & "</merchantAuthentication>"
strXML = strXML & "<includeStatistics>true</includeStatistics>"
strXML = strXML & "<firstSettlementDate>2012-08-03T00:19:38Z</firstSettlementDate>"
strXML = strXML & "<lastSettlementDate>2012-08-04T00:19:38Z</lastSettlementDate>"
strXML = strXML & "</getSettledBatchListRequest>"

post_url = "https://api.authorize.net/xml/v1/request.api"

'Start to process and post the XML data to authorize.net.
Set objHTTP = Server.CreateObject("Microsoft.XMLHTTP")
objHTTP.open "post", post_url, False

objHTTP.setRequestHeader "Content-Type", "text/xml"

'Send the XML off to Authorize.net
objHTTP.send strXML

'Show the response from authorize.net.

Response.Write "Raw response: " & Server.HTMLEncode(objHTTP.responseText)

'Parse the returned XML from authorize.net to see what the charge results were.
Set objResponse = Server.CreateObject("MSXML2.DOMDocument.4.0")
objResponse.loadXML objHTTP.responseText
objResponse.setProperty "SelectionNamespaces", "xmlns:api='AnetApi/xml/v1/schema/AnetApiSchema.xsd'"

Response.Write objResponse.selectSingleNode("/*/api:declineCount").Text

Re: ARB Transaction Details API and Customer Link?

Knuckles2002 — Mon, 06 Aug 2012 20:23:09 GMT

BTW Here is the response I get from the script above:

Raw response: <?xml version="1.0" encoding="utf-8"?><getSettledBatchListResponse xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="AnetApi/xml/v1/schema/AnetApiSchema.xsd"><messages><resultCode>Ok</resultCode><message><code>I00001</code><text>Successful.</text></message></messages><batchList><batch><batchId>XXXXXXXX</batchId><settlementTimeUTC>2012-08-03T23:38:03Z</settlementTimeUTC><settlementTimeLocal>2012-08-03T19:38:03</settlementTimeLocal><settlementState>settledSuccessfully</settlementState><paymentMethod>creditCard</paymentMethod><statistics><statistic><accountType>AmericanExpress</accountType><chargeAmount>19.95</chargeAmount><chargeCount>1</chargeCount><refundAmount>0.00</refundAmount><refundCount>0</refundCount><voidCount>0</voidCount><declineCount>0</declineCount><errorCount>0</errorCount></statistic><statistic><accountType>MasterCard</accountType><chargeAmount>39.90</chargeAmount><chargeCount>2</chargeCount><refundAmount>0.00</refundAmount><refundCount>0</refundCount><voidCount>0</voidCount><declineCount>1</declineCount><errorCount>0</errorCount></statistic><statistic><accountType>Visa</accountType><chargeAmount>19.95</chargeAmount><chargeCount>1</chargeCount><refundAmount>0.00</refundAmount><refundCount>0</refundCount><voidCount>0</voidCount><declineCount>2</declineCount><errorCount>0</errorCount></statistic></statistics></batch></batchList></getSettledBatchListResponse>

Re: ARB Transaction Details API and Customer Link?

Joy — Fri, 10 Aug 2012 22:34:47 GMT

Hi Knuckles2002,

The getTransactionDetails API will give you the line item information, if that is what you are referring to.

Right now it is not possible to query ARB subscriptions using the Transaction Details API.You may want to check this previous thread for details.

Thanks,

Joy