TrxDetail


Click here for a complete list of operations.

GetCardTrxSummary

Retrieves card transaction summary for a merchant.
Required parameters are in bold.
ParameterValue
UserNameRequired: User Name
PasswordRequired: Password
RPNumRequired query field: The merchant's RP Number, the query will be run against this merchant's account.
BeginDtOptional 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
EndDtOptional 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
ApprovalCodeOptional query field: If provided, only those transactions matching the Approval Code will be included.
NameOnCardOptional 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".
CardNumOptional 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.
CardTypeOptional query field: Card Type, if provided, only those transactions matching the CardType will be included.
Valid values are
  • 'ACH'
  • 'AMEX'
  • 'CARTBLANCH'
  • 'DEBIT'
  • 'DINERS'
  • 'DISCOVER'
  • 'EBT'
  • 'JAL'
  • 'JCB'
  • 'MASTERCARD'
  • 'VISA'

Or any permutation of the above values, e.g. "'VISA','MASTER','DISCOVER'" will pull all transactions with either VISA, MASTER and DISCOVER payment type.
ExcludeCardTypeOptional query field: If provided, any transactions matching the ExcludeCardType will be excluded.
ExcludeVoidOptional query field: Whether to exclude voided transaction, must either be TRUE or FALSE. Default is TRUE
UserOptional 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.
RegisterOptional query field: The register that originated the transactions. If provided, only those transactions with matching register will be included.
SettleFlagOptional query field: Whether the transaction was settled.
SettleMsgOptional query field: The settlement ID or Message returned from the host.
SettleDtOptional query field: The settlement timestamp.
TransformTypeOptional: Default is XML.
  • XML - output the plain XML string
  • XSL - use XSL to transform the XML output
  • DELIM - use ColDelim and RowDelim to format the output
XslOptional: 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:
  • TabDelim.xsl
ColDelimOptional: This field is used only if the TransformType is "DELIM". This defines the string taht sepearte each column.
RowDelimOptional: This field is used only if the TransformType is "DELIM". This defines the string that separate each row.
IncludeHeaderOptional: 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.
ExtDataOptional: 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.
Parameter Value
UserName:
Password:
RPNum:
BeginDt:
EndDt:
ApprovalCode:
Register:
NameOnCard:
CardNum:
CardType:
ExcludeVoid:
User:
SettleFlag:
SettleMsg:
SettleDt:
TransformType:
Xsl:
ColDelim:
RowDelim:
IncludeHeader:
ExtData:

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>