XML Integrator (Queries)

Quick links
​Introduction​
​Request Message​
​Response Message​
​Typical Example Requests and Responses​
Introduction
This document describes the interface for retrieving transaction data from the PPRO system. It has been designed in a way that the retrieval and processing of the data can be fully automated and there is no need for manual intervention.
URL
In order to retrieve the requested data from the PPRO system an XML message has to be sent via HTTP- POST within a parameter called "load“ to the following URL:
 Test-URL: https://test.ctpe.net/payment/query​
 Live-URL: https://ctpe.net/payment/query​
As a result of this request you will get an XML stream including all of the transactions that fulfil your filter criteria.

Request Description 
The Request version must be specified and is “1.0” always.
Query describes the mode for which you want to receive transaction data and for which entity. You can query for any defined entity that exists in your account. Please be aware that if you define for example the level to be CHANNEL the ID of the entity must be a channel ID.
The element Type describes which transaction types you can query from the gateway. It is possible to query all available payment types. However, for some payment types a time limitation may apply, ie they can only be queried over a period of one day. 
At the moment three types are available for searches over a maximum period of one month:
Chargeback (CB)
Chargeback Reversal (CR)
Receipt (RC)
In those cases the difference between “from” and “to” in the Period tag must be lower than or equal to one month.
All other types can only be queried over a period of one day, meaning “from” and “to” in the Period tag must be the same.
 IMPORTANT: The maximum number of transactions per query is limited depending on the types and period you are querying for:
The maximum number of results per query in general is 10.000.
In case you query for a longer period than one week or you do not specify a period at all the maximum number is 2.000.
In case you query for a type other than CB, CR or RC, the maximum number is 2.000.
In case you search for “TransactionID”, the maximum number is 200.
Queries for ShortID and UniqueID do not require any time period or other additional query parameters
If the time period is lower than ten minutes, the query can be executed without any limiting query parameters
For system stability and security reasons PPRO reserves the right to block the query interface for single merchants in case the query API should be receiving e.g. a massive number of automated queries beyond tolerable limits. See chapter 4 for typical use cases and recommended queries.
Simple Request Example
Simple Response Example 1
Simple Response Example 2
1
<Request version="1.0">
2
    <Header>
3
        <Security sender="ff80808109c5bcc00109c5bce9f1003a" />
4
    </Header>
5
    <Query entity="ff80808109c5bcc00109c5bce9f50056" level="CHANNEL" mode="INTEGRATOR_TEST" type="STANDARD">
6
        <User login="ff80808109c5bcc00109c5bce9f20042" pwd="geheim" />
7
        <Period from="2006-03-04" to="2006-03-04" />
8
        <Types>
9
            <Type code="RF" />
10
            <Type code="PA" />
11
            <Type code="RV" />
12
        </Types>
13
    </Query>
14
</Request>
Copied!
1
<Response version="1.0">
2
<Result response='SYNC' type="LIST">
3
<Transaction .../>
4
<Transaction .../>
5
<Transaction .../>
6
...
7
</Result>
8
</Response>
Copied!
1
<Response>
2
<Error>
3
<Timestamp>2006-03-04 15:50:35</Timestamp>
4
<Return code="100.200.101">invalid period, if searching for non-backchannel-types
5
(CB, RC) from and to must be on the same day</Return>
6
</Error>
7
</Response>
Copied!
Request Message
Request Encoding:
For all payment requests containing shopping and possibly payment data, the request header must contain the Content-Type / charset parameter with the charset encoding set to “UTF-8”. The actual content type may differ; the decisive information is the charset value. 
Accordingly, all request data must be encoded using the UTF-8-character set. 
For XML data, please use the following Content-Type: application/x-www-form-urlencoded;charset=UTF-8 Examples:
Integration via PHP/cURL: http://php.net/manual/de/book.curl.php​
1
$ch = curl_init();
2
curl_setopt($ch, CURLINFO_HEADER_OUT, true);
3
curl_setopt($ch, CURLOPT_HTTPHEADER, array(
4
"Content-Type: application/x-www-form-urlencoded;charset=UTF-8"
5
));
6
// attach parameter curl_exec($ch);
Copied!
Integration via Java:
1
UrlRequest req = new UrlRequest(UrlRequest.POST, CORE_URL );
2
// attach parameter to request
3
req.addHeaderParam("Content-Type", "application/x-www-form-urlencoded;charset=UTF-8");
4
req.send();
Copied!
Header Group 
The header group of the XML request holds transmission and security related information.
1
<Header>
2
    <Security sender="123a456b789c123d456e789f012g345”/>
3
</Header>
Copied!
Value for sender 
Description
Alphanumeric 32
Each entity (PSP, Division, Merchant, Channel) which sends requests to the system has an own sender unique ID. The sender UID is no logical business orientated subdivision like the channel ID, but refers to physical installations of software. Please provide here the value you have received from the customer support department.
Query Group 
1
<Query mode="LIVE" level="CHANNEL" entity="678a456b789c123d456e789f012g432" 
2
type="STANDARD" maxCount=”5”>
Copied!
The query tag has three attributes which determine the processing of the query.
Value for mode 
Description
INTEGRATOR_TEST
Transaction gets just sent to the Integrator and not to the Validator (Risk Management) or Connector modules. Used to test compliance against the Integrator module.
CONNECTOR_TEST
Transaction enters the Integrator module, accesses the Validator modules (Risk Management) and then goes to the Connector. The Connector operates in test mode.
LIVE
Transaction enters the Integrator module, accesses the Validator modules (Risk Management) and then goes to the Connector. The Connector operates in live mode.
Value for level 
Description
CHANNEL
Transactions are queried on channel level (ID specified with entity is a channel ID)
MERCHANT
Transactions are queried on merchant level (ID specified with entity is a merchant ID)
Value for type
Description
STANDARD
This is the default type. No special behavior activated.
ACTIVE_TRANSACTIONS
Queries all transactions which match the given query parameters and which are active transactions of their sessions.
LINKED_TRANSACTIONS
Queries all transactions which are linked directly or indirectly to one specific transaction. For this type the ID or ShortID of one transaction must be specified.
AVAILABLE_TRANSACTIONS
Queries all transactions which match the given query parameters and which are available transactions of their sessions.
The difference between ACTIVE_TRANSACTIONS and AVAILABLE_TRANSACTIONS applies to registrations only: “active” are only confirmed registrations, “available” are not confirmed registrations also.
ACTIVE_LINKED_TRANSACTIONS
Queries all transactions which are linked directly or indirectly to one specific transaction and which are active transactions in their session. For this type the ID or ShortID of one transaction must be specified.
AVAILABLE_LINKED_TRANSACTIONS
Queries all transactions which are linked directly or indirectly to one specific transaction and which are active transactions in their session. For this type the ID or ShortID of one transaction must be specified. The difference between ACTIVELINKED TRANSACTIONS and AVAILABLE_LINKED_TRANSACTIONS applies to registrations only: “active” are only confirmed registrations, “available” are not confirmed registrations also.
Value for maxCount
Description
Number
Maximum number of returned transactions by the query. Especially helpful if you want to get the last 10 transaction only for an overview or similar to speedup your application.
Value for entity
Description
Alphanumeric 32
ID of the entity specified in level. The entity ID is a unique key for the identification of the unit which sends transactions into the system.
User Group
The User tag group contains security related information. Check the document “Technical Quickstart” for information on how to retrieve this login data for your test account. Contact your account manager for the live account data.
1
<User login="421a456b789c123d456e789f012g098" pwd="56b789c123d456e789f"/>
Copied!
Value for login
Description
Alphanumeric 32
The login is a unique ID for each human or system user. Each merchant or payment service provider can have several logins for system users and human users. It is not recommended to share one login between several human users.
Value for pwd
Description
Alphanumeric 3..32
A password which fits the login UID has to be provided. It is distributed together with the login UID.
Identification Group
The identification group contains IDs which are used for the identification of the transaction:
• Unique ID
• Short ID
• TransactionID
1
<Identification>
2
    <UniqueID>12345678901234567890123456789012</UniqueID>
3
    <ShortID>1234.1234.1234</ShortID>
4
    <TransactionID>Merchant_Defined_ID_For_A_Transaction</TransactionID>
5
</Identification>
Copied!
​
Search for UniqueID or ShortID:
This group allows the user to query for specific transactions if the ShortId or the UniqueId is known. Both IDs are part of each XML Transaction Response. Only one of the two IDs is required. If either UniqueID or ShortID is present, Period and Types are optional.
Identification Tag
Data Type
Length
Mandatory / Optional
Description
UniqueID
Alphanumeric
32
Conditionally Mandatory
Only ID where the uniqueness within the system is absolutely guaranteed. Has to be used for al automated matching and reference purposes.
ShortID
Numeric / Dots
14
Conditionally Mandatory
ID which is used for manual entry and search purposes. The likelihood for uniqueness is very high, but no guaranteed.
Search for more than one UniqueID at the same time:
This group allows the user to query for specific transactions the UniqueIds are known and return them all at once. Period and Types are optional.
Identification Tag
Data Type
Length
Mandatory / Optional
Description
UniqueID
Alphanumeric
32
Conditionally Mandatory
Contains a list of ID sub elements
ID
Alphanumeric
32
Conditionally Mandatory
Only ID where the uniqueness within the system is absolutely guaranteed. Has to be used for all automated matching and reference purposes.
1
<Identification>
2
    <UniqueIDs>
3
        <ID>1234567890123456789012bb3456789012</ID>
4
        <ID>ff8081811bfa5356011bfbe22a2800b4</ID>
5
    </UniqueIDs>
6
</Identification>
Copied!
​
Search for TransactionID: 
This group also allows the user to query for specific transactions by the TransactionID. This is the ID the merchant has assigned to a specific payment transaction.
Identification Tag
Data Type
Length
Mandatory / Optional
Description
TransactionID
Alphanumeric
32
Optional
ID the merchant has assigned to a specific payment transaction and submitted with the origina payment transaction.
This ID does not necessarily have to be unique when it gets submitted the payment system with a payment transaction. Nevertheless, it is highly recommended to use unique (or at least selective) ones. For safety and stability reasons of the query interface, this query allows you to retrieve a maximum of 200 transactions per TransactionID.
TransactionType Group
The TransactionType group contains an alternative and/or extension to the Methods group. It allows you to define what types of transactions your query result should contain.
1
<TransactionType>PAYMENT</TransactionType>
Copied!
Value of TransactionType
Description
PAYMENT
Payment Transaction Types. Those are CB, CR, DB, CP, PA, RC, RF and RV
REGISTER
Registration Transaction Types. Those are CF, DR and RG 
RISKMANAGEMENT
Risk Management Transaction Types. Those are EA, RI, 3D, SA, and IC. This list is always extending as new features are implemented.
Period Group
This tag group specifies the date period of the query. The “from” date is always extended with the time 00:00:00 and the “to” date with 23:59:59. All times are UTC only.
For the following payment types the “from” and “to” date can be any day:

Chargeback (CB) 
Chargeback Reversal (CR) 
Receipt (RC)
For all other payment types the “from” and “to” date have to be on the same day. This means only one day can be queried within one XML query request.
1
<Period from="2018-09-01" to="2018-09-15 12:00:00"/>
Copied!
Value for [from]
Description
Value for [to]
Description
Date, format yyyy-MM-dd [HH:mm:ss]
Date from when the query starts.
Date, format yyyy-MM-dd [HH:mm:ss]
Date when the query ends.
Methods Group
The Methods tag group contains information about the payment methods you want to retrieve.
1
<Methods>
2
<Method code="CC"/>
3
</Methods>
Copied!
Value for code
Description
Alpha(2)
A valid payment method. 
Types Group
The Types tag group contains information about the payment types you want to retrieve.
1
<Types>
2
    <Type code="CB" />
3
    <Type code="PA" />
4
</Types>
Copied!
Value for code
Description
Alpha(2)
A valid payment type. 
ProcessingResult Group
The ProcessingResult tag group contains information if you want to query for successful of failed transactions only. It is the same tag you would receive in an XML payment response as part of the Processing Tag Group (See document “XML Transactions”).
1
<ProcessingResult>ACK</ProcessingResult>
Copied!
Value for ProcessingResult
Description
ACK
Get successful Transactions only
NOK
Get failed (rejected) Transactions only
Account Group
The account group allows you to search for user account. This tag group is only needed if you search for registered user accounts.
1
<Account>
2
    <Id>[email protected]</Id>
3
    <Password>pwd12345</Password>
4
    <Brand>TESTWALLET</Brand>
5
</Account>
Copied!
Identification Tag
Data Type
Length
Mandatory / Optional
Description
Id
Alphanumeric
128
Mandatory
ID of the user with the User Account
Brand
Alphanumeric
32
Mandatory
Brand of the User Account
Password
Password
32
Mandatory
Password of the registered user
Response Message
The result to a query request message is – like the response to an XML transaction request – surrounded by a  tag. The response tag contains either a Result Group or, in case of an invalid request, an Error Group.
Result Group
1
<Result response='SYNC' type="LIST">
Copied!
Value for response 
Description
Value for response
Description
SYNC
All requested transactions are part of this request and are nested inside the Result Group
LIST
Specifies that the transactions are provided as a list inside the Result group
Error Group
1
<Error>
2
    <Timestamp>2004-11-11 11:11:11</Timestamp>
3
    <Return code="100.100.101">invalid entity type</Return>
4
</Error>
Copied!
Tag of Error
Description
Timestamp
Date and Time of the request, format is “yyyy-MM-dd hh:mm:ss”
Return
Contains error information describing the occurred error as text
Value for code
Description
Alphanumeric, format is nnn.nnn.nnn
Return code identifying the error that occurred. For a list of all error codes check: https://test.ctpe.net/payment/codes/queryErrorCodes.jsp​
Typical Example Requests and Responses
Chargebacks (CB)
For retrieving chargebacks for a certain period, a request has to be sent to the query engine at: 
Test-URL: https://test.ctpe.net/payment/query 
Live-URL: https://ctpe.net/payment/query​
Typical Use Case: 
Automatically retrieve chargebacks from the payment system. Depending on the acquirer or bank new Chargebacks usually appear once a day in the system. For details, please, contact your account manager. Therefore, it does not make sense to query the system for new Chargebacks every five minutes or so. 
Please note: For system safety and stability reasons the merchant query access may be blocked in case of receiving too many automated requests from this account within a short timeframe.
This request will retrieve the chargebacks for the channel identified by the ID 8a8294174e918ca6014e9c6f5ae12a9c for the week of the 27th of March to the 2nd of April. Let’s assume 3 chargebacks have been issued during that period. The result might look something like the Response sample tab.
Request sample
Response sample
1
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
2
<Request version="1.0">
3
    <Header>
4
        <Security sender="8a829417281b8ee30128299066f50cd7" />
5
    </Header>
6
    <Query entity="8a8294174e918ca6014e9c6f5ae12a9c" level="CHANNEL" mode="CONNECTOR_TEST" type="STANDARD">
7
        <User pwd="demo" login="8a829417281b8ee30128299066f50cdb" />
8
        <Period from="2019-03-27" to="2019-04-02" />
9
        <Types>
10
            <Type code="CB" />
11
        </Types>
12
    </Query>
13
</Request>
Copied!
1
<Response>
2
    <Result response="SYNC" count="3">
3
        <Transaction mode="CONNECTOR_TEST" channel="8a8294174e918ca6014e9c6f5ae12a9c" response="SYNC" source="BIP">
4
            <Identification>
5
                <ShortID>6210.1105.3145</ShortID>
6
                <UniqueID>8ac7a4a269d942dc0169dfe4b03941dd</UniqueID>
7
                <TransactionID>Order Number 123</TransactionID>
8
                <ShopperID>12345678909</ShopperID>
9
                <BulkID>2019-03-29</BulkID>
10
                <ReferenceID>8ac7a4a169c855450169cb2d27680f90</ReferenceID>
11
            </Identification>
12
            <Payment code="CC.CB">
13
                <Clearing>
14
                    <Amount>1.00</Amount>
15
                    <Currency>BRL</Currency>
16
                    <Descriptor>123 Usage</Descriptor>
17
                    <FxRate>1.0</FxRate>
18
                    <FxSource>INTERN</FxSource>
19
                    <FxDate>2019-04-02 21:11:40</FxDate>
20
                </Clearing>
21
                <Memo />
22
                <Presentation>
23
                    <Amount>1.00</Amount>
24
                    <Currency>BRL</Currency>
25
                    <Usage>123 Usage</Usage>
26
                    <ValueTimestamp>2019-04-02 21:11:40</ValueTimestamp>
27
                </Presentation>
28
            </Payment>
29
            <Account>
30
                <Number>******1111</Number>
31
                <Holder>Leandro</Holder>
32
                <Brand>VISA</Brand>
33
                <Year>2019</Year>
34
                <Month>10</Month>
35
                <Bin>411111</Bin>
36
                <Expiry month="10" year="2019" />
37
            </Account>
38
            <Customer>
39
                <Name>
40
                    <Family>da Silva</Family>
41
                    <Given>Jose</Given>
42
                </Name>
43
                <Contact>
44
                    <Email>[email protected]</Email>
45
                    <Ip>123.123.123.123</Ip>
46
                </Contact>
47
                <Address>
48
                    <City>Sao Paulo</City>
49
                    <Country>BR</Country>
50
                    <State>SP</State>
51
                    <Street>Rua Itapeva 547</Street>
52
                    <Zip>01332000</Zip>
53
                </Address>
54
                <Details />
55
            </Customer>
56
            <Processing code="CC.CB.90.00">
57
                <Timestamp>2019-04-02 21:11:40</Timestamp>
58
                <Result>ACK</Result>
59
                <Status code="90">NEW</Status>
60
                <Reason code="00">Successful Processing</Reason>
61
                <Return code="000.100.200">Reason not Specified</Return>
62
                <ConnectorDetails />
63
            </Processing>
64
            <RequestTimestamp>2019-04-02 21:11:40</RequestTimestamp>
65
            <Analysis>
66
                <Criterion name="INFO_matchingAlgorithm">MANUAL_MATCH</Criterion>
67
            </Analysis>
68
        </Transaction>
69
        <Transaction mode="CONNECTOR_TEST" channel="8a8294174e918ca6014e9c6f5ae12a9c" response="SYNC" source="BIP">
70
            <Identification>
71
                <ShortID>0605.1782.0929</ShortID>
72
                <UniqueID>8ac7a4a069d942db0169dfe4efe045e3</UniqueID>
73
                <TransactionID>Order Number 123</TransactionID>
74
                <ShopperID>12345678909</ShopperID>
75
                <BulkID>2019-03-28</BulkID>
76
                <ReferenceID>8ac7a4a069c3549d0169c5f4a508215b</ReferenceID>
77
            </Identification>
78
            <Payment code="CC.CB">
79
                <Clearing>
80
                    <Amount>1.00</Amount>
81
                    <Currency>BRL</Currency>
82
                    <Descriptor>123 Usage</Descriptor>
83
                    <FxRate>1.0</FxRate>
84
                    <FxSource>INTERN</FxSource>
85
                    <FxDate>2019-04-02 21:11:56</FxDate>
86
                </Clearing>
87
                <Memo />
88
                <Presentation>
89
                    <Amount>1.00</Amount>
90
                    <Currency>BRL</Currency>
91
                    <Usage>123 Usage</Usage>
92
                    <ValueTimestamp>2019-04-02 21:11:56</ValueTimestamp>
93
                </Presentation>
94
            </Payment>
95
            <Account>
96
                <Number>******1111</Number>
97
                <Holder>Leanndro Teste23</Holder>
98
                <Brand>VISA</Brand>
99
                <Year>2019</Year>
100
                <Month>10</Month>
101
                <Bin>411111</Bin>
102
                <Expiry month="10" year="2019" />
103
                <RegistrationId>8ac7a4a269c3eab00169c5f4a3726f0c</RegistrationId>
104
            </Account>
105
            <Customer>
106
                <Name>
107
                    <Family>da Silva</Family>
108
                    <Given>Jose</Given>
109
                </Name>
110
                <Contact>
111
                    <Email>[email protected]</Email>
112
                    <Ip>123.123.123.123</Ip>
113
                </Contact>
114
                <Address>
115
                    <City>Sao Paulo</City>
116
                    <Country>BR</Country>
117
                    <State>SP</State>
118
                    <Street>Rua Itapeva 547</Street>
119
                    <Zip>01332000</Zip>
120
                </Address>
121
                <Details />
122
            </Customer>
123
            <Processing code="CC.CB.90.00">
124
                <Timestamp>2019-04-02 21:11:56</Timestamp>
125
                <Result>ACK</Result>
126
                <Status code="90">NEW</Status>
127
                <Reason code="00">Successful Processing</Reason>
128
                <Return code="000.100.200">Reason not Specified</Return>
129
                <ConnectorDetails />
130
            </Processing>
131
            <RequestTimestamp>2019-04-02 21:11:56</RequestTimestamp>
132
            <Analysis>
133
                <Criterion name="INFO_matchingAlgorithm">MANUAL_MATCH</Criterion>
134
            </Analysis>
135
        </Transaction>
136
        <Transaction mode="CONNECTOR_TEST" channel="8a8294174e918ca6014e9c6f5ae12a9c" response="SYNC" source="BIP">
137
            <Identification>
138
                <ShortID>4722.9781.0526</ShortID>
139
                <UniqueID>8ac7a49f69d940fa0169dfe52a424545</UniqueID>
140
                <TransactionID>Order Number 123</TransactionID>
141
                <ShopperID>12345678909</ShopperID>
142
                <BulkID>2019-03-28</BulkID>
143
                <ReferenceID>8ac7a4a169c31dca0169c5ef22ff69b9</ReferenceID>
144
            </Identification>
145
            <Payment code="CC.CB">
146
                <Clearing>
147
                    <Amount>1.00</Amount>
148
                    <Currency>BRL</Currency>
149
                    <Descriptor>123 Usage</Descriptor>
150
                    <FxRate>1.0</FxRate>
151
                    <FxSource>INTERN</FxSource>
152
                    <FxDate>2019-04-02 21:12:11</FxDate>
153
                </Clearing>
154
                <Memo />
155
                <Presentation>
156
                    <Amount>1.00</Amount>
157
                    <Currency>BRL</Currency>
158
                    <Usage>123 Usage</Usage>
159
                    <ValueTimestamp>2019-04-02 21:12:11</ValueTimestamp>
160
                </Presentation>
161
            </Payment>
162
            <Account>
163
                <Number>******1111</Number>
164
                <Holder>Leandro Teste</Holder>
165
                <Brand>VISA</Brand>
166
                <Year>2019</Year>
167
                <Month>10</Month>
168
                <Bin>411111</Bin>
169
                <Expiry month="10" year="2019" />
170
                <RegistrationId>8ac7a4a069c3549d0169c5ef21371cbf</RegistrationId>
171
            </Account>
172
            <Customer>
173
                <Name>
174
                    <Family>da Silva</Family>
175
                    <Given>Jose</Given>
176
                </Name>
177
                <Contact>
178
                    <Email>[email protected]</Email>
179
                    <Ip>123.123.123.123</Ip>
180
                </Contact>
181
                <Address>
182
                    <City>Sao Paulo</City>
183
                    <Country>BR</Country>
184
                    <State>SP</State>
185
                    <Street>Rua Itapeva 547</Street>
186
                    <Zip>01332000</Zip>
187
                </Address>
188
                <Details />
189
            </Customer>
190
            <Processing code="CC.CB.90.00">
191
                <Timestamp>2019-04-02 21:12:11</Timestamp>
192
                <Result>ACK</Result>
193
                <Status code="90">NEW</Status>
194
                <Reason code="00">Successful Processing</Reason>
195
                <Return code="000.100.200">Reason not Specified</Return>
196
                <ConnectorDetails />
197
            </Processing>
198
            <RequestTimestamp>2019-04-02 21:12:11</RequestTimestamp>
199
            <Analysis>
200
                <Criterion name="INFO_matchingAlgorithm">MANUAL_MATCH</Criterion>
201
            </Analysis>
202
        </Transaction>
203
    </Result>
204
</Response>
Copied!
Receipts (RC)
Typical Use Case: 
Automatically retrieve if somebody has transferred money onto your bank account. In order to check if a prepayment (PP) has been fulfilled you have to retrieve receipts. Again, a request has to be sent to the query engine at: 

Test-URL: https://test.ctpe.net/payment/query 
Live-URL: https://ctpe.net/payment/query​
This request will retrieve the receipts for the channel identified by the ID 8a8294174e918ca6014e9c6e44672a96 for the week of the 27th of March to the 3rd of April. 
Let’s assume that one receipt has been issued during that period. The result will look like the Response sample tab.
Request sample
Response sample
1
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
2
<Request version="1.0">
3
    <Header>
4
        <Security sender="8a829417281b8ee30128299066f50cd7" />
5
    </Header>
6
    <Query entity="8a8294174e918ca6014e9c6e44672a96" level="CHANNEL" mode="CONNECTOR_TEST" type="STANDARD">
7
        <User pwd="demo" login="8a829417281b8ee30128299066f50cdb" />
8
        <Period from="2019-03-27" to="2019-04-03" />
9
        <Types>
10
            <Type code="RC" />
11
        </Types>
12
    </Query>
13
</Request>
Copied!
1
<Response>
2
    <Result response="SYNC" count="1">
3
        <Transaction mode="CONNECTOR_TEST" channel="8a8294174e918ca6014e9c6e44672a96" response="SYNC" source="BIP">
4
            <Identification>
5
                <ShortID>9938.5741.5684</ShortID>
6
                <UniqueID>8ac7a4a169d940fc0169e468db810b13</UniqueID>
7
                <TransactionID>06121808</TransactionID>
8
                <BulkID>2019-04-03</BulkID>
9
                <InvoiceID>6000000557</InvoiceID>
10
                <ReferenceID>8ac7a4a069d942db0169e4684fa52239</ReferenceID>
11
            </Identification>
12
            <Payment code="PP.RC">
13
                <Clearing>
14
                    <Amount>161.69</Amount>
15
                    <Currency>BRL</Currency>
16
                    <Descriptor>Demo 1633.1811.4926 06121808</Descriptor>
17
                    <FxRate>1.0</FxRate>
18
                    <FxSource>INTERN</FxSource>
19
                    <FxDate>2019-04-03 18:14:31</FxDate>
20
                </Clearing>
21
                <Memo />
22
                <Presentation>
23
                    <Amount>161.69</Amount>
24
                    <Currency>BRL</Currency>
25
                    <Usage>Testando descriptor</Usage>
26
                    <ValueTimestamp>2019-04-03 18:14:30</ValueTimestamp>
27
                </Presentation>
28
            </Payment>
29
            <Account>
30
                <Country>BR</Country>
31
            </Account>
32
            <Customer>
33
                <Name>
34
                    <Family>Artem</Family>
35
                    <Given>Artem</Given>
36
                </Name>
37
                <Contact>
38
                    <Email>[email protected]</Email>
39
                    <Ip>127.0.0.1</Ip>
40
                </Contact>
41
                <Address>
42
                    <City>NorthPlatte</City>
43
                    <Country>BR</Country>
44
                    <State>AL</State>
45
                    <Street>516NDewey</Street>
46
                    <Zip>69101909</Zip>
47
                </Address>
48
                <Details />
49
            </Customer>
50
            <Processing code="PP.RC.90.00">
51
                <Timestamp>2019-04-03 18:14:31</Timestamp>
52
                <Result>ACK</Result>
53
                <Status code="90">NEW</Status>
54
                <Reason code="00">Successful Processing</Reason>
55
                <Return code="000.100.112">Request successfully processed in 'Merchant in Connector Test Mode'</Return>
