GetWalletTransHistory: Get List of All Wallet Transactions

Version

Description

1.1Input: new search parameter: transactionMerchantToken, which is wkToken use for MoneyInWebInit

1.2

Output: new value for STATUS

1.3

Output: new EXTRA value with more card data information

1.4

Output: new INT_MSG value with error codes and messages from Lemonway

1.5

Output: authorization number added to existing EXTRA values

1.6

Output: MLABEL with IBAN when Money-in by iDEAL or SDD

1.7

Output: TYPE will tell you if it's a money-in, a money-out or a payment between wallets

1.8

Output: partner token

2.0

Output: METHOD of payment in output

2.1Output: Refund amount

How it works

Use GetWalletTransHistory to retrieve the list of money-in, money-out, and p2p (payment between payment account) of a given payment account.

New Alternative

Please consider using the following functions which are more efficient because they accept a list of wallets (along with other filters), so they can return transactions of several wallets at the same time:

XML

<GetWalletTransHistory xmlns="Service_mb">
  <wlLogin>string</wlLogin>
  <wlPass>string</wlPass>
  <language>string</language>
  <version>string</version>
  <walletIp>string</walletIp>
  <walletUa>string</walletUa>
  <wallet>string</wallet>
  <startDate>string</startDate>
  <endDate>string</endDate>  
  <executionStartDate>string</executionStartDate>
  <executionEndDate>string</executionEndDate>
</GetWalletTransHistory>

JSON

{   
    "wlLogin":"string",
    "wlPass":"string",
    "language":"string",
    "version":"string",
    "walletIp":"string",
    "walletUa":"string",
    "wallet":"string",
    "startDate":"string",
    "endDate":"string",
    "executionStartDate":"string",
    "executionEndDate":"string"
} 

Request


Item

Description

Mandatory

Format

Example

wallet

Identifier of the payment account

Yes

[1:256] chars

Pizza75

startDate

Date in UTC seconds, in order to return transactions initialized after startDate.
If the payment account is "SC" then this value is mandatory. 

No

[0 :10] int

1373448225

endDate

Date in UTC seconds, in order to return transactions initialized before endDate.
If the payment account is "SC" then this value is mandatory and the time span cannot exceed 1 week.

No

[0 :10] int

1373448225

executionStartDateDate in UTC seconds, in order to return transactions executed after startDate.No[0 :10] int1373448225
executionEndDateDate in UTC seconds, in order to return transactions executed before endDate.No[0 :10] int1373448225

Response


XML

<?xml version="1.0" encoding="utf-8"?>
<TRANS>
	<HPAY>
		<ID>string</ID>
		<DATE> string </DATE>
		<SEN> string </SEN>
		<REC> string </REC>
		<DEB> string </DEB>
		<CRED> string </CRED>
		<COM> string </COM>
		<MSG> string </MSG>
		<STATUS> string</STATUS>
		<INT_STATUS> string</INT_STATUS>
		<EXTRA> <!--since version 1.3 -->
			<IS3DS>string</IS3DS>
			<CTRY>string</CTRY>
			<AUTH>string</AUTH> <!--since version 1.5 -->
		</EXTRA>
		<INT_MSG>string</INT_MSG>
		<MLABEL>string</MLABEL><!--since version 1.6 -->
		<TYPE>string</TYPE><!--since version 1.7 -->
		<ACHIEVEMENT_DATE>string</ACHIEVEMENT_DATE>
		<PRIVATE_DATA>string</PRIVATE_DATA>
		<SCHEDULED_DATE>string</SCHEDULED_DATE>
		<MTOKEN>string</MTOKEN>
		<METHOD>string</METHOD>
		<REFUND>string</REFUND><!--since version 2.1 -->
	</HPAY>
	...
	<HPAY>
		...
	</HPAY>
</TRANS>

JSON

{
  "TRANS": {
    "HPAY": [
      {
        "ID": "string",
        "DATE": " string ",
        "SEN": " string ",
        "REC": " string ",
        "DEB": " string ",
        "CRED": " string ",
        "COM": " string ",
        "MSG": " string ",
        "STATUS": " string",
        "INT_STATUS": " string",
        "EXTRA": {
          "IS3DS": "string",
          "CTRY": "string",
          "AUTH": "string"
        },
        "INT_MSG": "string",
        "MLABEL": "string",
        "TYPE": "string",
        "ACHIEVEMENT_DATE":"string",
        "PRIVATE_DATA": "string",
        "SCHEDULED_DATE": "string",
        "MTOKEN": "string",
        "METHOD": "string",
        "REFUND":"string"<!--since version 2.1 -->
      },
      ...
    ]
  }
} 

Version

Item

Description

Example

>= 1.0

HPAY

Transaction block


>= 1.0

ID

Transaction ID

Warning: a p2p transaction can have the same ID as a money-in or a money-out

255

>= 1.0

DATE

Transaction creation date

10/09/2011 18:09:27

>= 1.0

SEN

Debited payment account.
Empty if it's a money-in


>= 1.0

REC

Credited payment account.
Empty if it's a money-out

pizza

>= 1.0

DEB

Amount to debit from the debited payment account.

  • if money-in: 0
  • if money-out: total, your fees included
  • if p2p: amount of the p2p

0.00

>= 1.0

CRED

Amount to credit to the credited wallet.

  • if money-in: total less your fees
  • if money-out: 0
  • if p2p: amount of the p2p

15.00

>= 1.0

COM

Partner commission. Always 0 when the money-in is a fund transfer

2.00

>= 1.0

MSG

Comment
(For Bank Transfers, comment includes the customer name when banks provide it + the comment entered by the customer during wire transfer order. Contact Support to turn on/off "Debtor Name" & "Comment" parsing). 

Order number 245776

>= 1.0

STATUS (deprecated, use INT_STATUS instead)

3: transaction successful
4: error
0: waiting for finalization (since version 1.2)
16: Reservation made successfully, awaiting validation (only with differed card payments)

3

>= 1.0

PRIVATE_DATA

For a p2p transaction only, and only if you created the transaction with a privateData

a;b;c;d;e;f;g;h;i;j;;;;;;;;;;

>= 1.0

SCHEDULED_DATE

  • Scheduled execution date for a p2p transaction, if you created the transaction with a scheduledDate
    Or
  • Scheduled execution date for a money-in by SDD, if you gave a collection date

2015/12/31

>= 1.3

EXTRA

Optional card info


>= 1.3

EXTRA.IS3DS

3DS authentication:

  • 0 if No
  • 1 if Yes

1

>= 1.3

EXTRA.CTRY

Country that emitted the card

FRA

>= 1.4

INT_MSG

error codes and messages from Lemonway

05-00-05 ERR_PSP_REFUSED

>= 1.5

EXTRA.AUTH

Authorization number

455622

>= 1.6

MLABEL

IBAN or masked card number


>= 1.7

TYPE

0: money-in
1: money-out
2: p2p (payment between 2 wallets)

1

>= 1.8

MTOKEN

wkToken is given by the partner when the money-in was created


>=2.0

METHOD

For money-in and money-out operations:
0: bank card
1: incoming wire transfer
3: outgoing wire transfer
13: iDeal
14: Sepa Direct Debit
15: Cheques
16: Neosurf card

0

>=2.1REFUNDRefund amount15.00
>= 2.2INT_STATUS

0: success
4: pending
6: error
7: canceled (by customer or time out)
16: wait for validation / finalization

0
>= 2.7ACHIEVEMENT_DATEIndicates the execution date10/09/2011 19:04:13