CustomerDonationSalesByCustomerId: Tixly Customer Donation Sales by Customer ID
read only REST
- Catalogo:
Tixly - Schema:
Customer - Label: Customer Donation Sales by Customer ID
Fetches the donations from a specific customer
È possibile solo recuperare i dati.
Riepilogo
Fetches the donations from a specific customer
Codice sorgente dell'API
- Punto finale:
/customers/{id}/donations - Operazione:
get /customers/{id}/donations
Parametri
| Name | Tipo di dati | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | Id of the customer |
Colonne della tabella
Di seguito sono riportate le colonne della tabella CustomerDonationSalesByCustomerId. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Abbreviation |
varchar2 |
Abbreviation | filtri sulla piattaforma, modificabili, Abbreviation |
The abbreviation of the memberhip/donation | |
Created |
datetime |
Created | filtri sulla piattaforma, modificabili, Created |
The date and time when the membership/donation was sold | |
Created |
int64 |
itgen_tixly_createdutcunix | filtri sulla piattaforma, modificabili, Created |
The date and time in Unix time (also known as POSIX time or Epoch time) when the membership/donation was sold | |
Customer |
int32 |
ID cliente | filtri sulla piattaforma, modificabili, Customer |
The id of the customer | |
Description |
varchar2 |
Description | filtri sulla piattaforma, modificabili, Description |
Always an empty string, will be removed from future relesase | |
Expires |
datetime |
Expires | filtri sulla piattaforma, modificabili, Expires |
The date and time when the membership/donation expires | |
Expires |
int64 |
itgen_tixly_expiresutcunix | filtri sulla piattaforma, modificabili, Expires |
The date and time in Unix time (also known as POSIX time or Epoch time) when the membership/donation expires | |
Id |
int32 |
ID | filtri sulla piattaforma, modificabili, 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 |
Si tratta di una vendita anonima | filtri sulla piattaforma, modificabili, Is |
Is the sale made without a customer | |
Is |
char |
itgen_tixly_iscancelled_2 | filtri sulla piattaforma, modificabili, Is |
Is the membership cancelled (deleted) or not Was originally created with lower caps first letter | |
Membership |
int32 |
itgen_tixly_membershipcount | filtri sulla piattaforma, modificabili, Membership |
Total memberships/donations sold, can either be 1 or -1 | |
Membership |
int32 |
Codice socio | filtri sulla piattaforma, modificabili, 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 | filtri sulla piattaforma, modificabili, Membership |
The id of the membership/donation sold | |
Membership |
int32 |
itgen_tixly_membershiporganisationid | filtri sulla piattaforma, modificabili, Membership |
The organisation that owns the membership/donation | |
Name |
varchar2 |
Name | filtri sulla piattaforma, modificabili, Name |
The name of the memberhip/donation | |
Online |
char |
Online | filtri sulla piattaforma, modificabili, Online |
Was the membership/donation sold online | |
Order |
int32 |
ID dell'ordine | filtri sulla piattaforma, modificabili, Order |
The id of the Order | |
Order |
int32 |
itgen_tixly_ordermembershipid | filtri sulla piattaforma, modificabili, Order |
A unique id for each order line for a specific membership | |
Order |
varchar2 |
itgen_tixly_orderurl | filtri sulla piattaforma, modificabili, 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 |
ID dell'organizzazione | filtri sulla piattaforma, modificabili, 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 | filtri sulla piattaforma, modificabili, Price |
The price of the membership/donation | |
Renew |
int32 |
Giorno del mese di rinnovo | filtri sulla piattaforma, modificabili, Renew |
What day of the month does it renew | |
Renew |
int32 |
Mese e anno di rinnovo | filtri sulla piattaforma, modificabili, Renew |
What month of the year does it renew | |
Renewal |
varchar2 |
Tipo di rinnovo | filtri sulla piattaforma, modificabili, Renewal |
What is the type of renewal | |
Sale |
int32 |
itgen_tixly_salemembershipid | filtri sulla piattaforma, modificabili, Sale |
A unique id for each transaction row of membership/donation sales | |
Sale |
int32 |
itgen_tixly_saleorganisationid | filtri sulla piattaforma, modificabili, Sale |
The organisation that sold the membership/donation | |
Sale |
int32 |
itgen_tixly_saleuserid | filtri sulla piattaforma, modificabili, Sale |
The user id of the user that sold | |
Sale |
varchar2 |
itgen_tixly_saleusername | filtri sulla piattaforma, modificabili, Sale |
The full name of the user that sold | |
Short |
varchar2 |
Descrizione breve | filtri sulla piattaforma, modificabili, Short |
Always an empty string, will be removed from future relesase | |
SkinID |
int32 |
Skin ID | filtri sulla piattaforma, modificabili, 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 | filtri sulla piattaforma, modificabili, SkinId |
The id of the skin sold it was sold in | |
Tagline |
varchar2 |
Tagline | filtri sulla piattaforma, modificabili, Tagline |
Always an empty string, will be removed from future relesase | |
Vat |
double |
VAT | filtri sulla piattaforma, modificabili, Vat |
The vat amount of the membership/donation | |
is |
char |
È stato annullato | filtri sulla piattaforma, modificabili, is |
For backwards compatibility, will be removed from future releases and use IsCancelled instead |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: