Donations: Tixly Donations
read only REST
- Catalog:
Tixly - Schema:
Donation - Label: Donations
Fetches all donatons that you have access to, pass in the SoldFrom and SoldTo to get only donations sold in a specific date range. Please read the model description as some properties will be removed on the 1st of September 2025
Can only retrieve data.
Summary
Fetches all donatons that you have access to, pass in the SoldFrom and SoldTo to get only donations sold in a specific date range. Please read the model description as some properties will be removed on the 1st of September 2025
API Source
- Endpoint:
/donations/sales - Operation:
get /donations/sales
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
Sold |
`` | If this is set, then only get sales after this date | ||
SoldTo |
`` | If this is set, then only get sales before this date |
Table Columns
The columns of the table Donations are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Abbreviation |
varchar2 |
Abbreviation | filters on the platform, writable, Abbreviation |
The abbreviation of the memberhip/donation | |
Created |
datetime |
Created | filters on the platform, writable, Created |
The date and time when the membership/donation was sold | |
Created |
int64 |
itgen_tixly_createdutcunix | filters on the platform, writable, Created |
The date and time in Unix time (also known as POSIX time or Epoch time) when the membership/donation was sold | |
Customer |
int32 |
Customer ID | filters on the platform, writable, Customer |
The id of the customer | |
Description |
varchar2 |
Description | filters on the platform, writable, Description |
Always an empty string, will be removed from future relesase | |
Expires |
datetime |
Expires | filters on the platform, writable, Expires |
The date and time when the membership/donation expires | |
Expires |
int64 |
itgen_tixly_expiresutcunix | filters on the platform, writable, Expires |
The date and time in Unix time (also known as POSIX time or Epoch time) when the membership/donation expires | |
Id |
int32 |
ID | filters on the platform, writable, Id |
A unique id for each transaction row of membership/donation sales Will be removed from future releases as SaleMembershipId is the same, please use that | |
Is |
char |
Is Anonymous Sale | filters on the platform, writable, Is |
Is the sale made without a customer | |
Is |
char |
itgen_tixly_iscancelled_2 | filters on the platform, writable, Is |
Is the membership cancelled (deleted) or not Was originally created with lower caps first letter | |
Membership |
int32 |
itgen_tixly_membershipcount | filters on the platform, writable, Membership |
Total memberships/donations sold, can either be 1 or -1 | |
Membership |
int32 |
Membership ID | filters on the platform, writable, Membership |
Will be removed from future releases, Id should not both be upper case kept it for backward compatibility and use MembershipId | |
Membership |
int32 |
itgen_tixly_membershipid_2 | filters on the platform, writable, Membership |
The id of the membership/donation sold | |
Membership |
int32 |
itgen_tixly_membershiporganisationid | filters on the platform, writable, Membership |
The organisation that owns the membership/donation | |
Name |
varchar2 |
Name | filters on the platform, writable, Name |
The name of the memberhip/donation | |
Online |
char |
Online | filters on the platform, writable, Online |
Was the membership/donation sold online | |
Order |
int32 |
Order ID | filters on the platform, writable, Order |
The id of the Order | |
Order |
int32 |
itgen_tixly_ordermembershipid | filters on the platform, writable, Order |
A unique id for each order line for a specific membership | |
Order |
varchar2 |
itgen_tixly_orderurl | filters on the platform, writable, Order |
The encrypted order id to be used in url's to create a purchase link for reservations or a receipt link for sales | |
Organisation |
int32 |
Organisation ID | filters on the platform, writable, Organisation |
Will be removed from future releases, Id should not both be upper case kept it for backward compatibility - use SaleOrganisationId instead | |
Price |
double |
Price | filters on the platform, writable, Price |
The price of the membership/donation | |
Renew |
int32 |
Renew Day of Month | filters on the platform, writable, Renew |
What day of the month does it renew | |
Renew |
int32 |
Renew Month of Year | filters on the platform, writable, Renew |
What month of the year does it renew | |
Renewal |
varchar2 |
Renewal Type | filters on the platform, writable, Renewal |
What is the type of renewal | |
Sale |
int32 |
itgen_tixly_salemembershipid | filters on the platform, writable, Sale |
A unique id for each transaction row of membership/donation sales | |
Sale |
int32 |
itgen_tixly_saleorganisationid | filters on the platform, writable, Sale |
The organisation that sold the membership/donation | |
Sale |
int32 |
itgen_tixly_saleuserid | filters on the platform, writable, Sale |
The user id of the user that sold | |
Sale |
varchar2 |
itgen_tixly_saleusername | filters on the platform, writable, Sale |
The full name of the user that sold | |
Short |
varchar2 |
Short Description | filters on the platform, writable, Short |
Always an empty string, will be removed from future relesase | |
SkinID |
int32 |
Skin ID | filters on the platform, writable, SkinID |
Will be removed from future releases, Id should not both be upper case kept it for backward compatibility and use SkinId instead | |
Skin |
int32 |
itgen_tixly_skinid_2 | filters on the platform, writable, SkinId |
The id of the skin sold it was sold in | |
Tagline |
varchar2 |
Tagline | filters on the platform, writable, Tagline |
Always an empty string, will be removed from future relesase | |
Vat |
double |
VAT | filters on the platform, writable, Vat |
The vat amount of the membership/donation | |
is |
char |
Is Cancelled | filters on the platform, writable, is |
For backwards compatibility, will be removed from future releases and use IsCancelled instead |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: