How do I create or modify a table in Confluence and push the changes into a Jira user story?

[Carol Reeves]

How do I create or modify a table in Confluence and push the changes into Jira?

There is a lot of integration from Jira into Confluence, but is there integration from Confluence into Jira? Is there some JQL written that will do this?

I would like people to be able to modify the Confluence table and have Jira pick up the changes from Confluence and add them into the table in the user story.

I have users who do not have access to the team's Jira boards, but they do have access to our open confluence pages. Instead of emailing information which we manually put into Jira, I would like to create a table in Confluence in which the users can add information, but I need Jira to pull the Confluence table into the Jira user story.

[Brant Schroeder · Accepted solution]

@Carol Reeves I am not aware of an app that would keep this content synced.  I would suggest just maintaining the information in a single place, Confluence.  You can then use the link feature to create a link to the Confluence page.  https://confluence.atlassian.com/jirasoftwareserver0820/linking-issues-1095249450.html 

Cloud has a feature that allows you to embed the page into the description.  https://www.atlassian.com/software/confluence/resources/guides/extend-functionality/confluence-jira#add-confluence-to-jira-issues 

[Carol Reeves]

Thank you for your help! I also found the feature to create Jira instances from a Confluence table which helped to get the information into Jira initially. 

1. In Confluence and Google Chrome, edit a page, then create a table (make sure it has a header) with as many rows as you want tickets.
2. In the header, uniquely title your columns (Summary, Description, and so on).
3. Fill in ticket summaries and descriptions.
4. Publish or Update the page (so that you're not in edit mode).
5. Select the text of the first summary. In the tiny menu that appears, click the Jira icon.
6. In the Create Task window, make sure the Jira project and ticket type are correct, then click Create multiple issues from table.
7. In the Create Multiple Issues window, you are being asked which table column contains Summary text, and which contains Description text. Make sure these are right, then click Create.
8. You should get a message like "3 issues have been created. Your page has been updated to reflect the status of these issues." Notice that links to each Jira ticket have been added to the table! Go to Jira to see your new issues.

I wish if the headers in the Confluence table match fields in Jira then all the matching fields would be filled in from the Confluence table into Jira. Is there an automated workaround that would do this?

[Brant Schroeder]

@Carol Reeves The feature you are referencing is delivered through the application link and allows you to create issues via Confluence.  If an issue already exists with the same summary it will create a new issue and the content of the issue will not be synced with Confluence.  It will create the link on the issue back to Confluence and a link to the issue on the Confluence page.