invantive documentation
Forum di supporto InvantiveAccedi / Registrati

Donations: Tixly Donations

read only REST

  • Catalogo: 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

È possibile solo recuperare i dati.

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

Codice sorgente dell'API

  • Punto finale: /donations/sales
  • Operazione: get /donations/sales

Parametri

Name Tipo di dati Required Default Documentation
SoldFrom `` If this is set, then only get sales after this date
SoldTo `` If this is set, then only get sales before this date

Colonne della tabella

Di seguito sono riportate le colonne della tabella Donations. 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
CreatedUTCUnix int64 itgen_tixly_createdutcunix filtri sulla piattaforma, modificabili, CreatedUTCUnix The date and time in Unix time (also known as POSIX time or Epoch time) when the membership/donation was sold
CustomerId int32 ID cliente filtri sulla piattaforma, modificabili, CustomerId 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
ExpiresUTCUnix int64 itgen_tixly_expiresutcunix filtri sulla piattaforma, modificabili, ExpiresUTCUnix 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
IsAnonymousSale char Si tratta di una vendita anonima filtri sulla piattaforma, modificabili, IsAnonymousSale Is the sale made without a customer
IsCancelled_2 char itgen_tixly_iscancelled_2 filtri sulla piattaforma, modificabili, IsCancelled Is the membership cancelled (deleted) or not Was originally created with lower caps first letter
MembershipCount int32 itgen_tixly_membershipcount filtri sulla piattaforma, modificabili, MembershipCount Total memberships/donations sold, can either be 1 or -1
MembershipID int32 Codice socio filtri sulla piattaforma, modificabili, MembershipID Will be removed from future releases, Id should not both be upper case kept it for backward compatibility and use MembershipId
MembershipId_2 int32 itgen_tixly_membershipid_2 filtri sulla piattaforma, modificabili, MembershipId The id of the membership/donation sold
MembershipOrganisationId int32 itgen_tixly_membershiporganisationid filtri sulla piattaforma, modificabili, MembershipOrganisationId 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
OrderId int32 ID dell'ordine filtri sulla piattaforma, modificabili, OrderId The id of the Order
OrderMembershipId int32 itgen_tixly_ordermembershipid filtri sulla piattaforma, modificabili, OrderMembershipId A unique id for each order line for a specific membership
OrderUrl varchar2 itgen_tixly_orderurl filtri sulla piattaforma, modificabili, OrderUrl The encrypted order id to be used in url's to create a purchase link for reservations or a receipt link for sales
OrganisationID int32 ID dell'organizzazione filtri sulla piattaforma, modificabili, OrganisationID 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
RenewDayOfMonth int32 Giorno del mese di rinnovo filtri sulla piattaforma, modificabili, RenewDayOfMonth What day of the month does it renew
RenewMonthOfYear int32 Mese e anno di rinnovo filtri sulla piattaforma, modificabili, RenewMonthOfYear What month of the year does it renew
RenewalType varchar2 Tipo di rinnovo filtri sulla piattaforma, modificabili, RenewalType What is the type of renewal
SaleMembershipId int32 itgen_tixly_salemembershipid filtri sulla piattaforma, modificabili, SaleMembershipId A unique id for each transaction row of membership/donation sales
SaleOrganisationId int32 itgen_tixly_saleorganisationid filtri sulla piattaforma, modificabili, SaleOrganisationId The organisation that sold the membership/donation
SaleUserId int32 itgen_tixly_saleuserid filtri sulla piattaforma, modificabili, SaleUserId The user id of the user that sold
SaleUserName varchar2 itgen_tixly_saleusername filtri sulla piattaforma, modificabili, SaleUserName The full name of the user that sold
ShortDescription varchar2 Descrizione breve filtri sulla piattaforma, modificabili, ShortDescription 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
SkinId_2 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
isCancelled char È stato annullato filtri sulla piattaforma, modificabili, isCancelled 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: