Data fetched through API

[Mayur Gaikwad_Tech PMO]

Hi,

Whenever we call a GET status API, does the sequence of call IDs changes in response everytime we hit?

Because, Im trying to load these fetched information in a table and I'm getting duplicate records. This is done at a batches of 100 records at a max and seems some calls are getting fetched in each of the batches resulting to duplicate records.

[Marc - Devoteam]

Hi @Mayur Gaikwad_Tech PMO 

What call are you making?

If you need more then the first 100 results, you need to use pagination in your calls.

See, API pagination 

[Mayur Gaikwad_Tech PMO]

Its a GET request

https://xxx.atlassian.net/rest/api/2/search?jql=project=xxx&maxResults=100&startAt=0

[Mayur Gaikwad_Tech PMO]

@Marc - Devoteam How can i achieve pagination in URL, like its a GET status API, i cannot pass this in body as a request, right?

[Marc - Devoteam]

So then you need to make a new call, that specifies startAt=101 at the end to get more results then the first 100

[Mayur Gaikwad_Tech PMO]

Yes, Im doing that but its in URL, and when doing so, it seems few call IDs are coming in 2 or more batches causing duplicate record issue

[Marc - Devoteam]

Hi @Mayur Gaikwad_Tech PMO 

What is the JQL you are using in the Get action, does it use and order by clause?

If it doesn't duplicates can occur.

[Mayur Gaikwad_Tech PMO]

Let me try adding the order by clause, but is there a 'distinct' or 'unique' identified that can be used with order by clause?

[Marc - Devoteam]

Hi @Mayur Gaikwad_Tech PMO 

Loads of options.

Order by key, due date, ..., see ORDER-BY