invantive documentation
Invantive Support ForumsLog In / Sign Up

SoldProducts: Tixly Sold Products

read only REST

  • Catalog: Tixly
  • Schema: Product
  • Label: Sold Products

Get all the sold products. Pass in the SoldFrom and SoldTo parameters to get sales within a specific date range

Can only retrieve data.

Summary

Get all the sold products. Pass in the SoldFrom and SoldTo parameters to get sales within a specific date range

API Source

  • Endpoint: /products/sales
  • Operation: get /products/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 SoldProducts 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
Barcode varchar2 itgen_tixly_barcode filters on the platform, writable, Barcode
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
EventId int32 Event ID filters on the platform, writable, EventId
Online char Online filters on the platform, writable, Online
OrderId int32 Order ID filters on the platform, writable, OrderId
OrderProductId int32 itgen_tixly_orderproductid filters on the platform, writable, OrderProductId
OrderUrl varchar2 itgen_tixly_orderurl filters on the platform, writable, OrderUrl
OrganisationID int32 Organisation ID filters on the platform, writable, OrganisationID
Price double Price filters on the platform, writable, Price
ProductCount int32 Product Count filters on the platform, writable, ProductCount
ProductId int32 Product ID filters on the platform, writable, ProductId
ProductName varchar2 itgen_tixly_productname filters on the platform, writable, ProductName
ProductVariantId int32 itgen_tixly_productvariantid filters on the platform, writable, ProductVariantId
SaleProductId int32 itgen_tixly_saleproductid filters on the platform, writable, SaleProductId
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: