# IssueRemoteLinksByIdOrKey
- Catalog: `JIRA`
- Schema: `Core`
- Primary Keys: `id`
- Select JIRA Cloud API URL: `/issue/{issueIdOrKey}/remotelink`
- Insert JIRA Cloud API URL: `/issue/{issueIdOrKey}/remotelink`
- Update JIRA Cloud API URL: `/issue/{issueIdOrKey}/remotelink`
- Delete JIRA Cloud API URL: `/issue/{issueIdOrKey}/remotelink`
- 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 |
|---|:---:|:---:|:---:|---|
| `issueIdOrKey` | `string` | ☑ | | The ID or key to be retrieved. |
## Columns of Table Function
The columns of the table function `IssueRemoteLinksByIdOrKey` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `application_name` | `string` | | ☐ | The name of the application. Used in conjunction with the (remote) object icon title to display a tooltip for the link's icon. The tooltip takes the format "[application name] icon title". Blank items are excluded from the tooltip title. If both items are blank, the icon tooltop displays as "Web Link". Grouping and sorting of links may place links without an application name last. |
| `application_type` | `string` | | ☐ | The name-spaced type of the application, used by registered rendering apps. |
| `globalId` | `string` | | ☐ | The global ID of the link, such as the ID of the item on the remote system. |
| `id` | `int64` | | ☐ | The ID of the link. |
| `object_title` | `string` | | ☐ | Title. |
| `object_url` | `string` | | ☐ | The URL. |
| `relationship` | `string` | | ☐ | Description of the relationship between the issue and the linked item. |
| `self` | `string` | | ☐ | The URL of the link. |