Contacts
Retrieve contacts.
Table Specific Information
Select
Streak allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only = comparision. The available column for Contacts is ContactKey. For example:
SELECT * FROM Contacts WHERE ContactKey='VGVhbUNvbabhY3Qsfn5zdHJlYWtsb25naWR-fjYyMzUwNzEzOTk1MjY0MDA'
Columns
| Name | Type | References | Description |
| ContactKey [KEY] | String |
BoxesContacts.ContactKey | Key of the contact. |
| TeamKey | String |
Teams.TeamKey | Key of the team. |
| GivenName | String | The contact's name. | |
| FamilyName | String | The family name of the contact. | |
| Other | String | Extra description for the contact. | |
| Title | String | Title of contact. | |
| EmailAddresses | String | List of email addresses for the contact. | |
| PhoneNumbers | String | List of email phone numbers for the contact. | |
| Addresses | String | List of addresses for the contact. | |
| TwitterHandle | String | Link to the contact's twitter profile. | |
| FacebookHandle | String | Link to the contact's facebook profile. | |
| LinkedinHandle | String | Link to the contact's twitter profile. | |
| PhotoUrl | String | URL to the profile picture of the contact. | |
| OrgLinksKey | String | Organizations the contact is assocated with. | |
| LastEnrichmentTimestamp | Datetime | When the contact was last enriched. | |
| LastSavedUserKey | String |
Users.UserKey | User who last saved the contact record. |
| CreatorKey | String |
Users.UserKey | Creator of the contact record. |
| CreationDate | Datetime | Creation date for the contact record. | |
| VersionTimestamp | Datetime | Datetime associated with this version of the contact. | |
| LastSavedTimestamp | Datetime | When the contact record was last saved. |