CustomerById_Metadata: Tixly itgen_tixly_customerbyid_metadata_plural
read only REST
- Catalog:
Tixly - Schema:
Customer - Label: itgen_tixly_customerbyid_metadata_plural
Fetches a specific customer by his customer Id.
Can only retrieve data.
Summary
Fetches a specific customer by his customer Id.
API Source
- Endpoint:
/customers/{id} - Operation:
get /customers/{id}
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | Id of the customer |
Table Columns
The columns of the table CustomerById_Metadata 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 | filters on the platform, writable, ::ancestor. |
||
Created |
int64 |
itgen_tixly_createdutcunix | filters on the platform, writable, ::ancestor. |
||
Customer |
int32 |
Customer Atribute ID | writable, Customer |
||
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. |
|||
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 | 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. |
||
Name |
varchar2 |
Name | writable, Name |
||
Name_2 |
varchar2 |
itgen_tixly_name_2 | filters on the platform, 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. |
||
Value |
varchar2 |
Value | writable, Value |
||
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: