invantive documentation
Invantive Support ForumsLog In / Sign Up

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
CreatedUTCUnix int64 itgen_tixly_createdutcunix filters on the platform, writable, CreatedUTCUnix The date and time in Unix time (also known as POSIX time or Epoch time) when the membership/donation was sold
CustomerId int32 Customer ID filters on the platform, writable, CustomerId 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
ExpiresUTCUnix int64 itgen_tixly_expiresutcunix filters on the platform, writable, ExpiresUTCUnix 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
IsAnonymousSale char Is Anonymous Sale filters on the platform, writable, IsAnonymousSale Is the sale made without a customer
IsCancelled_2 char itgen_tixly_iscancelled_2 filters on the platform, writable, IsCancelled Is the membership cancelled (deleted) or not Was originally created with lower caps first letter
MembershipCount int32 itgen_tixly_membershipcount filters on the platform, writable, MembershipCount Total memberships/donations sold, can either be 1 or -1
MembershipID int32 Membership ID filters on the platform, writable, 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 filters on the platform, writable, MembershipId The id of the membership/donation sold
MembershipOrganisationId int32 itgen_tixly_membershiporganisationid filters on the platform, writable, MembershipOrganisationId 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
OrderId int32 Order ID filters on the platform, writable, OrderId The id of the Order
OrderMembershipId int32 itgen_tixly_ordermembershipid filters on the platform, writable, OrderMembershipId A unique id for each order line for a specific membership
OrderUrl varchar2 itgen_tixly_orderurl filters on the platform, writable, 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 Organisation ID filters on the platform, writable, 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 filters on the platform, writable, Price The price of the membership/donation
RenewDayOfMonth int32 Renew Day of Month filters on the platform, writable, RenewDayOfMonth What day of the month does it renew
RenewMonthOfYear int32 Renew Month of Year filters on the platform, writable, RenewMonthOfYear What month of the year does it renew
RenewalType varchar2 Renewal Type filters on the platform, writable, RenewalType What is the type of renewal
SaleMembershipId int32 itgen_tixly_salemembershipid filters on the platform, writable, SaleMembershipId A unique id for each transaction row of membership/donation sales
SaleOrganisationId int32 itgen_tixly_saleorganisationid filters on the platform, writable, SaleOrganisationId The organisation that sold the membership/donation
SaleUserId int32 itgen_tixly_saleuserid filters on the platform, writable, SaleUserId The user id of the user that sold
SaleUserName varchar2 itgen_tixly_saleusername filters on the platform, writable, SaleUserName The full name of the user that sold
ShortDescription varchar2 Short Description filters on the platform, writable, ShortDescription 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
SkinId_2 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
isCancelled char Is Cancelled filters on the platform, writable, isCancelled 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: