SSIS Components for Highrise

Build 20.0.7587

People

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

テーブル固有の情報

Select

Datetime カラムでは、'>'、および'>=' の演算子だけがサポートされています。

SELECT * FROM People WHERE UpdatedAt > '2016-04-18' 

Insert

Person を追加するには、First Name、Last Name、およびJob Title が必須です。

INSERT INTO People (FirstName, LastName, Title) VALUES ('FirstName', 'LastName', 'CEO') 

Columns

Name Type ReadOnly References Description
Id [KEY] Integer 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 Integer 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 Integer 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 Datetime True

The CreatedAt column for the table People.

UpdatedAt Datetime 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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587