Support

Home Forums Event Espresso Premium Getting the Authorize.net SIM Payment ID

Getting the Authorize.net SIM Payment ID

Posted: March 20, 2017 at 3:40 am


Jeff Long

March 20, 2017 at 3:40 am

Greetings,

We’re using Authorize.net SIM Payment method.

We would like to be able to get the Authorize.net transaction ID for payments from the wp_esp_transaction table. The IDs are encoded however. It looks like, using MD5 encryption.

What would be a path to take to decode those values?

I attempted to trace the returned value from line 116 on txn_admin_details_main_meta_box_txn_details.template.php back to a decoding-function, but did not find a piece of code that appeared to be related to my goal.

My ideal would be to access the data using $wpdb, unserialize, and decode.


Tony

  • Support Staff

March 20, 2017 at 11:39 am

Hi Jeff,

The reason you can’t find any functions to decode the ID is its not encoded by EE. The Authorize.net transaction ID is the x_trans_ID sent by Auth.net themselves and I’m fairly certain is saved as is, so that value IS the transaction ID.

I can’t see any further processing happening on that value before its saved but I have requested some feedback from one of our developers to confirm.

However, I’d just like to clarify:

We would like to be able to get the Authorize.net transaction ID for payments from the wp_esp_transaction table. The IDs are encoded however. It looks like, using MD5 encryption.

There are no payments within esp_transaction, those are all transactions which link to a payment using the ID. I’m guessing that’s what you meant but want to make sure we are on the same page.

Can you let me know what it is your trying to do? There may be an easier way to pull the data you need using our models.

So although you can pull the x_trans_id use wpdb directly, is there a reason you are not using our models to pull the payments for each transaction?

The support post ‘Getting the Authorize.net SIM Payment ID’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso