Hi,
we have integrated the Jira API in Pentaho (Spoon) to extract data and save it in JSON. It's not very streamlined and some parts of the API are easy to use, some are not. Usually we can use pagination, since every JSON result contains a field with the total results.
We actually solved the issue with a Python script, where we use a loop, which runs until "isLast" is shown as a value - which actually means "End of Results" - it looks like:
"maxResults": 50,
"startAt": 0,
"isLast": false
"maxResults" just means it shows 50 results per request.
Now can we do loops with Pentaho? Is there a way to do Pagination without knowing the total results?
Thank you!
------------------------------
Daniel Michael Lozynski
Product Manager
DB Systel GmbH
------------------------------