TrxDetail
Click here for a complete list of operations.
GetCardTrxSummary
Retrieves card transaction summary for a merchant.
Required parameters are in bold.
Parameter | Value |
UserName | Required: User Name |
Password | Required: Password |
RPNum | Required query field: The merchant's RP Number, the query will be run against this merchant's account. |
BeginDt | Optional query field: The begin date of the date range in MM/DD/YYYY format. This date will be converted to MM/DD/YYYYT00:00:00:0000AM |
EndDt | Optional query field: The end date of the date range in MM/DD/YYYY format. This date will be converted to MM/DD/YYYYT12:59:59:9999PM |
ApprovalCode | Optional query field: If provided, only those transactions matching the Approval Code will be included. |
NameOnCard | Optional query field: Card holder's name, if provided, only those transactions with card holder's name matching NameOnCard will be included. Matching is done using wild card. e.g. "test" will match "test", "1test" and "1test234". |
CardNum | Optional query field: Card number, if provided, only those transactions with card holder's name matching CardNum will be included. Matching is done using wild card. |
CardType | Optional query field: Card Type, if provided, only those transactions matching the CardType will be included. Valid values are
Or any permutation of the above values, e.g. "'VISA','MASTER','DISCOVER'" will pull all transactions with either VISA, MASTER and DISCOVER payment type. |
ExcludeCardType | Optional query field: If provided, any transactions matching the ExcludeCardType will be excluded. |
ExcludeVoid | Optional query field: Whether to exclude voided transaction, must either be TRUE or FALSE. Default is TRUE |
User | Optional query field: The user who originated the transactions, if provided, only those transactions with card holder's name matching User will be included. Matching is done using wild card. |
Register | Optional query field: The register that originated the transactions. If provided, only those transactions with matching register will be included. |
SettleFlag | Optional query field: Whether the transaction was settled. |
SettleMsg | Optional query field: The settlement ID or Message returned from the host. |
SettleDt | Optional query field: The settlement timestamp. |
TransformType | Optional: Default is XML.
|
Xsl | Optional: This field is used only if the TransformType is "XSL". The XSL to transform the resulting dataset, if provided, the resulting dataset will be transformed using this XSL. You may pass in a URL to the XSL file, or the XSL string itself. If this field is not empty, the Web Service will try to locate the file from the URL. If that also fails, it will treat it as a XSL string. In any case, the final XSL string will be loaded and validated against the XSL schema, if it pass, then that XSL will be used for transformation. A sample predefined XSL is included with this Web Service:
|
ColDelim | Optional: This field is used only if the TransformType is "DELIM". This defines the string taht sepearte each column. |
RowDelim | Optional: This field is used only if the TransformType is "DELIM". This defines the string that separate each row. |
IncludeHeader | Optional: This field is used only if the TransformType is "DELIM". If TRUE, then field headers will be included in the first row using the same delimiter strings. |
ExtData | Optional: Extended Data in XML, Valid Values are: IMAGE_TYPE - can be NO_IMAGE, ONLY_IMAGE, ONLY_IMAGE_INCLUDE_DATA, ALL or ALL_INCLUDE_DATA. CustomerID, Amount, RegisterNum |
Test
To test the operation using the HTTP POST protocol, click the 'Invoke' button.SOAP 1.1
The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values.
POST /admin/ws/trxdetail.asmx HTTP/1.1 Host: secure.ftipgw.com Content-Type: text/xml; charset=utf-8 Content-Length: length SOAPAction: "http://demo.tpisoft.com/Admin/ws/GetCardTrxSummary" <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <GetCardTrxSummary xmlns="http://demo.tpisoft.com/Admin/ws"> <UserName>string</UserName> <Password>string</Password> <RPNum>string</RPNum> <BeginDt>string</BeginDt> <EndDt>string</EndDt> <ApprovalCode>string</ApprovalCode> <Register>string</Register> <NameOnCard>string</NameOnCard> <CardNum>string</CardNum> <CardType>string</CardType> <ExcludeVoid>string</ExcludeVoid> <User>string</User> <SettleFlag>string</SettleFlag> <SettleMsg>string</SettleMsg> <SettleDt>string</SettleDt> <TransformType>string</TransformType> <Xsl>string</Xsl> <ColDelim>string</ColDelim> <RowDelim>string</RowDelim> <IncludeHeader>string</IncludeHeader> <ExtData>string</ExtData> </GetCardTrxSummary> </soap:Body> </soap:Envelope>
HTTP/1.1 200 OK Content-Type: text/xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <GetCardTrxSummaryResponse xmlns="http://demo.tpisoft.com/Admin/ws"> <GetCardTrxSummaryResult>string</GetCardTrxSummaryResult> </GetCardTrxSummaryResponse> </soap:Body> </soap:Envelope>
HTTP GET
The following is a sample HTTP GET request and response. The placeholders shown need to be replaced with actual values.
GET /admin/ws/trxdetail.asmx/GetCardTrxSummary?UserName=string&Password=string&RPNum=string&BeginDt=string&EndDt=string&ApprovalCode=string&Register=string&NameOnCard=string&CardNum=string&CardType=string&ExcludeVoid=string&User=string&SettleFlag=string&SettleMsg=string&SettleDt=string&TransformType=string&Xsl=string&ColDelim=string&RowDelim=string&IncludeHeader=string&ExtData=string HTTP/1.1 Host: secure.ftipgw.com
HTTP/1.1 200 OK Content-Type: text/xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <string xmlns="http://demo.tpisoft.com/Admin/ws">string</string>
HTTP POST
The following is a sample HTTP POST request and response. The placeholders shown need to be replaced with actual values.
POST /admin/ws/trxdetail.asmx/GetCardTrxSummary HTTP/1.1 Host: secure.ftipgw.com Content-Type: application/x-www-form-urlencoded Content-Length: length UserName=string&Password=string&RPNum=string&BeginDt=string&EndDt=string&ApprovalCode=string&Register=string&NameOnCard=string&CardNum=string&CardType=string&ExcludeVoid=string&User=string&SettleFlag=string&SettleMsg=string&SettleDt=string&TransformType=string&Xsl=string&ColDelim=string&RowDelim=string&IncludeHeader=string&ExtData=string
HTTP/1.1 200 OK Content-Type: text/xml; charset=utf-8 Content-Length: length <?xml version="1.0" encoding="utf-8"?> <string xmlns="http://demo.tpisoft.com/Admin/ws">string</string>