Additional Epic fields from Jira Azure Connector

[Petrus Schoonwinkel]

Hi all,

I am looking for the a number of fields related to an Epic item within the Jira Table list.  

I am making use of Jira's official connector for Microsoft Azure to extract Jira data onto our Data Lake. 

We're looking to recreate a Status Report from the raw data in order to tailor our weekly Jira reports. In this report, Jira provides the following fields that I cannot find in any of the Jira tables obtainable through the connnector:

Assignee (of the Epic specifically, not the underlying issue)
Business or Product Owner (Not the Reporter, but the Business/Product Owner of the Epic)
Acceptance Criteria 
Labels (E.g BusinessValue or TechnicalDebt)
% Completed 

Can anyone please help me identify what the source table name is for the above mentioned fields?

Please see attached list of all tables in Jira that one can extract and load to desired database.

Jira Table List.

"Agile"."Agile_Board"
"Agile"."Agile_Board_Backlog_Issues"
"Agile"."Agile_Board_Backlog_Issues_Fields_Attachment"
"Agile"."Agile_Board_Backlog_Issues_Fields_Closed_Sprints"
"Agile"."Agile_Board_Backlog_Issues_Fields_Comment_Comments"
"Agile"."Agile_Board_Backlog_Issues_Fields_Components"
"Agile"."Agile_Board_Backlog_Issues_Fields_Fix_Versions"
"Agile"."Agile_Board_Backlog_Issues_Fields_Issue_Links"
"Agile"."Agile_Board_Backlog_Issues_Fields_Labels"
"Agile"."Agile_Board_Backlog_Issues_Fields_Subtasks"
"Agile"."Agile_Board_Backlog_Issues_Fields_Versions"
"Agile"."Agile_Board_Backlog_Issues_Fields_Work_Log_Worklogs"
"Agile"."Agile_Board_Backlog_Names_Schema"
"Agile"."Agile_Board_Configuration"
"Agile"."Agile_Board_Epic"
"Agile"."Agile_Board_Epic_Issue"
"Agile"."Agile_Board_Epic_Issue_Fields_Labels"
"Agile"."Agile_Board_Issue"
"Agile"."Agile_Board_Issue_Fields_Attachment"
"Agile"."Agile_Board_Issue_Fields_Closed_Sprints"
"Agile"."Agile_Board_Issue_Fields_Comment_Comments"
"Agile"."Agile_Board_Issue_Fields_Components"
"Agile"."Agile_Board_Issue_Fields_Fix_Versions"
"Agile"."Agile_Board_Issue_Fields_Issue_Links"
"Agile"."Agile_Board_Issue_Fields_Labels"
"Agile"."Agile_Board_Issue_Fields_Subtasks"
"Agile"."Agile_Board_Issue_Fields_Versions"
"Agile"."Agile_Board_Issue_Fields_Work_Log_Worklogs"
"Agile"."Agile_Board_Sprint"
"Agile"."Agile_Board_Sprint_Issue"
"Agile"."Agile_Board_Sprint_Issue_Fields_Attachment"
"Agile"."Agile_Board_Sprint_Issue_Fields_Closed_Sprints"
"Agile"."Agile_Board_Sprint_Issue_Fields_Comment_Comments"
"Agile"."Agile_Board_Sprint_Issue_Fields_Components"
"Agile"."Agile_Board_Sprint_Issue_Fields_Fix_Versions"
"Agile"."Agile_Board_Sprint_Issue_Fields_Issue_Links"
"Agile"."Agile_Board_Sprint_Issue_Fields_Labels"
"Agile"."Agile_Board_Sprint_Issue_Fields_Subtasks"
"Agile"."Agile_Board_Sprint_Issue_Fields_Versions"
"Agile"."Agile_Board_Sprint_Issue_Fields_Work_Log_Worklogs"
"Agile"."Agile_Board_Version"
"Agile"."Column_Config_Columns"
"Agile"."Column_Config_Columns_Statuses"
"Agile"."Fields_Attachment"
"Agile"."Fields_Closed_Sprints"
"Agile"."Fields_Comment_Comments"
"Agile"."Fields_Components"
"Agile"."Fields_Fix_Versions"
"Agile"."Fields_Issue_Links"
"Agile"."Fields_Subtasks"
"Agile"."Fields_Versions"
"Agile"."Fields_Work_Log_Worklogs"
"Extra"."Agile_Board_Backlog_Issues"
"Extra"."Agile_Board_Epic_Issue"
"Extra"."Agile_Board_Issue"
"Extra"."Agile_Board_Sprint_Issue"

Thank you!

[Nic Brough -Adaptavist- · Accepted solution]

You need to be looking to the standard fields, not the "Jira software" fields.

[Petrus Schoonwinkel]

Hi Nic,

Thank you for your response. I'm unfortunately not sure what you mean by standard fields? Are these located in the tables from the "Platform" schema? I see there are quite a few to choose from, but the naming does not suggest which tables might be applicable. For example:

"Platform".""Api_Issue"
"Platform".""Api_Project"
"Platform".""Api_Issue_Fields_Labels"

Are these the tables that contain the standard fields? 

Kind regards,

[Nic Brough -Adaptavist-]

Yes.

By "standard fields" I mean the issue fields that are part of the core issue (and custom fields that you have added, as the custom field functions are standard).  Summary, Description, priority and so on.

[Petrus Schoonwinkel]

Thank you for your assistance Nic! That answered the question.

Confirmed the fields mentioned above are found in the "Extra"."Api_Issue" table, under a custom fields. Customfields are mapped for each Issue_key under the "Platform"."Items" table, which can be used as a reference for identifying which fields relate to which customfield columns.

Kind regards,