Pre-requisite: you have all the credentials and authentication to access both Organizations' JIRA plus Confluence.
Is it possible to use query to pull JIRA status information automatically from two different JIRA instances that belong to two different origination then report them on one confluence page?
What would be the restrictions if any?
We had a scenario where we want to see one report instead of two reports for our own and vendor's progress. Wanting to put these information in one place and expecting it to update automatically through queries.
One is hosting on-prem another one is hosted on Cloud. The goal is to pull things from external Cloud host into the other (private hosted).