topic Re: Oddball Integration Question in Integration and Testing

Oddball Integration Question

Aaron_at_Gasp — Thu, 06 Oct 2011 16:19:08 GMT

Hey Folks;

Just trying to get a ball rolling here on integration, I've worked with the API for a bit but I'm currently looking for a way to download a batch of transactions into a text or csv file to integrate with a back-end server.

I was told that the API can do this but I'm at a loss as to how to go about it, any clues?

Aaron

Re: Oddball Integration Question

jdallen88 — Thu, 06 Oct 2011 17:54:51 GMT

Is this something you're trying to implement on your website?

If not, you can sign into your account (https://sandbox.authorize.net/) and transactions to a text file (tab delimited, comma separated). Just sign in click on reports at the top and run a report for a particular day and click on the download to file button in the top right of the table. I'm kind of new as well so I'm not sure if there's a way to download everything or if it's only possible to download daily reports.

Re: Oddball Integration Question

Aaron_at_Gasp — Thu, 06 Oct 2011 20:18:39 GMT

Not quite... It needs to be an automated script that runs every evening to put data back to our local server for our production systems and accounting calculations.

In other words, no I can't just use the web interface because it's a waste of my time when a program can do the job without any added input because it's just downloading the data to a file that the local server then automatically picks up and applies to it's own internal database.

Re: Oddball Integration Question

RaynorC1emen7 — Thu, 06 Oct 2011 23:11:35 GMT

Take a look at Transaction Details API.

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

Re: Oddball Integration Question

Aaron_at_Gasp — Fri, 07 Oct 2011 19:37:07 GMT

Ok, so I've managed to fandangle a way to get the data we need with one little, itty-bitty, miniscule hitch...

I'm trying to pull the data using getTransactionsForDay; however, there's no bloody documentation (that I've seen) on the XML structure or accessing data from other data draw types other than Batch...

I'm thinking it's something like this:

$response = $request->getTransactionsForDay($month, $day, $year); var_dump(simpleXMLToArray($response->xml->transaction->transactionStatus));

Obviously that's wrong because I'm not getting XML data...

(Just a heads up, that XML to Array function works correctly, tested with the batch program but it's only being used to generate output to the screen using var_dump)

Another point is that this software is running through a CLI so I don't have the usual tools (aka Firebug) to tell me what kind of return my server call is getting.

Re: Oddball Integration Question

RaynorC1emen7 — Fri, 07 Oct 2011 19:47:57 GMT

I think the getTransactionsForDay is a merge of getSettledBatchListRequest and getTransactionListRequest, so it return a list of transactions

So it probably be $response->xml->transactions->transaction->transactionStatus

Re: Oddball Integration Question

Aaron_at_Gasp — Fri, 07 Oct 2011 20:02:06 GMT

Unfortunately no, that doesn't work, nor does removing the 'transactionStatus' at the end to see if maybe it just refers to them as 'transaction'.

I'm a little surprised at the lack of documentation but I guess this API isn't as often used as others are...

Additionally, to add to the potential screwyness, I had to edit the AuthorizeNetTD.php and change the core checks for sandbox mode to be false to force it to realize I wanted it to check the production side, rather than the sandbox side (which was giving me all kinds of errors.)

Re: Oddball Integration Question

Aaron_at_Gasp — Wed, 12 Oct 2011 17:24:32 GMT

Alright, figured it out, shockingly enough, it's just $response in this case, no burrowing like the others seem to require...

So now I have the program tossed together, though I still think it's silly that I had to change more than just a variable to switch it between sandbox and production mode...