ItemId [KEY] | String | False | | No | The unique identifier for each item in the system, used to reference and distinguish items across the database. |
CreatorId | String | False | | No | The unique identifier of the user who created the item, allowing tracking of item origin. |
CreatedAt | Datetime | False | | No | The date and time when the item was created in the system, useful for audit and tracking item age. |
UpdatedAt | Datetime | False | | No | The date and time of the most recent update made to the item, enabling tracking of changes over time. |
State | String | False | | No | The current state of the item, indicating whether it is active, archived, deleted, or in any other defined state. |
RelativeLink | String | False | | No | The relative URL path pointing to the item's location within the system or application. |
ItemEmail | String | False | | No | The email address associated with the item, typically used for notifications or communication. |
Url | String | False | | No | The full URL link pointing to the item or related resource, allowing direct access to the item online. |
AssetsIds | String | False | | No | A comma-separated list of unique identifiers for the assets or files associated with the item, facilitating easy referencing. |
GroupId | String | False | | No | The identifier of the group to which this item belongs, used to categorize and manage items in groups. |
GroupTitle | String | False | | No | The title or name of the group containing the item, offering contextual categorization. |
Item | String | False | | No | The name of the item, typically used as a label or title within the system. |
BoardRelationDisplayValue | String | False | | No | A string representing the names of linked items, separated by commas, to visualize their relationship. |
BoardRelationLinkedItemIds | String | False | | No | A comma-separated list of item IDs that are linked to the current item, allowing for reference to related data. |
ButtonLabel | String | False | | No | The label or text displayed on the button associated with the item, providing a user-friendly description of the button's function. |
ButtonColor | String | False | | No | The color of the button in hexadecimal format, used to define the button's visual style. |
ButtonValue | String | False | | No | The value associated with the button, typically represented in JSON format for structured data processing. |
Check | Bool | False | | No | The boolean value indicating whether a condition is true (checked) or false (unchecked), commonly used in forms. |
ColorPickerColor | String | False | | No | The selected color in hexadecimal format, used to specify color preferences in the item. |
ColorPickerValue | String | False | | No | The color value in JSON format, representing the full color configuration for the item. |
CountryCode | String | False | | No | The two-letter ISO code representing the country of the item or associated data. |
CountryName | String | False | | No | The full name of the country associated with the item, providing clarity for localization. |
DateIcon | String | False | | No | A string representing the icon selected for the date, used for visual representation of date fields. |
Date | Date | False | | No | The date value for the item, typically used to represent important events or milestones. |
Datetime | Datetime | False | | No | The datetime value associated with the item, used for tracking both date and time of events. |
DependencyDisplayValue | String | False | | No | A string listing the names of items upon which this task depends, enabling visual representation of task dependencies. |
DependencyLinkedItemsIds | String | False | | No | A list of item IDs representing the tasks or items that this task depends on, ensuring task scheduling accuracy. |
DocFileId | String | False | | No | The unique identifier for the document file associated with the item, used for managing document-related data. |
DocFileCreatorId | String | False | | No | The ID of the user who created the document file, useful for tracking document ownership and history. |
DocFileObjectId | String | False | | No | The identifier of the object or board related to the document file, linking the file to its contextual data. |
DocFileUrl | String | False | | No | The URL where the document file can be accessed or downloaded, providing direct access to the document. |
DocFileDocId | String | False | | No | The unique document identifier associated with the file, used for cross-referencing within document management systems. |
DropdownText | String | False | | No | The text value selected from a dropdown list, representing the user's choice in a user-friendly format. |
DropdownValue | String | False | | No | The value associated with the dropdown selection, represented in JSON format for structured data. |
Email | String | False | | No | The email address associated with the column, typically used for notifications or communications related to the item. |
EmailLabel | String | False | | No | The label or description of the email field, which may be the same as the email address if no label was entered. |
FileText | String | False | | No | The text value of the file column, used for storing textual content related to the file. |
FileValue | String | False | | No | The value of the file column in JSON format, allowing structured representation of file data. |
Hour | Time | False | | No | The time value associated with the item, representing a specific hour or time in a day. |
IntegrationIssueId | String | False | | No | The unique identifier for the integration issue, used for tracking issues in third-party integrations. |
IntegrationEntityId | String | False | | No | The unique identifier for the entity involved in the integration, allowing for efficient tracking and management. |
IntegrationIssueApiUrl | String | False | | No | The API URL where details about the integration issue can be accessed, facilitating debugging and resolution. |
IntegrationValue | String | False | | No | The value in JSON format representing the data or configuration related to the integration issue. |
LastUpdated | String | False | | No | The identifier of the user who last updated the item, allowing for tracking of who made the most recent changes. |
LinkUrl | String | False | | No | The URL link associated with the item, used to direct users to external resources or related items. |
LinkUrlText | String | False | | No | The display text for the link, providing context or description for users about the link's destination. |
LocationLat | Double | False | | No | The latitude coordinate of the item's location, used for mapping and geospatial purposes. |
LocationLng | Double | False | | No | The longitude coordinate of the item's location, used in conjunction with latitude for accurate geolocation. |
LocationPlaceId | String | False | | No | The place ID associated with the item's location, used for precise location identification in mapping systems. |
LocationAddress | String | False | | No | The full address of the item's location, providing complete details for geolocation purposes. |
LocationCity | String | False | | No | The city in which the item is located, used to specify its geographic location. |
LocationCityShort | String | False | | No | A shorthand version of the city's name, typically used for space-saving purposes. |
LocationCountry | String | False | | No | The country where the item is located, providing regional context for the item. |
LocationCountryShort | String | False | | No | A shortened version of the country's name, typically using its two-letter ISO code. |
LocationStreet | String | False | | No | The street address of the item's location, giving a precise physical location. |
LocationStreetNumber | String | False | | No | The street number of the building, giving additional detail to the street address. |
LocationStreetNumberShort | String | False | | No | A shorthand version of the building number, typically used in forms with limited space. |
LocationStreetShort | String | False | | No | A shortened version of the street name, used when space is limited or for abbreviated addresses. |
LongText | String | False | | No | A field for storing longer text, typically used for descriptions, notes, or additional information. |
MirrorDisplayValue | String | False | | No | The display value for items mirrored from other sources, typically representing the original data. |
MirroredItems | String | False | | No | A list of items that are mirrored, representing items whose data is replicated across different locations. |
Numbers | Double | False | | No | A numeric value representing any relevant quantity or measurement associated with the item. |
PeopleText | String | False | | No | The text value for the people column, used for storing names or descriptions of people related to the item. |
PeopleValue | String | False | | No | The value of the people column in JSON format, representing structured data about people. |
PhoneCountryShortName | String | False | | No | The ISO-2 country code representing the country of the phone number. |
Phone | String | False | | No | The phone number associated with the item, used for contact purposes. |
Rating | Int | False | | No | An integer representing the rating assigned to the item, typically used in review or feedback systems. |
StatusIndex | Int | False | | No | The index number of the status in the board, allowing for sorting and managing item statuses. |
StatusIsDone | Bool | False | | No | A boolean indicating whether the status of the item is marked as complete or not. |
StatusLabel | String | False | | No | The label or name of the status, providing a user-friendly identifier for the item's state. |
StatusUpdateId | String | False | | No | The unique identifier for the status update, allowing for tracking of changes to the item's status. |
StatusLabelStyleColor | String | False | | No | The hexadecimal color value representing the style of the status label, used to define the label's visual color. |
StatusLabelStyleBorder | String | False | | No | The hexadecimal color value representing the style of the status label's border, used for visual distinction. |
TagsText | String | False | | No | The textual representation of the tags associated with the item, providing an easy-to-read list of tags. |
TagsIds | String | False | | No | A list of tag IDs associated with the item, allowing for filtering and categorization based on tags. |
Text | String | False | | No | The text value of the item, typically used for storing descriptions, titles, or other relevant textual data. |
TimeTrackingRunning | Bool | False | | No | A boolean value indicating whether the time tracker associated with the item is currently running. |
TimeTrackingStartedAt | Datetime | False | | No | The timestamp of when the time tracking was started, providing a reference for when the activity began. |
TimeTrackingDuration | Int | False | | No | The total duration in seconds for which the time tracker has been running. |
TimelineFrom | Date | False | | No | The start date for the timeline, used to specify when the project or task begins. |
TimelineTo | Date | False | | No | The end date for the timeline, marking the completion or due date for the project or task. |
TimelineVisualizationType | String | False | | No | The type of visualization to use for the timeline, defining how the timeline data is presented to the user. |
VoteCount | Int | False | | No | The total number of votes cast for the item, used in voting or polling scenarios. |
VoterIds | String | False | | No | A list of user IDs who have voted on the item, used to track voter participation. |
WeekStartDate | Date | False | | No | The start date for the week, typically used for scheduling or time tracking purposes. |
WeekEndDate | Date | False | | No | The end date for the week, marking the conclusion of the weekly period. |
WorldClock | String | False | | No | The timezone or world clock setting used to display the item's time in the correct time zone. |
RelativeTo | String | False | | Yes | The item to which the current item is relative, used for positioning items next to each other in a layout. |
PositionRelativeMethod | String | False | | Yes | The method used to determine the item's position relative to another item, either before or after it. |
CreateLabelsIfMissing | Bool | False | | Yes | A pseudocolumn that indicates whether new labels for status or dropdown fields should be created if missing, requiring board structure modification permissions. |