topic Re: Card Number is null in Transaction Detail API for AIM in Integration and Testing

Card Number is null in Transaction Detail API for AIM

nihirporecha — Tue, 27 Mar 2012 06:23:27 GMT

Hi All,

I am using AIM. For development I am using C# SDK. I need to process refund using API. I do not store any of the card information. So, I have decided to fetch the information from transaction details API. But, I am getting null value for card number.

Help please!

Thanks,

Nihir Porecha

Re: Card Number is null in Transaction Detail API for AIM

TJPride — Tue, 27 Mar 2012 09:24:42 GMT

What are you getting for the rest of the Transaction Details response? Can you post a var dump of the response?

Re: Card Number is null in Transaction Detail API for AIM

nihirporecha — Tue, 27 Mar 2012 09:52:34 GMT

Hi below is the values. I have removed BatchsettlementId, TransactionId and Authorzation code values.

        AuthorizationAmount   0.27   decimal
       AuthorizationCode   ""   string
       AVSCode   "P"   string
       AVSResponse   "AVS not applicable for this transaction "   string
+       BatchSettledOn   {3/15/2012 12:20:54 AM}   System.DateTime
       BatchSettlementID   ""   string
       BatchSettlementState   "settledSuccessfully"   string
+       BillingAddress   {AuthorizeNet.Address}   AuthorizeNet.Address
       CardExpiration   null   string
       CardNumber   null   string
       CardResponse   "Match"   string
       CardResponseCode   "M"   string
       CardType   null   string
       CAVVCode   null   string
       CAVVResponse   "Blank or not present - CAVV not validated"   string
       CustomerEmail   null   string
       CustomerID   null   string
+       DateSubmitted   {3/14/2012 10:59:42 PM}   System.DateTime
       Description   null   string
       Duty   0   decimal
       DutyDescription   null   string
       FirstName   null   string
+       FraudFilters   Count = 0   System.Collections.Generic.IList<string> {System.Collections.Generic.List<string>}
       InvoiceNumber   null   string
       IsRecurring   false   bool
       LastName   null   string
+       LineItems   Count = 0   System.Collections.Generic.IList<AuthorizeNet.LineItem> {System.Collections.Generic.List<AuthorizeNet.LineItem>}
       OrderDescription   null   string
       PONumber   null   string
       RequestedAmount   0   decimal
       ResponseCode   1   int
       ResponseReason   "Approval"   string
       SettleAmount   0.27   decimal
       Shipping   0   decimal
       ShippingAddress   null   AuthorizeNet.Address
       ShippingDescription   null   string
       Status   "settledSuccessfully"   string
       Tax   0   decimal
       TaxDescription   null   string
       TaxExempt   false   bool
       TransactionID   ""   string
       TransactionType   "authCaptureTransaction"   string

Re: Card Number is null in Transaction Detail API for AIM

nihirporecha — Tue, 27 Mar 2012 17:41:32 GMT

Any suggestions, please. I need to process refund on production and am unable to do so.

Re: Card Number is null in Transaction Detail API for AIM

RaynorC1emen7 — Tue, 27 Mar 2012 19:41:08 GMT

Are you using the latest 1.7.1 SDK?

Re: Card Number is null in Transaction Detail API for AIM

nihirporecha — Wed, 28 Mar 2012 05:10:29 GMT

Yes.

Re: Card Number is null in Transaction Detail API for AIM

nihirporecha — Wed, 28 Mar 2012 10:36:30 GMT

Surprising that there is no one else with such problem but me. Can any one help me otherwise I will need to process refund manually?

Re: Card Number is null in Transaction Detail API for AIM

RaynorC1emen7 — Wed, 28 Mar 2012 11:30:44 GMT

It work fine on my test account. I guess you will need to do it manually and see if something special about this transaction.

        AuthorizationAmount    0    decimal
        AuthorizationCode    "E6Y8AH"    string
        AVSCode    "Y"    string
        AVSResponse    "Address (Street) and five digit ZIP match "    string
+        BatchSettledOn    {2/23/2012 12:14:09 AM}    System.DateTime
        BatchSettlementID    "1533049"    string
        BatchSettlementState    "settledSuccessfully"    string
+        BillingAddress    {AuthorizeNet.Address}    AuthorizeNet.Address
        CardExpiration    "XXXX"    string
        CardNumber    "XXXX1111"    string
        CardResponse    ""    string
        CardResponseCode    null    string
        CardType    "Visa"    string
        CAVVCode    null    string
        CAVVResponse    "Blank or not present - CAVV not validated"    string
        CustomerEmail    "email@example.com"    string
        CustomerID    "none"    string
+        DateSubmitted    {2/22/2012 3:43:07 PM}    System.DateTime
        Description    null    string
        Duty    0    decimal
        DutyDescription    null    string
        FirstName    null    string
+        FraudFilters    Count = 0    System.Collections.Generic.IList<string> {System.Collections.Generic.List<string>}
        InvoiceNumber    "none"    string
        IsRecurring    false    bool
        LastName    null    string
+        LineItems    Count = 0    System.Collections.Generic.IList<AuthorizeNet.LineItem> {System.Collections.Generic.List<AuthorizeNet.LineItem>}
        OrderDescription    "Test transaction for ValidateCustomerPaymentProfile."    string
        PONumber    "none"    string
        RequestedAmount    0    decimal
        ResponseCode    1    int
        ResponseReason    "Approval"    string
        SettleAmount    0    decimal
        Shipping    0    decimal
+        ShippingAddress    {AuthorizeNet.Address}    AuthorizeNet.Address
        ShippingDescription    null    string
        Status    "voided"    string
        Tax    0    decimal
        TaxDescription    null    string
        TaxExempt    false    bool
        TransactionID    "2169227166"    string
        TransactionType    "authOnlyTransaction"    string

Re: Card Number is null in Transaction Detail API for AIM

nihirporecha — Wed, 28 Mar 2012 11:49:30 GMT

Hi,

Thanks for the reply. Ok, I am able to get the card number if the transaction is "authonlytransaction"(which is your case). In my case, transaction is "authCaptureTransaction", for which I am not gettting the card information. Is there any particular reason for such behavior?

Re: Card Number is null in Transaction Detail API for AIM

RaynorC1emen7 — Wed, 28 Mar 2012 12:26:01 GMT

It work fine for "authCaptureTransaction". Login to the account and search on the transaction and see it have the info.

		AuthorizationAmount	19.99	decimal
		AuthorizationCode	"6GA9AL"	string
		AVSCode	"Y"	string
		AVSResponse	"Address (Street) and five digit ZIP match "	string
+		BatchSettledOn	{2/11/2012 12:18:58 AM}	System.DateTime
		BatchSettlementID	"1509643"	string
		BatchSettlementState	"settledSuccessfully"	string
+		BillingAddress	{AuthorizeNet.Address}	AuthorizeNet.Address
		CardExpiration	"XXXX"	string
		CardNumber	"XXXX1111"	string
		CardResponse	""	string
		CardResponseCode	null	string
		CardType	"Visa"	string
		CAVVCode	null	string
		CAVVResponse	"Blank or not present - CAVV not validated"	string
		CustomerEmail	null	string
		CustomerID	null	string
+		DateSubmitted	{2/10/2012 12:26:06 PM}	System.DateTime
		Description	null	string
		Duty	0	decimal
		DutyDescription	null	string
		FirstName	null	string
+		FraudFilters	Count = 0	System.Collections.Generic.IList<string> {System.Collections.Generic.List<string>}
		InvoiceNumber	"20120210062540"	string
		IsRecurring	false	bool
		LastName	null	string
+		LineItems	Count = 2	System.Collections.Generic.IList<AuthorizeNet.LineItem> {System.Collections.Generic.List<AuthorizeNet.LineItem>}
		OrderDescription	"Sample Transaction"	string
		PONumber	null	string
		RequestedAmount	0	decimal
		ResponseCode	1	int
		ResponseReason	"Approval"	string
		SettleAmount	19.99	decimal
		Shipping	0	decimal
		ShippingAddress	null	AuthorizeNet.Address
		ShippingDescription	null	string
		Status	"settledSuccessfully"	string
		Tax	0	decimal
		TaxDescription	null	string
		TaxExempt	false	bool
		TransactionID	"2168912660"	string
		TransactionType	"authCaptureTransaction"	string

Re: Card Number is null in Transaction Detail API for AIM

nihirporecha — Wed, 28 Mar 2012 12:59:22 GMT

OK, I downloaded the latest sdk again and referred it to my project and I am able to get credit card information! Thanks for helping me in troubleshooting. Although it is a mystery that why latest version sdk was not referred(although I am referenced to the latest sdk) but all is good now.

Thanks again.