get https://secure.vend-o.com/api/reconciliation
Use this API to access your transactional data. Read the previous page for more details.
TABLE 61. RESPONSE FIELDS AND ATTRIBUTES.
| Column | Type (Length) | Description |
|---|---|---|
| header | ||
| siteIDs | integer | Site identifier |
| startDate | date | Start date |
| endDate | date | End date |
| transactionCount | integer | Total number of reported transactions for the request. |
| transaction | ||
| transactionID | integer | |
| dateTime | date time | Date and time of the transaction.Timezone: GMT Format: YYYY-MM-DD HH:MI:SS |
| type | integer | Transaction type: See, transaction types. |
| isNegative | integer | Defines whether money will be debited or credited to the content provider. (0 = no; 1 = yes) |
| isTest | integer | Defines if the transaction was a test-transaction. Test-transactions will not be credited to the content provider. 0 = no 1 = yes |
| siteID | integer | Vendo's site ID. |
| paymentMethodID | integer | Defines the payment method that was used with this transaction. |
| bin | integer | First 6 digits of a credit card. |
| lastFour | integer | Four last digits of a credit card. |
| expiryMonth | char (2) | Two digits number representing the expiration month of a credit card. Using a leading zero when needed e.g. '09'. |
| expiryYear | integer | Four digits number representing the expiration year of a credit card. |
| merchantReference | varchar (1024) | Custom data passed through a join link. |
| sellerAffiliateCode | varchar | Unique seller affiliate code for crossales. |
| originalTransactionID | integer | Vendo's unique transaction ID of an original transaction associated with a refund or chargeback. |
| programID | varchar | Program ID |
| campaignID | varchar | Campaign ID |
| affiliateID | varchar | Affiliate ID |
| reafundReason | varchar | Reason message for transactions of type refund |
| chargebackReason | varchar | Reason message for transactions of type chargeback |
| acquirerID | integer | Unique identifier of the Acquirer |
| acquirerName | varchar | Acquirer's name |
| status | int | The status of the transaction. 0 = Rejected, 1 = Successful |
| error_code | int | The error code of the rejection reason. |
| error_message | varchar | The description of the rejection reason. |
| invoice | ||
| amount | float unsigned | Amount the end user paid. |
| currency | varchar (3) | Currency of the end user's payment. |
| reporting | ||
| amount | float unsigned | Invoice amount converted to your preferred reporting currency. |
| amountGross | float unsigned | Reporting gross amount. |
| currency | varchar (3) | Your preferred reporting currency (Default USD). |
| taxRate | float (3) | Tax rate |
| displayed | ||
| amount | float unsigned | Amount displayed to the end-user. |
| currency | varchar (3) | Currency shown to the end-user. |
| offer | ||
| offerID | integer | Offer ID |
| TypeID | integer | Vendo Offer Type ID. |
| pricePointTypeID | integer | Price Point type ID |
| pricePointIdentifier | varchar | Price point ID |
| pricePointDuration | integer | Price Point Duration |
| pricePointDurationUnit | varchar | Price Point Duration Unit |
| pricePointAmount | float | Price Point Amount. |
| customer | ||
| customerID | integer | Customer ID |
| varchar | End user's email address. | |
| firstname | varchar | End user's first name. |
| lastname | varchar | End user's last name. |
| street | varchar | End user's street address. |
| zip | varchar | End user's postal code. |
| city | varchar | End user's city. |
| country | char(2) | End user's country. 2-letter ISO codes. |
| language | char (2) | End user's language. 2-letter ISO codes. |
| ip | varchar(39) | Customer's IP address |
| subscription | ||
| subscriptionID | integer | Subscription ID |
| username | varchar | End user's username. |
| password | varchar | End user's password. |
Error codes:
| Error | Code | Description |
|---|---|---|
| MANDATORY_PARAMETERS_MISSING | 0 | Mandatory parameters missing. |
| MERCHANTID_IS_INVALID | 5 | Merchant-ID is invalid. |
| AUTHTOKEN_IS_INVALID | 6 | AuthToken is incorrect. |
| ACCESS_DENIED | 9 | No permission to access API. Please contact Vendo: [email protected] |
| DATE_IS_INVALID | 1001 | Date-Format incorrect. Use YYYY-MM-DD |
| DATE_OUT_OF_RANGE | 1002 | Date out of range. |
| INVALID_MONTH | 1003 | Invalid month in date. |
| INVALID_DAY | 1004 | Invalid day in date. |
| ENDDATE_SMALLER_THAN_STARTDATE | 1005 | Startdate has to be smaller than enddate. |
| QUERY_EXCEEDS_TIMEFRAME | 1006 | Query exceeds max reporting timeframe. |
| REPORTS_AVAILABLE_UNTIL_TODAY | 1007 | Reports are only available up to "today's date". |
| INVALID_SITEIDS | 2001 | SiteIds contain non integer values. |
| ANAUTHORIZED_SITEIDS | 2002 | SiteIds contain unauthorized IDs. |
| UNAUTHORIZED_TRANSACTIONID | 2003 | TransactionId unauthorized. |
| UNKNOWN_ERROR | 9999 | Unknown error occurred. |