Incremental load for JIRA Rest API in Qliksense

[Srivalli mamidi]

How to do Incremental load for JIRA rest API? As the full load consumes a lot of time. http://localhost:8080/rest/api/3/search
Thanks in Advance

[Muhammad Ramzan(Atlassian Certified Master) · Accepted solution]

Welcome to Atlassian community.  

You can use 

• startAt
• maxResults

to reduce the results.

example:  http://localhost:8080/rest/api/3/search?startAt=0&maxResults=20

Please let me know if i understand correctly and it solve your problem , Otherwise we can go for some other solutions.

[Srivalli mamidi]

Thanks for the reply.
But I don't want to reduce the results. As per my scenario, I want the complete data from JIRA when I do Incremental load I just want to get newly created/updated data and it should be added to the existing data in Qliksense.

If we reduce the result and fetch only latest results, then if the older issues are updated then we will miss that data.

[Muhammad Ramzan(Atlassian Certified Master)]

Please correct me if I understood correctly, you only need newly created/updated issues so you can update them into Qliksense.

In this case, as mentioned by @Daniel Ebers  please follow the document and you can only get the required results by using jql in rest .

Example

   http://localhost:8080/rest/api/2/search?jql=updated > "-2d"

 But please make your JQL accordingly so you can get the right results.

[Daniel Ebers]

Hi @Srivalli mamidi

as per documentation of REST API you could filter the data to be returned using a JQL query you know it from using in Jira directly.

However, like Muhammad noted correctly if the amount exceeds 1000 results you will need to use the pager like he mentioned.

So in summary it is both:

• selecting the data based on a JQL query criteria
• using the pager in case there are more than 1000 results from the query

Regards,
Daniel