Power BI Connector for Highrise

Build 24.0.9060

DealCategories

Create, update, delete, and query Deal Categories.

Table Specific Information

Insert

To insert a new Deal Category, at least a Category Name and a Color must be provided.

INSERT INTO DealCategories (Name, Color) VALUES ('A unique deal category', '5df4b5')  

Columns

Name Type ReadOnly References Description
Id [KEY] Integer True

The unique identifier for the category.

Name String False

The name of the category.

Color String False

The color as a hex value.

AccountId Integer True

A reference to the account.

ElementsCount Integer True

The number of elements in the category.

CreatedAt Datetime True

The date and time when this record was created.

UpdatedAt Datetime True

The date and time when this record was last updated.

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