EndPoint Upsert Project
Parameters
Parameter | Label | Required | Options | Description |
---|---|---|---|---|
ProjectIdOrKey | ProjectIdOrKey | NO |
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
Id |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
Key |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
Name |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
Description |
DT_NTEXT
|
nvarchar(MAX)
|
False |
||
IssueTypes |
DT_NTEXT
|
nvarchar(MAX)
|
False |
||
Expand |
DT_WSTR
|
nvarchar(300)
|
300 | False |
|
Self |
DT_WSTR
|
nvarchar(150)
|
150 | False |
|
EntityId |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
Uuid |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
Properties |
DT_NTEXT
|
nvarchar(MAX)
|
False |
||
Components |
DT_NTEXT
|
nvarchar(MAX)
|
False |
||
LeadSelf |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
LeadAccountId |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
LeadAvatarUrls48x48 |
DT_WSTR
|
nvarchar(700)
|
700 | False |
|
LeadAvatarUrls24x24 |
DT_WSTR
|
nvarchar(700)
|
700 | False |
|
LeadAvatarUrls16x16 |
DT_WSTR
|
nvarchar(700)
|
700 | False |
|
LeadAvatarUrls32x32 |
DT_WSTR
|
nvarchar(700)
|
700 | False |
|
LeadDisplayName |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
LeadActive |
DT_BOOL
|
bit
|
False |
||
ProjectTypeKey |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
AssigneeType |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
Versions |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
Simplified |
DT_BOOL
|
bit
|
False |
||
Style |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
IsPrivate |
DT_BOOL
|
bit
|
False |
||
RolesAtlassianAddonsProjectAccess |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
RolesAdministrator |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
RolesViewer |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
RolesMember |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
AvatarUrls48x48 |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
AvatarUrls24x24 |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
AvatarUrls16x16 |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
AvatarUrls32x32 |
DT_WSTR
|
nvarchar(500)
|
500 | False |
Input Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
ProjectKey |
DT_WSTR
|
nvarchar(50)
|
50 | False |
A key uniquely representing your project |
Name |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
Description |
DT_WSTR
|
nvarchar(300)
|
300 | False |
|
LeadAccountId |
DT_WSTR
|
nvarchar(100)
|
100 | False |
The account ID of the project lead |
Url |
DT_WSTR
|
nvarchar(400)
|
400 | False |
A link to information about this project, such as project documentation |
AssigneeType |
DT_WSTR
|
nvarchar(100)
|
100 | False |
The default assignee when creating issues for this project. Possible values: PROJECT_LEAD, UNASSIGNED |
AvatarId |
DT_I8
|
bigint
|
False |
An integer value for the project's avatar. | |
IssueSecurityScheme |
DT_I8
|
bigint
|
False |
The ID of the issue security scheme for the project, which enables you to control who can and cannot view issues. | |
PermissionScheme |
DT_I8
|
bigint
|
False |
The ID of the permission scheme for the project. | |
NotificationScheme |
DT_I8
|
bigint
|
False |
The ID of the notification scheme for the project. | |
CategoryId |
DT_I8
|
bigint
|
False |
The ID of the project's category. |
Required columns that you need to supply are bolded.
Examples
SSIS
Use Jira Connector in API Source component to read data or in API Destination component to read/write data:
Update rows in Projects table using API Destination
This EndPoint belongs to Projects table, therefore you cannot work with it directly. Use this table and table-operation pair instead:
Jira
Projects
Update
