This article explains how to view more than 50 Jira issues in a JSON macro using maxResults.
Instructions
In the Advanced Table for Confluence app, the Jira Rest API shows 50 issues by default. In order to show more than 50 issues, you need to use &maxResults in the URL.
Please find the below example where the maxResults for the URL is given as 100:
<Jira URL>/rest/api/2/searchjql=project=<projectname>&os_username=xxxx&os_password=xxxx&maxResults=100
It needs to be used inside the URL of JSON data and get the result. Please check the below screenshot for reference:
In the above example, maxResults is given as 100. It previews 100 issues of the given project. You can use any number, which is greater than 50 to show those many records through the Jira Rest API.
The maximum number which can be used for maxResults is 1000.