invantive documentation
Invantive Support ForumsLog In / Sign Up

Sale_AllSales: Tixly itgen_tixly_sale_allsales_plural

read only REST

  • Catalog: Tixly
  • Schema: Sale
  • Label: itgen_tixly_sale_allsales_plural

Fetches all the sales that you have access to, pass in the SoldFrom and SoldTo to get sales sold within a specific date range

Can only retrieve data.

Summary

Fetches all the sales that you have access to, pass in the SoldFrom and SoldTo to get sales sold within a specific date range

API Source

  • Endpoint: /sales
  • Operation: get /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 Sale_AllSales 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
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
DeliveryTypeId int32 itgen_tixly_deliverytypeid filters on the platform, writable, DeliveryTypeId
DeliveryTypeName varchar2 itgen_tixly_deliverytypename filters on the platform, writable, DeliveryTypeName
Description varchar2 Description filters on the platform, writable, Description
Edited datetime Edited filters on the platform, writable, Edited
EditedUTCUnix int64 itgen_tixly_editedutcunix filters on the platform, writable, EditedUTCUnix
Online char Online filters on the platform, writable, Online
OrderAmount double itgen_tixly_orderamount filters on the platform, writable, OrderAmount
OrderCreated datetime itgen_tixly_ordercreated filters on the platform, writable, OrderCreated
OrderCreatedUTCUnix int64 itgen_tixly_ordercreatedutcunix filters on the platform, writable, OrderCreatedUTCUnix
OrderId int32 Order ID filters on the platform, writable, OrderId
OrderType int32 itgen_tixly_ordertype filters on the platform, writable, OrderType
OrderUrl varchar2 itgen_tixly_orderurl filters on the platform, writable, OrderUrl
OrderUserId int32 itgen_tixly_orderuserid filters on the platform, writable, OrderUserId
OrderUserName varchar2 itgen_tixly_orderusername filters on the platform, writable, OrderUserName
SaleOrganisationId int32 itgen_tixly_saleorganisationid filters on the platform, writable, SaleOrganisationId
SaleType int32 itgen_tixly_saletype filters on the platform, writable, SaleType
SaleUserId int32 itgen_tixly_saleuserid filters on the platform, writable, SaleUserId
SaleUserName varchar2 itgen_tixly_saleusername filters on the platform, writable, SaleUserName
WorkGroupId int32 itgen_tixly_workgroupid filters on the platform, writable, WorkGroupId

Release Notes

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