CustomerDonationSalesByCustomerId: Tixly Customer Donation Sales by Customer ID
read only REST
- Catalog:
Tixly - Schema:
Customer - Label: Customer Donation Sales by Customer ID
Fetches the donations from a specific customer
Can only retrieve data.
Summary
Fetches the donations from a specific customer
API Source
- Endpoint:
/customers/{id}/donations - Operation:
get /customers/{id}/donations
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | Id of the customer |
Table Columns
The columns of the table CustomerDonationSalesByCustomerId 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: