Search

Transaction Log Report

Description

Returns records from transaction log for a company or aggregator within the provided date range or return date.

Report Parameters

Report Name: TransactionLog

Name	Type	Max. Length	Required	Description
CoNo	string	10	Yes	Company Number
DateProcessStart	DateTime	10	Depends	Date Processed Start time in DateTime, for instance, 2017-01-01
DateProcessEnd	DateTime	10	Depends	Date Processed End time in DateTime, for instance, 2017-01-01
EEDStart	DateTime	10	Depends	Effective Entry Date Start time in DateTime, for instance, 2017-01-01
EEDEnd	DateTime	10	Depends	Effective Entry Date End time in DateTime, for instance, 2017-01-01
ReturnDateStart	DateTime	10	Depends	Return Date Start time in DateTime, for instance, 2017-01-01
ReturnDateEnd	DateTime	10	Depends	Return Date End time in DateTime, for instance, 2017-01-01
TransactionId	Integer
ReferenceNo	String	40		Transaction Log Reference Number
CustRefNo	String	80		Transaction Log Customer Reference Number
DeviceId	String	128		The Device Id to filter on
Incremental	Boolean			Is an incremental download for transactions

At least one of the DateTime type parameters are required. If specifying a date range, the difference between start and end dates cannot be more than 15 days.

Example Request

/EpnAPI/ActiveReports/GetReport.aspx?Token={YourToken}&Action=Report&OutputType=XML&ReportPermDesc=TransactionLog&Parameter_CoNo={CoNo}&Parameter_DateProcessStart=2024-01-01

SDK Example

string token = Token.GetToken("{MerchantNumber}", "{MerchantPassword}");
Console.WriteLine(token);
//Set parameters for report
D.ReportDefinition.Parameter[] reportParams = new D.ReportDefinition.Parameter[]
{
  new D.ReportDefinition.Parameter { PermDesc = "CoNo", ParamValue = "{MerchantNumber}" },
  new D.ReportDefinition.Parameter { PermDesc = "DateProcessStart", ParamValue = "2024-01-01" }
};
//Run report
Response resp = GetReport.RunReport(token, "TransactionLog", reportParams,
D.ReportDefinition.OutputType.HTML);
Console.WriteLine(resp.I.SData);