We pull data from Jira to PowerBI using rest API Search functionality with below API call
We used https://**Our*Company**.atlassian.net/rest/api/latest/search?jql=project%20in%20(**Our*Project)&fields=(Fields*) to get below details for pagenation.
"expand": "schema,names",
"startAt": 0,
"maxResults": 100,
"total": 5081,
But recently Jira has migrated to below link
https://**Our*Company**.atlassian.net/rest/api/latest/search/jql?jql=project%20in%20(**Our*Project)&fields=(Fields*)
Which is not fetching any of header details(MaxResult or total) hence we are not able to pull data into PowerBI. Can you suggest how we can get header details with search rest API functionality ?
Welcome to Atlassian community and thank you for your question.
Try with the new parameters is last and nextpageToken, as indicated in the API doc: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-search/#api-rest-api-3-search-jql-get
The new API for Jql searchabia not performing very well, we hope it will be improved.
Regards
@Matteo Vecchiato Thank you Very much.
I was able to use "Is Last" and "Next page Token" to create pagination, it was bit of work but jql works fine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Could you share the syntax you used? I am in the same boat, and can't get pagination to work,
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.