# ProjectRolesByIdOrKey: JIRA Cloud Project Roles by ID or Key - Catalog: `JIRA` - Schema: `Core` - Primary Keys: `id` - Label: Project Roles by ID or Key - Select JIRA Cloud API URL: `/project/{projectIdOrKey}/roledetails` - Insert JIRA Cloud API URL: `/project/{projectIdOrKey}/roledetails` - Update JIRA Cloud API URL: `/project/{projectIdOrKey}/roledetails` - Delete JIRA Cloud API URL: `/project/{projectIdOrKey}/roledetails` - Field Selection Method: NotRequired This is a read-only table function. The JIRA Cloud API may not support changing the data or the Invantive SQL driver for JIRA Cloud does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the JIRA Cloud API. ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `projectIdOrKey` | `string` | ☑ | | | ## Columns of Table Function The columns of the table function `ProjectRolesByIdOrKey` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `actors` | `string` | | ☐ | The list of users who act in this role. | | `admin` | `boolean` | | ☐ | Whether this role is the admin role for the project. | | `default` | `boolean` | | ☐ | Whether this role is the default role for the project. | | `description` | `string` | | ☐ | The description of the project role. | | `id` | `int64` | | ☐ | The ID of the project role. | | `name` | `string` | | ☐ | The name of the project role. | | `self` | `string` | | ☐ | The URL the project role details. |