Excel Add-In for Highrise

Build 24.0.9060

People

Create, update, delete, and query Highrise People. This table is dynamic.

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] String False

The Id column for the table People.

FirstName String False

The FirstName column for the table People.

LastName String False

The LastName column for the table People.

Title String False

The Title column for the table People.

Background String False

The Background column for the table People.

EmailAddressAggregate String False

The EmailAddressAggregate column for the table People.

PhoneNumberAggregate String False

The PhoneNumberAggregate column for the table People.

AddressAggregate String False

The AddressAggregate column for the table People.

InstantMessengerAggregate String False

The InstantMessengerAggregate column for the table People.

TwitterAccountAggregate String False

The TwitterAccountAggregate column for the table People.

WebAddressAggregate String False

The WebAddressAggregate column for the table People.

CompanyID String False

The CompanyID column for the table People.

CompanyName String False

The CompanyName column for the table People.

LinkedInURL String False

The LinkedInURL column for the table People.

AvatarURL String False

The AvatarURL column for the table People.

VisibleTo String False

The VisibleTo column for the table People.

OwnerId String False

The OwnerId column for the table People.

GroupId String False

The GroupId column for the table People.

AuthorId String True

The AuthorId column for the table People.

CreatedAt String True

The CreatedAt column for the table People.

UpdatedAt String True

The UpdatedAt column for the table People.

PartyCustomField1 String False

A CustomField of type party.

PartyCustomField2 String False

A CustomField of type party.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060