Heads up! On March 5, starting at 4:30 PM Central Time, our community will be undergoing scheduled maintenance for a few hours. During this time, you might find the site temporarily inaccessible. Thanks for your patience. Read more.
×Hi,
I'm trying to pull the basic data from Jira (cloud) into PowerBI and other than using a search endpoint of the API, nothing works.
For example,
passing https://<my site url>/rest/api/3/search?jql=project=MyProj url results in an error 400 Bad Request.
I do pass the Authorization="Basic <endcoded api key"> and this works when using the basic /search?project=MyProj, but any attempt to use jql fails.
Same error is when attempting /search?filter=1111.
The same url works fine in the browser.
Atlassian support helped me get the basic using the simple /search? endpoint, but jql and filter do not work.
The hard limit of the 100 issues returned by the search is another trouble as a single project where I'd need to start already contains 900+ issues, so we really need to bother fine-tune the query and figure out how to paginate it.
Any help will be appreciated.
Hi @Inna S ,
Best regards,
Alexey
Thank you, Alexey.
The problem is that I've started with the
rest/api/3/search?jql=project=MyProject
and while this works in the browser, it fails inside PowerBI with the (400): Bad Request error.
Replacing the project key with the project id makes no difference.
Your app looks cool, but we are looking for a different type of stats, outside of the scrum metrics world.
Thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Dan -minware- ,
thank you for suggestion.
Unfortunately I have a big issue with the Atlassian mode of work with any 3rd-party apps as they provide too much uncontrolled access to them with zero audit to the site admin. So whenever possible we avoid the marketplace apps.
But it is good to know there is a fallback option.
Thank you and good luck.
Inna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Inna S no problem. Please reach out if we can ever help!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Inna S - Sorry I don't have the answer here but it sounds like you are going to be pushing the limits of what's possible natively and wanted to suggest our 3rd party application (minware) - we are are able to work around these limitations and blend data from Jira, Git, Calendars, and CICD sources:
It is a paid 3rd party service but we offer a free trial if you want to check it out!
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.