All_DataPermissionsEvents: Tixly itgen_tixly_all_datapermissionsevents_plural
read only REST
- Catalog:
Tixly - Schema:
Customer - Label: itgen_tixly_all_datapermissionsevents_plural
Fetches all customers you have access to. Pass in the DateFrom and DateTo query parameters to get customers that have been edited or created in a specific date range. Adding and removing customer tags count als editing, adding or removing permissions does not.
Can only retrieve data.
Summary
Fetches all customers you have access to. Pass in the DateFrom and DateTo query parameters to get customers that have been edited or created in a specific date range. Adding and removing customer tags count als editing, adding or removing permissions does not.
API Source
- Endpoint:
/customers - Operation:
get /customers
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
Date |
`` | Created/Edited customer from | ||
DateTo |
`` | Created/Edited customer to |
Table Columns
The columns of the table All_DataPermissionsEvents 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, ::ancestor. |
||
Created |
int64 |
itgen_tixly_createdutcunix | writable, ::ancestor. |
||
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, ::ancestor. |
||
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, ::ancestor. |
||
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, ::ancestor. |
||
Name |
varchar2 |
Name | writable, ::ancestor. |
||
Name_2 |
varchar2 |
itgen_tixly_name_2 | filters on the platform, writable, ::ancestor. |
||
Post |
char |
itgen_tixly_postpermission | writable, ::ancestor. |
||
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, ::ancestor. |
||
Type |
varchar2 |
Type Name | writable, ::ancestor. |
||
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: