topic Re: retrieving transaction query report from a hosted form in Integration and Testing

retrieving transaction query report from a hosted form

iamreb — Wed, 22 Jun 2016 06:03:54 GMT

I have this hosted form:

$form .= "<FORM method='post' action='$url' id='paymentform'>";
$form .= "<INPUT type='hidden' name='x_login' value='$login' />";
$form .= "<INPUT type='hidden' name='x_amount' value='$amount' />";
$form .= "<INPUT type='hidden' name='x_description' value='$description' />";
$form .= "<INPUT type='hidden' name='x_invoice_num' value='$number' />";
$form .= "<INPUT type='hidden' name='x_fp_sequence' value='$sequence' />";
$form .= "<INPUT type='hidden' name='x_fp_timestamp' value='$timeStamp' />";
$form .= "<INPUT type='hidden' name='x_fp_hash' value='$fingerprint' />";
$form .= "<INPUT type='hidden' name='x_test_request' value='$testMode' />";
$form .= "<INPUT type='hidden' name='x_show_form' value='PAYMENT_FORM' />";
$form .= "<INPUT type='hidden' name='x_currency_code' value='$currency' />";
$form .= "<INPUT type='hidden' name='x_tax' value='$tax' />";
$form .= "<INPUT type='hidden' name='x_relay_response' value='TRUE' />";
$form .= "<INPUT type='hidden' name='x_receipt_link_url' value='$returnurl' />";
$form .= "<INPUT type='hidden' name='x_first_name' value='$first_name' />";
$form .= "<INPUT type='hidden' name='x_last_name' value='$last_name' />";
$form .= "<INPUT type='hidden' name='x_address' value='$address' />";
$form .= "<INPUT type='hidden' name='x_city' value='$city' />";
$form .= "<INPUT type='hidden' name='x_country' value='$country' />";
$form .= "<INPUT type='hidden' name='x_state' value='$state' />";
$form .= "<INPUT type='hidden' name='x_zip' value='$zip' />";
$form .= "<INPUT type='hidden' name='x_phone' value='$phone' />";
$form .= "<INPUT type='hidden' name='x_fax' value='$fax' />";
$form .= "<INPUT type='hidden' name='x_email' value='$email' />";

My question then is how do I get the transaction response from authorize.net when the form is redirected to:

https://test.authorize.net/gateway/transact.dll

also I cant use silent post since I am using local

Re: retrieving transaction query report from a hosted form

RaynorC1emen7 — Wed, 22 Jun 2016 11:40:17 GMT

For relay response read

https://developer.authorize.net/support/faqs/

and

https://community.developer.authorize.net/t5/The-Authorize-Net-Developer-Blog/Relay-Response-Basics-and-Troubleshooting/ba-p/9536

and the SIM doc here

http://developer.authorize.net/api/upgrade_guide/

But it need a public address, can't be local

Re: retrieving transaction query report from a hosted form

iamreb — Wed, 22 Jun 2016 12:19:55 GMT

@RaynorC1emen7 which of these can work for local? thank you

Re: retrieving transaction query report from a hosted form

RaynorC1emen7 — Wed, 22 Jun 2016 12:48:27 GMT

None. Relay response can't be send to a local page, have to be a public accessiable site as said in

https://community.developer.authorize.net/t5/The-Authorize-Net-Developer-Blog/Relay-Response-Basics-and-Troubleshooting/ba-p/9536

If the merchant’s Web server is not available on the public Internet, has authentication enabled, or if the Relay URL uses a non-standard port for HTTP or HTTPS traffic, Relay Response timeouts will occur. Authorize.Net will not have any means to connect to your server or authenticate itself on your server, and can only use ports 80 and 443 for all Web traffic.

Re: retrieving transaction query report from a hosted form

iamreb — Wed, 22 Jun 2016 12:59:06 GMT

@RaynorC1emen7 do you have any suggestions that would be applicable to my need? thank you once again

Re: retrieving transaction query report from a hosted form

Lilith — Wed, 22 Jun 2016 17:20:26 GMT

@iamreb If you're using the Hosted Payment Form with Relay Response, you'd need to set x_relay_url to a public URL. It doesn't have to be a URL that's linked to your site, but it does need to be available for us to connect to. That URL can be associated with a script to write the Relay Response data to your local file.

You could, in theory, use the Authorize.Net API's transaction reporting functions to pull your transactions and store that in a local file as well. That won't tell you which transactions came from the Hosted Payment Form, but you could check details like invoice numbers to find matches, if you need.

Re: retrieving transaction query report from a hosted form

iamreb — Thu, 23 Jun 2016 05:11:39 GMT

@Lilith so there's no way for me to get the transaction response for that specific payment if I am running it on local, and the other alternative would be to select all the transaction per batch and find it there. Will you help me find the appropriate documentation for retrieving those records? and are those records updated instantaneously after each transaction? Thank you

Re: retrieving transaction query report from a hosted form

RaynorC1emen7 — Thu, 23 Jun 2016 11:51:34 GMT

It under transaction reporting

here is the api reference

https://developer.authorize.net/api/reference/#transaction-reporting

and the doc

https://developer.authorize.net/api/reference/features/transaction_reporting.html

or just login to the merchant account and look for the last transaction

Re: retrieving transaction query report from a hosted form

iamreb — Fri, 24 Jun 2016 12:14:33 GMT

@Lilith, @RaynorC1emen7 I created a live URL for the relay response but it just said that it timed out. I then tried using silent post as instructed here to fetch the transaction details of that transaction but it still got nothing from it. My URL is structured like this http://dev2.something.com/somewhere/returns/

Will this cause any problem for the silent post? Also to reiterate my main goal here is to get the information returned by authorize.net after the transaction is process i.e card status, customer id, invoice #, etc. basically everything that is stated here.

Would this be possible with silent form and with my current hosted form?

Thank you

Re: retrieving transaction query report from a hosted form

RaynorC1emen7 — Fri, 24 Jun 2016 12:55:47 GMT

silent post is just like relay response, if relay response doesn't work, silent post would not work either

Did you read the https://community.developer.authorize.net/t5/The-Authorize-Net-Developer-Blog/Relay-Response-Basics-and-Troubleshooting/ba-p/9536 ?

Re: retrieving transaction query report from a hosted form

iamreb — Mon, 27 Jun 2016 06:49:11 GMT

@RaynorC1emen7 yes I already read that but my relay response always returns the time-out error. Do I need to enable Default Receipt URL if I want to use the relay response? and can relay response be used for a hosted form?

This is really troubling me. thank you once again

Re: retrieving transaction query report from a hosted form

RaynorC1emen7 — Mon, 27 Jun 2016 12:05:53 GMT

tried your relay url

http://crmdev2.test.com/suitecrm/returns/index.php

did redirect back to https://www.test.com doesn't look like is a valid url

Re: retrieving transaction query report from a hosted form

Lilith — Mon, 27 Jun 2016 15:18:51 GMT

@iamreb You really should be using your domain for this. Otherwise you're going to continue to get Relay Response timeouts, and none of the Relay Response data.

We're trying to send an HTTP POST to your URL, so we can provide the data and copy the HTML output it generates, so it's crucial that you use a URL that's valid on your domain.

Re: retrieving transaction query report from a hosted form

iamreb — Tue, 28 Jun 2016 06:30:23 GMT

@Lilith@RaynorC1emen7 thanks for your advice and help everyone, the problem was that authorize was not whitelisted in our server. After adding it to the list everything now works perfectly