getBillPayHistory()
Get a record set of customer billpayment transaction history.
Parameters
Parameter Required Data type Pattern Notes
transactionId Yes String

60 characters or less

9845dk-39fdk3fj3-4483483478

A unique system generated ID number that identifies the API transaction with Galileo Processing systems. A UUID is preferred. This must be different for each transaction.
accountNo Yes String

PAN or PRN

074103447228

Can be either a PAN (the 16 digit card number) or PRN (a unique 12 digit account identifier).
startDate Yes Date

YYYY-MM-DD

2016-01-01

The beginning date for the date range.
endDate Yes Date

YYYY-MM-DD

2016-02-01

The end date for the date range; must be greater than or equal to the startDate.
includeRelated No

Boolean

0 or 1

0

Default is true; 0=false, 1=true
recordCnt No Integer Positive integer value in the range of 1 and 99999. 100 The maximum number of records to be returned in the method response.
Status Codes
Status Code description
0 Success
2 Invalid parameter(s)
12 Invalid customer account.
-1 Indicates that the application record failed to update or return.
Response
<?xml version="1.0" encoding="UTF-8"?>
<response>
   <status_code>0</status_code>
   <status>Success</status>
   <system_timestamp>2017-06-12 15:22:06</system_timestamp>
   <response_data>
     <found>2</found>
     <bill_payments>
       <bill_payment>
         <pmt_ref_no>155200002741</pmt_ref_no>
         <billpay_transaction_id>566303</billpay_transaction_id>
         <amount>30</amount>
         <process_date>2014-11-28 00:00:00</process_date>
         <biller_id>226555</biller_id>
         <name>Rocky Mountain Power</name>
         <nickname>Rocky Mountain Power</nickname>
         <status>C</status>
         <type>P</type>
         <external_trans_id/>
         <printed_date>2017-06-07 11:32:55</printed_date>
         <cleared_date>2017-06-12 15:18:01</cleared_date>
       </bill_payment>
       <bill_payment>
         <pmt_ref_no>155200002741</pmt_ref_no>
         <billpay_transaction_id>566302</billpay_transaction_id>
         <amount>47.02</amount>
         <process_date>2014-11-28 00:00:00</process_date>
         <biller_id>226556</biller_id>
         <name>Questar Gas</name>
         <nickname>Questar Gas</nickname>
         <status>P</status>
         <type>E</type>
         <external_trans_id/>
         <printed_date/>
         <cleared_date/>
       </bill_payment>
     </bill_payments>
   </response_data>
   <processing_time>0.713</processing_time>
   <echo>
     <transaction_id>673970366</transaction_id>
     <provider_transaction_id>GAAP test</provider_transaction_id>
     <provider_timestamp>2017-06-12 15:18:30</provider_timestamp>
   </echo>
</response>
 
Response Description Example value
status The condition of a process or response (such as embossed card, account, freeze, and so on). Success
status_code The status of the response. 0
system_timestamp A system generated timestamp. 2011-02-02 11:11:12
response_data A structure for the response data. It can be empty but usually will contain information. <response_data>
   <new_account>   </new_account>
</response_data>
found In getBillPayHistory(), the total number of bill payments found. 2
bill_payments A data structure that contains information on one or more bill payments. <bill_payment>
  x
</bill_payment>
bill_payment A data structure that displays information on a bill payment. <bill_payment>
  <pmt_ref_no>155200002741</pmt_ref_no>
  <billpay_transaction_id>566303</billpay_transaction_id>
  <amount>30</amount>
  <process_date>2014-11-28 00:00:00</process_date>
  <biller_id>226555</biller_id>
  <name>Rocky Mountain Power</name>
  <nickname>Rocky Mountain Power</nickname>
  <status>C</status>
  <type>P</type>
  <external_trans_id/>
  <printed_date>2017-06-07 11:32:55</printed_date>
  <cleared_date>2017-06-12 15:18:01</cleared_date>
</bill_payment>
pmt_ref_no A Galileo generated account number. 155200002741
billpay_transaction_id An ID assigned to a bill payment transaction. 566303
amount An amount on a transaction or authorization. 30
process_date The date the payment was processed. 2018-11-28 00:00:00
biller_id Positive integer value of a customer configured biller. Biller IDs are retrieved using the getBillers() method. 226555
name In getBillPayHistory(), the name of the biller. Rocky Mountain Power
nickname A nickname used to identify a biller entity. Rocky Mountain Power
status In getBillPayHistory(), the status of the payment. C
type In getBillPayHistory(), the type of biller entity. P
external_trans_id Non-Galileo id number for a transaction. 483494-4443-455454
printed_date The date the bill payment was sent. 2018-06-07 11:32:55
cleared_date The date the bill payment cleared the bank. 2017-06-12 15:18:01
processing_time The time elapsed in processing the transaction. 1.723
echo A structure that displays transaction ID information. <echo>
  <transaction_id>...</transaction_id>
  <provider_transaction_id>...</provider_transaction_id>
  <provider_timestamp>...</provider_timestamp>
</echo>
transaction_id A number that represents a transaction. 12345a
provider_transaction_id Secondary transaction identifier (generated by a provider). 77bb
provider_timestamp Store a related timestamp for reporting and troubleshooting purposes. 2013-02-06 10:10:10
Code Snippet
                    # The following shell script will use cURL to call getBillPayHistory
