Reference

Endpoint Upsert Project

Name

upsert_project

Description

No description available

Related Tables

Projects

Parameters

Parameter Required Options
Name: ProjectIdOrKey

Label: ProjectIdOrKey

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_WSTR nvarchar(50) 50
Key DT_WSTR nvarchar(50) 50
Name DT_WSTR nvarchar(100) 100
Description DT_NTEXT nvarchar(MAX)
IssueTypes DT_NTEXT nvarchar(MAX)
Expand DT_WSTR nvarchar(300) 300
Self DT_WSTR nvarchar(150) 150
EntityId DT_WSTR nvarchar(100) 100
Uuid DT_WSTR nvarchar(100) 100
Properties DT_NTEXT nvarchar(MAX)
Components DT_NTEXT nvarchar(MAX)
LeadSelf DT_WSTR nvarchar(500) 500
LeadAccountId DT_WSTR nvarchar(100) 100
LeadAvatarUrls48x48 DT_WSTR nvarchar(700) 700
LeadAvatarUrls24x24 DT_WSTR nvarchar(700) 700
LeadAvatarUrls16x16 DT_WSTR nvarchar(700) 700
LeadAvatarUrls32x32 DT_WSTR nvarchar(700) 700
LeadDisplayName DT_WSTR nvarchar(100) 100
LeadActive DT_BOOL bit
ProjectTypeKey DT_WSTR nvarchar(50) 50
AssigneeType DT_WSTR nvarchar(50) 50
Versions DT_WSTR nvarchar(50) 50
Simplified DT_BOOL bit
Style DT_WSTR nvarchar(50) 50
IsPrivate DT_BOOL bit
RolesAtlassianAddonsProjectAccess DT_WSTR nvarchar(500) 500
RolesAdministrator DT_WSTR nvarchar(500) 500
RolesViewer DT_WSTR nvarchar(500) 500
RolesMember DT_WSTR nvarchar(500) 500
AvatarUrls48x48 DT_WSTR nvarchar(500) 500
AvatarUrls24x24 DT_WSTR nvarchar(500) 500
AvatarUrls16x16 DT_WSTR nvarchar(500) 500
AvatarUrls32x32 DT_WSTR nvarchar(500) 500
If the column you are looking for is missing, consider customizing Jira Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
ProjectKey DT_WSTR nvarchar(50) 50 A key uniquely representing your project
Name DT_WSTR nvarchar(100) 100
Description DT_WSTR nvarchar(300) 300
LeadAccountId DT_WSTR nvarchar(100) 100 The account ID of the project lead
Url DT_WSTR nvarchar(400) 400 A link to information about this project, such as project documentation
AssigneeType DT_WSTR nvarchar(100) 100 The default assignee when creating issues for this project. Possible values: PROJECT_LEAD, UNASSIGNED
AvatarId DT_I8 bigint An integer value for the project's avatar.
IssueSecurityScheme DT_I8 bigint 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 The ID of the permission scheme for the project.
NotificationScheme DT_I8 bigint The ID of the notification scheme for the project.
CategoryId DT_I8 bigint The ID of the project's category.
Required columns that you need to supply are bolded.

Examples

SSIS

Use Jira Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Destination

This Endpoint belongs to the Projects table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to upsert project:

API Destination - Jira
Read and write Jira data effortlessly. Track, manage, and automate issues, projects, worklogs, and comments — almost no coding required.
Jira
Projects
Update, Upsert
Optional Parameters
ProjectIdOrKey
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Update a project

<p>Updates an existing project. Set the columns to change (e.g. <code>Name</code>, <code>ProjectCategoryId</code>) and identify the project with <code>ProjectIdOrKey</code> in <code>WITH</code>.</p> 

UPDATE Projects
SET Name = 'My Test Kanban Project'
   ,ProjectCategoryId = 1
WITH (ProjectIdOrKey = 'MYPRJCT', Output=1, ContinueOn404Error=0)

upsert_project endpoint belongs to Projects table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Update a project

<p>Updates an existing project. Set the columns to change (e.g. <code>Name</code>, <code>ProjectCategoryId</code>) and identify the project with <code>ProjectIdOrKey</code> in <code>WITH</code>.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Projects
SET Name = ''My Test Kanban Project''
   ,ProjectCategoryId = 1
WITH (ProjectIdOrKey = ''MYPRJCT'', Output=1, ContinueOn404Error=0)';

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];

upsert_project endpoint belongs to Projects table(s), and can therefore be used via those table(s).