SSIS Components for Highrise

Build 20.0.7587

Companies

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

テーブル固有の情報

Select

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

SELECT * FROM Companies WHERE UpdatedAt > '2012-01-12' 

Insert

新しいCompany の追加には、Company Name およびCompany のBackground の設定が必須です。

INSERT INTO Companies (Name,Background) VALUES ('Company name','The description') 

Columns

Name Type ReadOnly References Description
Id [KEY] Integer False

The Id column for the table Companies.

Name String False

The Name column for the table Companies.

Background String False

The Background column for the table Companies.

EmailAddressAggregate String False

The EmailAddressAggregate column for the table Companies.

PhoneNumberAggregate String False

The PhoneNumberAggregate column for the table Companies.

AddressAggregate String False

The AddressAggregate column for the table Companies.

InstantMessengerAggregate String False

The InstantMessengerAggregate column for the table Companies.

TwitterAccountAggregate String False

The TwitterAccountAggregate column for the table Companies.

WebAddressAggregate String False

The WebAddressAggregate column for the table Companies.

AvatarURL String False

The AvatarURL column for the table Companies.

VisibleTo String False

The VisibleTo column for the table Companies.

OwnerId Integer False

The OwnerId column for the table Companies.

GroupId String False

The GroupId column for the table Companies.

AuthorId String True

The AuthorId column for the table Companies.

CreatedAt Datetime True

The CreatedAt column for the table Companies.

UpdatedAt Datetime True

The UpdatedAt column for the table Companies.

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