invantive documentation
Invantive Support ForumsLog In / Sign Up

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
DateFrom `` 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
AcademicSuffix varchar2 itgen_tixly_academicsuffix filters on the platform, writable, ::ancestor.::ancestor.AcademicSuffix
AcademicTitle varchar2 itgen_tixly_academictitle filters on the platform, writable, ::ancestor.::ancestor.AcademicTitle
AddressOne varchar2 Address One filters on the platform, writable, ::ancestor.::ancestor.AddressOne
AddressTwo varchar2 Address Two filters on the platform, writable, ::ancestor.::ancestor.AddressTwo
AlternativeEmails varchar2 Alternative Email Addresses filters on the platform, writable, ::ancestor.::ancestor.AlternativeEmails
CRN varchar2 CRN filters on the platform, writable, ::ancestor.::ancestor.CRN
City varchar2 City filters on the platform, writable, ::ancestor.::ancestor.City
CompanyName varchar2 Company Name filters on the platform, writable, ::ancestor.::ancestor.CompanyName
Country varchar2 Country filters on the platform, writable, ::ancestor.::ancestor.Country
CountryCode varchar2 Country Code filters on the platform, writable, ::ancestor.::ancestor.CountryCode
Created datetime Created writable, ::ancestor.Created
CreatedUTCUnix int64 itgen_tixly_createdutcunix writable, ::ancestor.CreatedUTCUnix
CreatedUTCUnix_2 int64 itgen_tixly_createdutcunix_2 filters on the platform, writable, ::ancestor.::ancestor.CreatedUTCUnix
Created_2 datetime itgen_tixly_created_2 filters on the platform, writable, ::ancestor.::ancestor.Created
DateOfBirth datetime Date of Birth filters on the platform, writable, ::ancestor.::ancestor.DateOfBirth
DateOfBirthUTCUnix int64 itgen_tixly_dateofbirthutcunix filters on the platform, writable, ::ancestor.::ancestor.DateOfBirthUTCUnix
DeletedDate datetime Deleted Date filters on the platform, writable, ::ancestor.::ancestor.DeletedDate
DeletedDateUTCUnix int64 itgen_tixly_deleteddateutcunix filters on the platform, writable, ::ancestor.::ancestor.DeletedDateUTCUnix
Description varchar2 Description filters on the platform, writable, ::ancestor.::ancestor.Description
DisallowMerge char Disallow Merge filters on the platform, writable, ::ancestor.::ancestor.DisallowMerge
Edited datetime Edited filters on the platform, writable, ::ancestor.::ancestor.Edited
EditedUTCUnix int64 itgen_tixly_editedutcunix filters on the platform, writable, ::ancestor.::ancestor.EditedUTCUnix
Email varchar2 Email filters on the platform, writable, ::ancestor.::ancestor.Email
EmailPermission char Email Permission writable, ::ancestor.EmailPermission
FirstName varchar2 First Name filters on the platform, writable, ::ancestor.::ancestor.FirstName
Gender int32 Gender filters on the platform, writable, ::ancestor.::ancestor.Gender
HomePhone varchar2 Home Phone filters on the platform, writable, ::ancestor.::ancestor.HomePhone
HouseExtension varchar2 House Extension filters on the platform, writable, ::ancestor.::ancestor.HouseExtension
HouseNumber varchar2 House Number filters on the platform, writable, ::ancestor.::ancestor.HouseNumber
Id int32 ID writable, ::ancestor.Id
Id_2 int32 itgen_tixly_id_2 filters on the platform, writable, ::ancestor.::ancestor.Id
Initials varchar2 Initials filters on the platform, writable, ::ancestor.::ancestor.Initials
IsAnonymized char Is Anonymized filters on the platform, writable, ::ancestor.::ancestor.IsAnonymized
IsDeleted char Is Deleted filters on the platform, writable, ::ancestor.::ancestor.IsDeleted
LanguageId int32 Language ID filters on the platform, writable, ::ancestor.::ancestor.LanguageId
LastName varchar2 Last Name filters on the platform, writable, ::ancestor.::ancestor.LastName
LastNamePrefix varchar2 Last Name Prefix filters on the platform, writable, ::ancestor.::ancestor.LastNamePrefix
Latitude double Latitude filters on the platform, writable, ::ancestor.::ancestor.Latitude
Longitude double Longitude filters on the platform, writable, ::ancestor.::ancestor.Longitude
Mobile varchar2 Mobile filters on the platform, writable, ::ancestor.::ancestor.Mobile
MobilePermission char Mobile Permission writable, ::ancestor.MobilePermission
Name varchar2 Name writable, ::ancestor.Name
Name_2 varchar2 itgen_tixly_name_2 filters on the platform, writable, ::ancestor.::ancestor.Name
PostPermission char itgen_tixly_postpermission writable, ::ancestor.PostPermission
SSN varchar2 SSN filters on the platform, writable, ::ancestor.::ancestor.SSN
StreetName varchar2 Street Name filters on the platform, writable, ::ancestor.::ancestor.StreetName
Title varchar2 Title filters on the platform, writable, ::ancestor.::ancestor.Title
Type int32 Type writable, ::ancestor.Type
TypeName varchar2 Type Name writable, ::ancestor.TypeName
WorkPhone varchar2 Work Phone filters on the platform, writable, ::ancestor.::ancestor.WorkPhone
ZipCode varchar2 ZIP-code filters on the platform, writable, ::ancestor.::ancestor.ZipCode

Release Notes

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