SSIS Components for Highrise

Build 20.0.7587

Cases

Create, update, delete, and query Cases that are visible to the authenticated user.

テーブル固有の情報

Insert

新しいCase を挿入するには、Name が必要です。

INSERT INTO Cases (Name) values ('my case') 

Columns

Name Type ReadOnly References Description
Id [KEY] Integer True

The unique identifier for the case.

Name String False

The name of the case.

IsClosed Boolean True

Whether the case is closed. The default is open.

ClosedAt Datetime False

The date and time when the case was closed.

VisibleTo String False

Who the case is visible to: Everyone, Owner, or NamedGroup.

OwnerId Integer False

The unique identifier of the owner.

GroupId Integer False

The unique identifier of the group.

AuthorId Integer False

The unique identifier of the author.

CreatedAt Datetime True

The date and time when the case was created.

UpdatedAt Datetime True

The date and time when the case was last updated.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587