SaleRange_DataPermissions: Tixly itgen_tixly_salerange_datapermissions_plural
read only REST
- Catalog:
Tixly - Schema:
Customer - Label: itgen_tixly_salerange_datapermissions_plural
Fetches customers by sale range, which means if the customer buys or is refunded an order in the date range it will be included. This endpoint is good to use if you are fetching from other endpoints by a specific date range, that can be matched in this endpoint to link the data.
Can only retrieve data.
Summary
Fetches customers by sale range, which means if the customer buys or is refunded an order in the date range it will be included. This endpoint is good to use if you are fetching from other endpoints by a specific date range, that can be matched in this endpoint to link the data.
API Source
- Endpoint:
/customers/sales - Operation:
get /customers/sales
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
Date |
`` | Created sale from | ||
DateTo |
`` | Created sale to |
Table Columns
The columns of the table SaleRange_DataPermissions 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 |
|---|---|---|---|---|---|
Academic |
varchar2 |
itgen_tixly_academicsuffix | filters on the platform, writable, ::ancestor. |
||
Academic |
varchar2 |
itgen_tixly_academictitle | filters on the platform, writable, ::ancestor. |
||
Address |
varchar2 |
Address One | filters on the platform, writable, ::ancestor. |
||
Address |
varchar2 |
Address Two | filters on the platform, writable, ::ancestor. |
||
Alternative |
varchar2 |
Alternative Email Addresses | filters on the platform, writable, ::ancestor. |
||
CRN |
varchar2 |
CRN | filters on the platform, writable, ::ancestor. |
||
City |
varchar2 |
City | filters on the platform, writable, ::ancestor. |
||
Company |
varchar2 |
Company Name | filters on the platform, writable, ::ancestor. |
||
Country |
varchar2 |
Country | filters on the platform, writable, ::ancestor. |
||
Country |
varchar2 |
Country Code | filters on the platform, writable, ::ancestor. |
||
Created |
datetime |
Created | writable, Created |
||
Created |
int64 |
itgen_tixly_createdutcunix | writable, Created |
||
Created |
int64 |
itgen_tixly_createdutcunix_2 | filters on the platform, writable, ::ancestor. |
||
Created_ |
datetime |
itgen_tixly_created_2 | filters on the platform, writable, ::ancestor. |
||
Date |
datetime |
Date of Birth | filters on the platform, writable, ::ancestor. |
||
Date |
int64 |
itgen_tixly_dateofbirthutcunix | filters on the platform, writable, ::ancestor. |
||
Deleted |
datetime |
Deleted Date | filters on the platform, writable, ::ancestor. |
||
Deleted |
int64 |
itgen_tixly_deleteddateutcunix | filters on the platform, writable, ::ancestor. |
||
Description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
||
Disallow |
char |
Disallow Merge | filters on the platform, writable, ::ancestor. |
||
Edited |
datetime |
Edited | filters on the platform, writable, ::ancestor. |
||
Edited |
int64 |
itgen_tixly_editedutcunix | filters on the platform, writable, ::ancestor. |
||
Email |
varchar2 |
filters on the platform, writable, ::ancestor. |
|||
Email |
char |
Email Permission | writable, Email |
||
First |
varchar2 |
First Name | filters on the platform, writable, ::ancestor. |
||
Gender |
int32 |
Gender | filters on the platform, writable, ::ancestor. |
||
Home |
varchar2 |
Home Phone | filters on the platform, writable, ::ancestor. |
||
House |
varchar2 |
House Extension | filters on the platform, writable, ::ancestor. |
||
House |
varchar2 |
House Number | filters on the platform, writable, ::ancestor. |
||
Id |
int32 |
ID | writable, Id |
||
Id_2 |
int32 |
itgen_tixly_id_2 | filters on the platform, writable, ::ancestor. |
||
Initials |
varchar2 |
Initials | filters on the platform, writable, ::ancestor. |
||
Is |
char |
Is Anonymized | filters on the platform, writable, ::ancestor. |
||
Is |
char |
Is Deleted | filters on the platform, writable, ::ancestor. |
||
Language |
int32 |
Language ID | filters on the platform, writable, ::ancestor. |
||
Last |
varchar2 |
Last Name | filters on the platform, writable, ::ancestor. |
||
Last |
varchar2 |
Last Name Prefix | filters on the platform, writable, ::ancestor. |
||
Latitude |
double |
Latitude | filters on the platform, writable, ::ancestor. |
||
Longitude |
double |
Longitude | filters on the platform, writable, ::ancestor. |
||
Mobile |
varchar2 |
Mobile | filters on the platform, writable, ::ancestor. |
||
Mobile |
char |
Mobile Permission | writable, Mobile |
||
Name |
varchar2 |
Name | writable, Name |
||
Name_2 |
varchar2 |
itgen_tixly_name_2 | filters on the platform, writable, ::ancestor. |
||
Post |
char |
itgen_tixly_postpermission | writable, Post |
||
SSN |
varchar2 |
SSN | filters on the platform, writable, ::ancestor. |
||
Street |
varchar2 |
Street Name | filters on the platform, writable, ::ancestor. |
||
Title |
varchar2 |
Title | filters on the platform, writable, ::ancestor. |
||
Type |
int32 |
Type | writable, Type |
||
Type |
varchar2 |
Type Name | writable, Type |
||
Work |
varchar2 |
Work Phone | filters on the platform, writable, ::ancestor. |
||
Zip |
varchar2 |
ZIP-code | filters on the platform, writable, ::ancestor. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: