topic Re: getting duplicate transactions in getTransactionList in Integration and Testing

getting duplicate transactions in getTransactionList

AndyOlson — Thu, 01 Jun 2017 20:01:34 GMT

After the https://community.developer.authorize.net/t5/The-Authorize-Net-Developer-Blog/Enhanced-Customer-Profile-Reporting-New-Webhooks-UI/ba-p/57375 announcement that added the CIM profile id's to the getTransactionList, we're now noticing transaction nodes getting duplicated. One of the transaction nodes will include the "profile" node with the CIM data and the other transaction will be missing that node.. Othere than that, they are duplicates, and I'm assuming that's not an intentional change.. Is it?

Re: getting duplicate transactions in getTransactionList

Aaron — Fri, 02 Jun 2017 20:14:30 GMT

Hi @AndyOlson,

Same transaction ID in both nodes?

Re: getting duplicate transactions in getTransactionList

AndyOlson — Fri, 02 Jun 2017 20:27:01 GMT

yes. Same transaction record. The only difference between the two is one has the profile node and the other doesn't

Re: getting duplicate transactions in getTransactionList

Aaron — Fri, 02 Jun 2017 20:56:47 GMT

Great. I don't have settled profile transactions in my sandbox account to look at right now, but I'll try some testing on my end and wait for the transactions to settle.

In the meantime, is every transaction node that's associated with a profile duplicated (without profile info in the duplicate), or just some of them?

Re: getting duplicate transactions in getTransactionList

AndyOlson — Mon, 05 Jun 2017 14:25:13 GMT

Not all are duplicated... out of 151 from yesterday, 103 had duplicate transaction nodes (one with a profile node, one without). All 48 of the transactions that showed up only once had a profile node.

I'm looking to see if I can find something about the rows that signifies them as different, but haven't seen a pattern yet.

Re: getting duplicate transactions in getTransactionList

AndyOlson — Mon, 05 Jun 2017 14:51:53 GMT

Just found a couple of patterns... It appears to be tied around if the transaction flowed through an Authorize then Capture or AuthorizeCapture in one step flow. Here's how I got there..

All voids and declines have only 1 node per transactionID (theoretically the authorize step)
All transactions that were run using AuthorizeAndCapture have only one node per transaction
All orders submitted first as an Authorize, then later run as a PriorAuthCapture are duplicated

Hope that helps narrow it down

Re: getting duplicate transactions in getTransactionList

Aaron — Mon, 05 Jun 2017 20:59:12 GMT

Hi @AndyOlson,

That's very useful information, thanks! There's two things going on here:

When authorization and capture happen separately, there are two entries in getTransactionListResponse. That may be by design, but I'll double-check to be sure.
When the two steps are reported separately, the profile info is not included for both. I suspect this may also be "working as designed". It's possible that since the capture step is just another operation on an existing transaction, we felt that it wasn't appropriate to include the profile info. However, since we're reporting it as a separate node, it's confusing not to.

I'll run this around the company to see if I can get a handle on whether or not this is working as designed. If not, we'll look to fix it. If so, we can talk about changes to make it less confusing, or at least better explanations in the documentation.

Thanks for following up on this!

Re: getting duplicate transactions in getTransactionList

AndyOlson — Mon, 05 Jun 2017 21:25:25 GMT

You *might* be able to convince me that it was intended to have tow listed, but then I would additionally expect to see a different state or something else aside from just the appearance or lack of appearance of the profileID.

In addition, duplication of any form before the addition of the profileID did not happen, so I would certainly call it a braking change either way as the current behavior was only ever returnig one node per transaction.

Love to hear what you find

Re: getting duplicate transactions in getTransactionList

AndyOlson — Thu, 08 Jun 2017 14:36:42 GMT

Hey @Aaron,

Is there any update on this? My accounting department is asking why the reconciliations aren't lining up and I'd like to know if there is a way forward on this one.

Thanks

Re: getting duplicate transactions in getTransactionList

AndyOlson — Mon, 12 Jun 2017 14:06:38 GMT

@Aaron,

Should I be submitting this somewhere else?

Re: getting duplicate transactions in getTransactionList

AndyOlson — Wed, 05 Jul 2017 14:39:06 GMT

@Aaron It's now been over a month since this has been submitted both in this forum and via a ticket. Is there any update on the status of this?

Re: getting duplicate transactions in getTransactionList

Aaron — Wed, 05 Jul 2017 19:29:37 GMT

My sincere apologies, but I have nothing yet on this.

Re: getting duplicate transactions in getTransactionList

AndyOlson — Wed, 02 Aug 2017 22:16:33 GMT

going on 2 months now... any update?

Re: getting duplicate transactions in getTransactionList

Aaron — Thu, 03 Aug 2017 17:52:30 GMT

Nothing, sorry.

Re: getting duplicate transactions in getTransactionList

mfaucher — Mon, 21 May 2018 00:20:02 GMT

Same issue here. Get duplicated settled transactions with API, one transaction with Customer Profile and a second transaction without the profile data. All other field are the same and there is no field to filter out duplicates. We are using most of the time a pre-authorization, but not in all cases.

Is there a plan for resolution of this issue ?

Thank you

Re: getting duplicate transactions in getTransactionList

dogo365 — Sat, 26 May 2018 08:39:12 GMT

Is there a plan for resolution of this issue ?