| 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. |