Developing an autopopulating BOM

[David Pham]

Hello! First post here!

I want to create a BOM/Table on Confluence that automatically populates fields based off a JIRA ticket Details section. 

Ideally we would have columns for:

• PN pulled from Details section
• Name of the part pulled "Summary' section
• Status of the ticket based off the flowchart
• Last comment

Each row would be a different PN

All of this would be pulled from a Labels we assigned to each Jira ticket. 

Any idea on how to do this?

[Shawn Doyle - ReleaseTEAM]

Hi @David Pham 

I'd write a script, probably in python, that pulls these from Jira via the REST API, formats them for the table, and then updates the confluence page.  The comments part will need some massaging in the script

Are you on Server or Cloud?

Here are some cloud links to the API docs.

https://developer.atlassian.com/cloud/jira/platform/rest/v2/intro/#about

https://developer.atlassian.com/cloud/confluence/rest/v2/intro/#auth