JDBC Driver for Highrise

Build 22.0.8462

Companies

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

Table Specific Information

Select

For datetime columns only the '>' and '>=' operators are supported.

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

Insert

To insert a new Company, provide at least a Company Name and a Background for the Company.

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

Columns

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

The CreatedAt column for the table Companies.

UpdatedAt String 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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462