56
                <ConnectorDetails />
57
            </Processing>
58
            <RequestTimestamp>2019-04-03 18:14:31</RequestTimestamp>
59
            <Analysis>
60
                <Criterion name="INFO_matchingAlgorithm">MANUAL_MATCH</Criterion>
61
            </Analysis>
62
        </Transaction>
63
    </Result>
64
</Response>
Copied!
Query Specific Transactions by ID
Typical Use Case: Automatically retrieve transactions from the payment system where you only have an ID.
In order to retrieve a transaction where the UniqueId or ShortId is known, only one transaction can be queried. For example, this can be particularly useful to retrieve a Registration of an user to be able to show the user the (masked) payment data or customer data he entered the last time he paid in the shop. This is very helpful in case you either do not have the UniqueID or ShortID anymore or you never received it (e.g. Timeout). In this case you are able to query the state of the transaction.
Request sample
Response sample for RC (Receipt)
Response sample for DB (Debit)
1
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
2
<Request version="1.0">
3
    <Header>
4
        <Security sender="8a829417281b8ee30128299066f50cd7" />
5
    </Header>
6
    <Query entity="8a8294174e918ca6014e9c6e44672a96" level="CHANNEL" mode="CONNECTOR_TEST" type="STANDARD">
7
        <User pwd="demo" login="8a829417281b8ee30128299066f50cdb" />
8
        <Period from="2019-03-27" to="2019-04-03" />
9
        <Identification>
10
            <ShortID>1633.1811.4926</ShortID>
11
        </Identification>
12
    </Query>
13
</Request>
Copied!
1
<Response>
2
    <Result response="SYNC" count="1">
3
        <Transaction mode="CONNECTOR_TEST" channel="8a8294174e918ca6014e9c6e44672a96" response="ASYNC" source="OPP">
4
            <Identification>
5
                <ShortID>1633.1811.4926</ShortID>
6
                <UniqueID>8ac7a4a069d942db0169e4684fa52239</UniqueID>
7
                <TransactionID>06121808</TransactionID>
8
                <BulkID>2019-04-03</BulkID>
9
                <InvoiceID>6000000557</InvoiceID>
10
            </Identification>
11
            <Payment code="PP.PA">
12
                <Clearing>
13
                    <Amount>161.69</Amount>
14
                    <Currency>BRL</Currency>
15
                    <Descriptor>Demo 1633.1811.4926 06121808</Descriptor>
16
                    <FxRate>1.0</FxRate>
17
                    <FxSource>INTERN</FxSource>
18
                    <FxDate>2019-04-03 18:13:55</FxDate>
19
                </Clearing>
20
                <Presentation>
21
                    <Amount>161.69</Amount>
22
                    <Currency>BRL</Currency>
23
                    <Usage>Testando descriptor</Usage>
24
                </Presentation>
25
            </Payment>
26
            <Account>
27
                <Country>BR</Country>
28
            </Account>
29
            <Customer>
30
                <Name>
31
                    <Family>Artem</Family>
32
                    <Given>Artem</Given>
33
                </Name>
34
                <Contact>
35
                    <Email>[email protected]</Email>
36
                    <Ip>127.0.0.1</Ip>
37
                </Contact>
38
                <Address>
39
                    <City>NorthPlatte</City>
40
                    <Country>BR</Country>
41
                    <State>AL</State>
42
                    <Street>516NDewey</Street>
43
                    <Zip>69101909</Zip>
44
                </Address>
45
                <Details />
46
            </Customer>
47
            <Processing code="PP.PA.90.00">
48
                <Timestamp>2019-04-03 18:13:55</Timestamp>
49
                <Result>ACK</Result>
50
                <Status code="90">NEW</Status>
51
                <Reason code="00">Successful Processing</Reason>
52
                <Return code="000.100.112">Request successfully processed in 'Merchant in Connector Test Mode'</Return>
53
                <ConnectorDetails>
54
                    <Result name="connectorInstanceId">10.2.3.225</Result>
55
                    <Result name="acquirerTxId2">16331811</Result>
56
                    <Result name="acquirerTxId1">1633.1811.4926</Result>
57
                    <Result name="acquirerReturnMessage">BOLETO LINK SUCCESSFULLY GENERATED</Result>
58
                    <Result name="acquirerReturnCode">0</Result>
59
                    <Result name="ExtendedDescription">User redirected to Itau</Result>
60
                    <Result name="merchantAccount">BR_Itau_ACON4_STAGING_AP</Result>
