Reporting API
The Reporting API is a simple way to download common reports normally retrieved via the 360-One website.
Contents
The API interface is a simple POST message, therefore implementation language is up to the developer.
Introduction
The 360-One platform provides a wide variety of reports to assist in reconciliation of card and ACH transactions. An API servlet is available for those users that prefer to download the data into their own system in CSV or XML format.
Certification
Special certification is not required, however a valid username and password are necessary for authentication. A Certification Manager is available to answer any questions related to integration.
Technical Overview
While there are many reports available through the API, the most common are detailed below.
Example Batch Summary request
The batch summary is a report detailing all the transactions recieved by POS devices, the Payment Gateway, and other products.
- POST /jsp/reports/report_api.jsp HTTP/1.1
Content–Type: application/x–www–form–urlencoded
Cache–Control: no–cache
Pragma: no–cache
User–Agent: Java/1.7.0_21
Host: test.merchante–solutions.com
Accept: text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2
Connection: keep-alive
Content-Length: xxxuserId=pjones&userPass=xxxxxx&reportDateBegin=03%2F01%2F2014&reportDateEnd=03%2F09%2F2014&nodeId=9410000xxxxx&reportType=1&includeTridentTranId=true&includePurchaseId=true&includeClientRefNum=true&xmlEncoding=0&dsReportId=1
Example Batch Summary response
The two results here are in XML due to the xmlEncoding parameter in the request.
- <?xml version=“1.0” encoding=“UTF-8” ?>
<Report>
<ReportRow>
<ReportColumn name=“Merchant Id” value=“9410000xxxxx”/>
<ReportColumn name=“DBA Name” value=“TEST ACCOUNT”/>
<ReportColumn name=“Term Num” value=“86”/>
<ReportColumn name=“Batch Num” value=“1”/>
<ReportColumn name=“Batch Date” value=“03/03/2014”/>
<ReportColumn name=“Tran Date” value=“03/03/2014”/>
<ReportColumn name=“Card Type” value=“VS”/>
<ReportColumn name=“Card Number” value=“401288xxxxxx8882”/>
<ReportColumn name=“Reference” value=“562599660”/>
<ReportColumn name=“Purchase Id” value=“”/>
<ReportColumn name=“Auth Code” value=“04320A”/>
<ReportColumn name=“Entry Mode” value=“SWIPED CVV”/>
<ReportColumn name=“Tran Amount” value=“0.25”/>
<ReportColumn name=“Trident Tran Id” value=“dg52b30c76d13158bfe69b52eea0ae0a”/>
<ReportColumn name=“Client Ref Num” value=“”/>
</ReportRow>
<ReportRow>
<ReportColumn name=“Merchant Id” value=“9410000xxxxx”/>
<ReportColumn name=“DBA Name” value=“TEST ACCOUNT”/>
<ReportColumn name=“Term Num” value=“28”/>
<ReportColumn name=“Batch Num” value=“114”/>
<ReportColumn name=“Batch Date” value=“03/04/2014”/>
<ReportColumn name=“Tran Date” value=“03/04/2014”/>
<ReportColumn name=“Card Type” value=“VS”/>
<ReportColumn name=“Card Number” value=“401288xxxxxx8882”/>
<ReportColumn name=“Reference” value=“562944462”/>
<ReportColumn name=“Purchase Id” value=“123”/>
<ReportColumn name=“Auth Code” value=“066762”/>
<ReportColumn name=“Entry Mode” value=“KEYED”/>
<ReportColumn name=“Tran Amount” value=“0.01”/>
<ReportColumn name=“Trident Tran Id” value=“55ac1a744be338dfad8f8f35169737a7”/>
<ReportColumn name=“Client Ref Num” value=“”/>
</ReportRow>
</Report>
Example Deposit Summary request
The deposit summary is a report listing out all the interactions with a merchant’s bank account. This includes merchant deposits, as well as debits (typically for fees, or chargebacks).
- POST /jsp/reports/report_api.jsp HTTP/1.1
Content–Type: application/x–www–form–urlencoded
Cache–Control: no–cache
Pragma: no–cache
User–Agent: Java/1.7.0_21
Host: test.merchante–solutions.com
Accept: text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2
Connection: keep-alive
Content-Length: xxxuserId=pjones&userPass=xxxxxx&reportDateBegin=03%2F01%2F2014&reportDateEnd=03%2F09%2F2014&nodeId=9410000xxxxx&reportType=1&xmlEncoding=0&dsReportId=3
Example Deposit Summary response
The three results here are in XML due to the xmlEncoding parameter in the request.
- <?xml version=“1.0” encoding=“UTF-8” ?>
<Report>
<ReportRow>
<ReportColumn name=“Org Id” value=“9410000xxxxx”/>
<ReportColumn name=“Org Name” value=“TEST ACCOUNT”/>
<ReportColumn name=“Date” value=“03/02/2014”/>
<ReportColumn name=“Type” value=“DEBIT”/>
<ReportColumn name=“Amount” value=“-5.67”/>
<ReportColumn name=“Reference” value=“61100609354034”/>
</ReportRow>
<ReportRow>
<ReportColumn name=“Org Id” value=“9410000xxxxx”/>
<ReportColumn name=“Org Name” value=“TEST ACCOUNT”/>
<ReportColumn name=“Date” value=“03/05/2014”/>
<ReportColumn name=“Type” value=“CREDIT”/>
<ReportColumn name=“Amount” value=“0.01”/>
<ReportColumn name=“Reference” value=“61100609409645”/>
</ReportRow>
<ReportRow>
<ReportColumn name=“Org Id” value=“9410000xxxxx”/>
<ReportColumn name=“Org Name” value=“TEST ACCOUNT”/>
<ReportColumn name=“Date” value=“03/05/2014”/>
<ReportColumn name=“Type” value=“CREDIT”/>
<ReportColumn name=“Amount” value=“0.25”/>
<ReportColumn name=“Reference” value=“61100609409644”/>
</ReportRow>
</Report>
Example Chargeback Adjustments request
The chargeback adjustment report is a listing of all the chargeback activity on merchant’s account.
- POST /jsp/reports/report_api.jsp HTTP/1.1
Content–Type: application/x–www–form–urlencoded
Cache–Control: no–cache
Pragma: no–cache
User–Agent: Java/1.7.0_21
Host: test.merchante–solutions.com
Accept: text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2
Connection: keep-alive
Content-Length: xxxuserId=pjones&userPass=xxxxxx&reportDateBegin=03%2F01%2F2014&reportDateEnd=03%2F09%2F2014&nodeId=9410000xxxxx&reportType=1&includeTridentTranId=true&includePurchaseId=true&includeClientRefNum=true&xmlEncoding=0&dsReportId=5
Example Chargeback Adjustments response
The result here is in XML due to the xmlEncoding parameter in the request.
- <?xml version=“1.0” encoding=“UTF-8” ?>
<Report>
<ReportRow>
<ReportColumn name=“Merchant Id” value=“9410000xxxxx”/>
<ReportColumn name=“DBA Name” value=“TEST ACCOUNT “/>
<ReportColumn name=“Control Number” value=“3208057”/>
<ReportColumn name=“Incoming Date” value=“03/26/2014”/>
<ReportColumn name=“Card Number” value=“401288xxxxxx8882”/>
<ReportColumn name=“Reference Number” value=“74332393326005359000535”/>
<ReportColumn name=“Tran Date” value=“11/21/2013”/>
<ReportColumn name=“Tran Amount” value=“-6.0”/>
<ReportColumn name=“Trident Tran ID” value=“55ac1a744be338dfad8f8f35169737a7”/>
<ReportColumn name=“Purchase ID” value=“Invoice123456”/>
<ReportColumn name=“Client Ref Num” value=“Custom Data”/>
<ReportColumn name=“Auth Code” value=“T12345”/>
<ReportColumn name=“Adj Date” value=“04/06/2014-“/>
<ReportColumn name=“Adj Ref Num” value=“00535900053”/>
<ReportColumn name=“Reason” value=“Non-Matching Account Number”/>
<ReportColumn name=“First Time” value=“Y”/>
<ReportColumn name=“Reason Code” value=“77”/>
<ReportColumn name=“CB Ref Num” value=“0”/>
<ReportColumn name=“Terminal ID” value=“”/>
</ReportRow>
</Report>
