EndPoint Upsert Project

Contents

Name

upsert_project

No description available

Parameter	Label	Required	Options	Description
ProjectIdOrKey	ProjectIdOrKey	NO

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
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

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.