First of all, make sure if API access passcode under “administration -> account settings -> order settings” is generated and obtainable.<\/p>\n
Payment reports are retrieved by transaction dates. So, it should be cross checked with local DB transaction data in order to get one transaction information\u00a0 out of order number, customer’s name or other information after retrieving in date ranges.<\/p>\n
Bambora’s Payment APIs are the RESTful interface to the payment gateway. cURL is used to get payment report on PHP as below.<\/p>\n
[code language=”PHP”]<\/p>\n
$BAM_API_PASSCODE = "Authorization: Passcode "."your Bambora passcode"
\n$reportURL = "https:\/\/api.na.bambora.com\/v1\/reports";
\n$from_date = date("Y-m-d", strtotime("-1 days"));
\n$to_date = date("Y-m-d", strtotime("+1 days"));<\/p>\n
$crl = curl_init();<\/p>\n
$postData = array(
\n"name" => "Search",
\n"start_date" => $from_date."T00:00:00",
\n"end_date" => $to_date."T23:59:59",
\n"start_row" => "1",
\n"end_row" => "1000"
\n);<\/p>\n
$postData = json_encode($postData);<\/p>\n
$header = array();
\n$header[] = ‘Content-length: ‘.strlen($postData);
\n$header[] = ‘Content-type: application\/json’;
\n$header[] = $BAM_API_PASSCODE;<\/p>\n
curl_setopt($crl, CURLOPT_HTTPHEADER,$header);
\ncurl_setopt($crl, CURLOPT_URL, $reportURL);
\ncurl_setopt($crl, CURLOPT_RETURNTRANSFER, true);
\ncurl_setopt($crl, CURLOPT_POST,true);
\ncurl_setopt($crl, CURLOPT_POSTFIELDS, $postData);<\/p>\n
$output = curl_exec($crl);
\ncurl_close($crl);<\/p>\n
$output = json_decode($output, true);
\n$trns = $output[‘records’];<\/p>\n
foreach( $trns as $trn){
\necho print_r($trn)."<br \/><br \/>";
\n}<\/p>\n
[\/code]<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
First of all, make sure if API access passcode under “administration -> account settings -> order settings” is generated and obtainable. Payment reports are retrieved by transaction dates. So, it should be cross checked with local DB transaction data in order to get one transaction information\u00a0 out of order number, customer’s name or other information […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-217","post","type-post","status-publish","format-standard","hentry","category-it-tips"],"_links":{"self":[{"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/posts\/217","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/comments?post=217"}],"version-history":[{"count":0,"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/posts\/217\/revisions"}],"wp:attachment":[{"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/media?parent=217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/categories?post=217"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/waterloobae.com\/blog\/wp-json\/wp\/v2\/tags?post=217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}