61
                    <Result name="EXTERNAL_SYSTEM_LINK">https://shopline.itau.com.br/shopline/itaubloqueto.asp?DC=L183R175W209L12Q238M104H153V172A232P63R165S217Q103D205B5Z138Z92F103O208R14B7H146L37X98U254Q251P62Y107W154X71Q47Y8Y60F226F195B163H172R72C162T222C162A99O219S128H225A27D148E140Y42A105U44O124I100H243P4K164U154T97Y250Y14M114C173L28B121H222T116W151C159D178C20T254M67H230B48V21K187E216I184Q103K64D209P89B101V226Q159P13W198Y215H150L100W182Z221D158D236R227L141H154E85W172X62O247H129U20U172O47O117K97T3F223H92E212B48O73T85Q249F20T11B2W176P216A90B120H117A236X60G76N213D18
62
6P150Y193F36Y224D123H182E70G112D228Y83K136X90G52I155A187K16A20X235K220B52Q14P72Y243L254T199B9N182P224D243U81P224D214Q39G141L6O9E136A112C91K54T62C171Y217X128Y28U128E201Q47L198D163B76V244U215E206K130J0L75P249T228C182S8N90U54G31V18L158N168I56G26B187X175I129Y22Q22I69L86R128X65N253J184S85W185O140W78I239I209E130J195Z207G108X6J194Y159M117Z230Z104U165I176V45E157P228L10J7N254W184A184J36G128B184D164P63B2R254C208U192N201A168M81Q44Z46S46Z79R112Q188L46S244L222T115C185G13P59H126C50I178C218X193D146O48C33L107N0R131C92C156H15Z2R173G164U43D87X49U142X48K3R194K86H180O93Z0Q65A21A106J210U123Y242U104J128C90C26X90P231J72B6J126H234S11F128H84D203E138H5Q156W223O154O47L41Z102A244Q67A253X196S195V144G90V30C229J84H92Z18Z240F104N226F105L53H95O35Y231N190O87P150R177Y182X47V92D206I191L12T210Z99A249J203K234T221J88Z94Y241B207D19T128Y111Q15O99S251S222U31I82A19M23B204X190X230J124D93T82S128J90N53U61M120E186G41D205X48G91M107K149U132H117O65A195U140K12H67X6P139Q129O131N198O9T71T70F221I67G40N14M211G61V179P217Z90J208M60Z170H183T255M111X55N82M163T137D11C7C145S141A84P74T80W144S198A82U42F82Z117M18G6C114G120I61P130O159Q198I109B160J200I100Y192R15W229L246D232Z160K199M26W29X204P192U213D5M67R66V</Result>
63
                    <Result name="connectorVersion">1.0.25</Result>
64
                    <Result name="ConnectorTxID1">8ac7a4a069d942db0169e4684fa52239</Result>
65
                    <Result name="connectorName">acon4-itau</Result>
66
                    <Result name="AcquirerResponse">000.000.000</Result>
67
                </ConnectorDetails>
68
                <ConnectorTxId>8ac7a4a069d942db0169e4684fa52239</ConnectorTxId>
69
            </Processing>
70
            <Recurrence mode="INITIAL" />
71
            <RequestTimestamp>2019-04-03 18:13:55</RequestTimestamp>
72
            <Analysis>
73
                <Criterion name="OPP_shopperResultUrl">http://loc/brazil_store_view/</Criterion>
74
                <Criterion name="SHOPPER_Publisher1">Produto1</Criterion>
75
                <Criterion name="OPP_cart.items[1].price">161.69</Criterion>
76
                <Criterion name="merchant_sitename">http://loc/brazil_store_view/</Criterion>
77
                <Criterion name="OPP_cart.items[1].type">Product</Criterion>
78
                <Criterion name="BRADESCO_instrucao1">Pedido6000000557-C\\u00f3digodedownload</Criterion>
79
                <Criterion name="BRADESCO_instrucao">https://store.com.br</Criterion>
80
                <Criterion name="CUSTOM_due_date">06/12/2018</Criterion>
81
                <Criterion name="OPP_cart.items[1].quantity">1</Criterion>
82
                <Criterion name="OPP_cart.items[1].currency">BRL</Criterion>
83
                <Criterion name="OPP_cart.items[1].merchantItemId">47</Criterion>
84
                <Criterion name="OPP_cart.items[1].originalPrice">161.69</Criterion>
85
                <Criterion name="BRADESCO_cpfsacado">012345678909</Criterion>
86
                <Criterion name="OPP_entityId">8a8294174e918ca6014e9c6e44672a96</Criterion>
87
                <Criterion name="OPP_paymentBrand">BOLETO</Criterion>
88
                <Criterion name="purchase_flow">INITIAL</Criterion>
89
                <Criterion name="MODEL_merchantSourceIp">177.102.143.190</Criterion>
90
            </Analysis>
91
        </Transaction>
92
    </Result>
93
</Response>
Copied!
1
<Response>
2
    <Result response="SYNC" count="1">