# and return the json response.

curl -d '{"transactionId":"45k-dk3fj3-44478", "accountNo":"074103447228", "startDate":"2016-01-01", "endDate":"2016-02-01"}' \ 
-H "response-content-type: json" \ 
-H "Authorization: Bearer **your-access-token**" \ 
-X POST https://sandbox.galileo-ft.com/intserv/4.0/getBillPayHistory
                
                    // The following Java code will make a getBillPayHistory call
// and print the json response.

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.io.Reader;
import java.net.HttpURLConnection;
import java.net.MalformedURLException;
import java.net.URL;
import java.net.URLEncoder;
import java.util. *;

class GalileoAPICall
{
    public static void main(String[] args) {
        try {
            Map<String,Object> params = new LinkedHashMap<>();
           params.put("transactionId", "45k-dk3fj3-44478");
           params.put("accountNo", "074103447228");
           params.put("startDate", "2016-01-01");
           params.put("endDate", "2016-02-01");
            StringBuilder postData = new StringBuilder();
            for (Map.Entry<String,Object> param : params.entrySet()) {
                if (postData.length() != 0) postData.append('&');
                postData.append(URLEncoder.encode(param.getKey(), "UTF-8"));
                postData.append('=');
                postData.append(URLEncoder.encode(String.valueOf(param.getValue()), "UTF-8"));
            }
            byte[] postDataBytes = postData.toString().getBytes("UTF-8");

            URL url = new URL("https://sandbox.galileo-ft.com/intserv/4.0/getBillPayHistory");

            HttpURLConnection conn = (HttpURLConnection) url.openConnection();
            conn.setRequestMethod("POST");
            conn.setRequestProperty("response-content-type", "json");
            conn.setRequestProperty("Authorization", "Bearer **your-access-token");
            conn.setRequestProperty("Content-Length", String.valueOf(postDataBytes.length));
            conn.setDoOutput(true);
            conn.getOutputStream().write(postDataBytes);

            String xmlOutput;

            Reader in = new BufferedReader(new InputStreamReader(conn.getInputStream(), "UTF-8"));
            for (int c; (c = in.read()) >= 0;) {
                System.out.print((char)c);
            }
        } catch (MalformedURLException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}
                
                    # The following Python code will call getBillPayHistory
# and print the json response.

import requests
headers = {'response-content-type': 'json', 'Authorization': 'Bearer {}'.format(**your-access-token**)}
payload = {'transactionId': '45k-dk3fj3-44478', 'accountNo': '074103447228', 'startDate': '2016-01-01', 'endDate': '2016-02-01'}
r = requests.post(url='https://sandbox.galileo-ft.com/intserv/4.0/getBillPayHistory', data=payload, headers=headers)
try:
    print(r.json())
except:
    print(r.status_code)
                
                    // The following PHP code will make a getBillPayHistory call
// and prints the json response.

$endpoint = 'https://sandbox.galileo-ft.com/intserv/4.0/getBillPayHistory';
$params = array('transactionId'=>'45k-dk3fj3-44478', 'accountNo'=>'074103447228', 'startDate'=>'2016-01-01', 'endDate'=>'2016-02-01');

$curl = curl_init();
curl_setopt($curl, CURLOPT_POST, 1);
curl_setopt($curl, CURLOPT_POSTFIELDS, $params);
curl_setopt($curl, CURLOPT_URL, $endpoint);
curl_setopt($curl, CURLOPT_HTTPHEADER, array(
    'response-content-type: json',
    'Authorization: Bearer **your-access-token**'
));
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);

$result = curl_exec($curl);
curl_close($curl);
$json = new json_decode($result, true);
print_r($json);

                
                    // The following C# code will make a getBillPayHistory call
// and print the json response.

using System;using System.IO;
using System.Net;
using System.Text;

byte[] data = Encoding.ASCII.GetBytes(
    "transactionId=45k-dk3fj3-44478&accountNo=074103447228&startDate=2016-01-01&endDate=2016-02-01");
WebRequest request = WebRequest.Create("https://sandbox.galileo-ft.com/intserv/4.0/getBillPayHistory");
request.Method = "POST"\;
request.ContentLength = data.Length;
request.Headers.Add("response-content-type", "json");
request.Headers.Add("Authorization","Bearer **your-access-token**");
using (Stream stream = request.GetRequestStream())
{
    stream.Write(data, 0, data.Length);
}
string responseContent = null;
using (WebResponse response = request.GetResponse())
{
    using (Stream stream = response.GetResponseStream())
    {
        using (StreamReader sr = new StreamReader(stream))
        {
            responseContent = sr.ReadToEnd();
        }
    }
}
Console.WriteLine(responseContent);
                
                    # The following Ruby code will make a getBillPayHistory call
# and print the json response.

require 'uri'
require 'net/http'

uri = URI("https://sandbox.galileo-ft.com/intserv/4.0/getBillPayHistory")
https = Net::HTTP.new(uri.host, uri.port)
https.use_ssl = true
request = Net::HTTP::Post.new(uri.path)
request['response-content-type'] = 'json'
request['Authorization'] = 'Bearer **your-access-token**'
request.body = {transactionId: '45k-dk3fj3-44478', accountNo: '074103447228', startDate: '2016-01-01', endDate: '2016-02-01'}.to_json
response = https.request(request)
puts response