invantive documentation
Invantive Support ForumsLog In / Sign Up

GiftCardRange: Tixly Gift Card Range

read only REST

  • Catalog: Tixly
  • Schema: Giftcard
  • Label: Gift Card Range

Fetches all giftcard sales, pass in the SoldFrom and SoldTo query parameters to get giftcards from a specific daterange

Can only retrieve data.

Summary

Fetches all giftcard sales, pass in the SoldFrom and SoldTo query parameters to get giftcards from a specific daterange

API Source

  • Endpoint: /giftcards/sales
  • Operation: get /giftcards/sales

Parameters

Name Data Type 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

Table Columns

The columns of the table GiftCardRange 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
Amount double Amount filters on the platform, writable, Amount
AmountLeft double Amount Left filters on the platform, writable, AmountLeft
AmountUsed double Amount Used filters on the platform, writable, AmountUsed
Created datetime Created filters on the platform, writable, Created
CreatedUTCUnix int64 itgen_tixly_createdutcunix filters on the platform, writable, CreatedUTCUnix
CustomerId int32 Customer ID filters on the platform, writable, CustomerId
Expires datetime Expires filters on the platform, writable, Expires
ExpiresUTCUnix int64 itgen_tixly_expiresutcunix filters on the platform, writable, ExpiresUTCUnix
GiftCardCount int32 Giftcard Count filters on the platform, writable, GiftCardCount
GiftCardGroupID int32 itgen_tixly_giftcardgroupid filters on the platform, writable, GiftCardGroupID
GiftCardGroupName varchar2 itgen_tixly_giftcardgroupname filters on the platform, writable, GiftCardGroupName
GiftCardId int32 itgen_tixly_giftcardid filters on the platform, writable, GiftCardId
Number varchar2 Number filters on the platform, writable, Number
Online char Online filters on the platform, writable, Online
OrderId int32 Order ID filters on the platform, writable, OrderId
OrderUrl varchar2 itgen_tixly_orderurl filters on the platform, writable, OrderUrl
OrganisationID int32 Organisation ID filters on the platform, writable, OrganisationID
Pin varchar2 PIN filters on the platform, writable, Pin
Price double Price filters on the platform, writable, Price
SaleGiftCardID int32 itgen_tixly_salegiftcardid filters on the platform, writable, SaleGiftCardID
SkinID int32 Skin ID filters on the platform, writable, SkinID

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: