People
To Create, update, delete, and query from People table.
Table Specific Information
Select
For datetime columns only the '>' and '>=' operators are supported.
SELECT * FROM People WHERE UpdatedAt > '2016-04-18'
Insert
To insert a Person provide at least First Name, Last Name, and the Job Title.
INSERT INTO People (FirstName, LastName, Title) VALUES ('FirstName', 'LastName', 'CEO')
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The unique identifier of the person. | |
| FirstName | String | False |
The first name of the person. | |
| LastName | String | False |
The last name of the person. | |
| Title | String | False |
The job title of the person. | |
| Background | String | False |
Background notes about the person. | |
| EmailAddressAggregate | String | False |
The list of email addresses for the person, returned as an XML aggregate. | |
| PhoneNumberAggregate | String | False |
The list of phone numbers for the person, returned as an XML aggregate. | |
| AddressAggregate | String | True |
The list of addresses for the person, returned as an XML aggregate. | |
| InstantMessengerAggregate | String | True |
The list of instant messenger accounts for the person, returned as an XML aggregate. | |
| TwitterAccountAggregate | String | True |
The list of Twitter accounts for the person, returned as an XML aggregate. | |
| WebAddressAggregate | String | True |
The list of web addresses for the person, returned as an XML aggregate. | |
| CompanyID | Integer | False |
The Id of the company the person belongs to. | |
| CompanyName | String | False |
The name of the company the person belongs to. | |
| LinkedInURL | String | False |
The LinkedIn profile URL of the person. | |
| AvatarURL | String | True |
The URL of the avatar image for the person. | |
| VisibleTo | String | True |
Who the person record is visible to. The allowed values are Everyone, Owner, and NamedGroup. | |
| OwnerId | Integer | True |
The Id of the user who owns the person record. | |
| GroupId | Integer | True |
The Id of the group associated with the person record. | |
| AuthorId | Integer | True |
The Id of the user who created the person record. | |
| CreatedAt | Datetime | True |
The date and time when the person record was created. | |
| UpdatedAt | Datetime | True |
The date and time when the person record was last updated. |