Click or drag to resize

Transaction_2019_01Get_Transaction Method

Retrieves a list of transactions from Epic that meet the requirements specified in the transaction filter object
Namespace:  ASI.TAM.API.Web.EpicSDK.Transaction
Assembly:  ASI.TAM.API.Web.EpicSDK (in ASI.TAM.API.Web.EpicSDK.dll) Version: 2021.1.0.1
Syntax
TransactionGetResultV1 Get_Transaction(
	TransactionFilter_2016_01 TransactionFilterObject,
	int PageNumber
)

Parameters

TransactionFilterObject
Type: ASI.TAM.API.Data.UI.TransactionTransactionFilter_2016_01
The filter object determines which transaction are retrieved
PageNumber
Type: SystemInt32
The desired page of transactions (30 transactions per page)

Return Value

Type: TransactionGetResultV1
A result object containing an array of transactions and the total number of pages
Remarks
Transactions per page = 30
Examples
VB
 1' Imports SDK2011_01 = [Project Name].schemas.appliedsystems.com.epic.sdk._2011._01
 2' Imports SDK2009_07 = [Project Name].schemas.appliedsystems.com.epic.sdk._2009._07
 3
 4' Constant DATABASE preset to current database name
 5' Constant AUTHENTICATION_KEY set to current authentication key
 6
 7Dim oHeader As New SDK2009_07.MessageHeader ' Instantiate the Header object
 8
 9Dim oTransactionResult As SDK2011_01._get.TransactionGetResult ' Declare the ResultObject
10
11' Populate the database and authentication key in the Header object
12oHeader.DatabaseName = DATABASE
13oHeader.AuthenticationKey = AUTHENTICATION_KEY
14
15' Account_ID can be obtained from Insert_Client or Get_Client when AccountType is 'CUST' (Client).
16Dim Account_ID As Integer = 65538
17
18Dim oFilter As New SDK2016_01._get.TransactionFilter
19With oFilter
20  .AccountID = Account_ID
21  .AccountTypeCode = "CUST" ' Can be obtained from AccountType lookup.
22  .TransactionStatus = SDK2016_01._get._transactionfilter.TransactionStatus.BalanceForward
23End With
24
25Dim oService As New EpicSDK_2018_01Client ' Instantiate the Service object
26Try
27  oTransactionResult = oService.Get_Transaction(oHeader, oFilter, 0) 'Issue the get call
28
29  oService.Close() ' Close the service
30Catch ex As Exception
31  oService.Abort()
32  Console.WriteLine("Error: " & ex.Detail.Description)
33  Console.WriteLine("Press any key to exit...")
34  Console.ReadLine()
35  Exit Sub
36End Try
37
38Console.WriteLine("Number of Transactions in page: " & oTransactionResult.Transactions.Count.ToString)
39Console.WriteLine("Number of pages: " & oTransactionResult.TotalPages.ToString)
40
41For Each oTransaction As SDK2011_01._account.Transaction In oTransactionResult.Transactions
42  Console.WriteLine("Account Type Code: " & oTransaction.AccountTypeCode & " Balance: " & oTransaction.Balance & " Accounting Month: " & oTransaction.BillingValue.AccountingMonth &
43                    " Bill Number: " & oTransaction.BillNumber.ToString & " Transaction Amount: " & oTransaction.TransactionAmount.ToString)
44Next
See Also