invantive documentation
Invantive Support ForumsLog In / Sign Up

CustomerProductSalesByCustomerId: Tixly Customer Product Sales by Customer ID

read only REST

  • Catalog: Tixly
  • Schema: Customer
  • Label: Customer Product Sales by Customer ID

Fetches the products a specific customer has at this moment. It does not include returned or reserved products.

Can only retrieve data.

Summary

Fetches the products a specific customer has at this moment. It does not include returned or reserved products.

API Source

  • Endpoint: /customers/{id}/products
  • Operation: get /customers/{id}/products

Parameters

Name Data Type Required Default Documentation
id `` Id of the customer

Table Columns

The columns of the table CustomerProductSalesByCustomerId 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: