Display filter results in Confluence for non-jira users

[Sheri Widler]

We have our employees who are not jira users. 
We have a list of Jira Service items or Jira Software items we want to add to our help center portal that is sourced from Confluence.  
Can I dynamically populate an confluence page with data from query results without embedding the fitler in confleunce. 

So for example if I filter and get these results

Key               Summary          Date
ITEM-100     Title1                 Aug 23, 2023 

ITEM-150     Title3                 Aug 03, 2023 

ITEM-180     Title4                 Aug 31, 2023 

populate the confluence page with this 

[Brant Schroeder]

@Sheri Widler The Jira macro displays issues out of Jira for licensed users.  You could add manual links to portal issue but the macro will not display issue to your team unless they have permission to see them.  

[Sheri Widler]

I know i dont want to use the macro display. 
Can i automate the text to populate as text in the confluence page?  

Or if i could automate a row to be added to an excel and display the excel attached to a page?  

[Brant Schroeder]

@Sheri Widler You could use the Confluence API https://developer.atlassian.com/cloud/confluence/rest/v1/intro/#auth and Jira API https://developer.atlassian.com/cloud/jira/platform/rest/v3/intro/#version You would need to write something in between to pull the information from Jira and push it to Confluence

[Brant Schroeder]

@Sheri Widler can you accept this answer to help others?