Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,202
Community Members
 
Community Events
165
Community Groups

How do I get all tables using API

Hi I tried using python to get the issues but it does not show me the issues just count of. Has someone the correct script to use to GET the tables?

 

Hi I have same output running from a python script? do I need to authenticate the API with username and password?

I return this

{"startAt":0,"maxResults":50,"total":0,"issues":[]}

 

Using this

import requests
print('Beginning file download with requests')
url = 'https://team123.atlassian.net/rest/api/3/search?jql=ORDER%20BY%20Created '
r = requests.get(url, allow_redirects=True)
open('G:\test\issues', 'wb').write(r.content)
print(r.content)

1 answer

0 votes
Alex Community Leader Jun 08, 2022

Hi @Steve Dillon 

 

You won't have access to tables on Jira Cloud, and the search API allows you to search for issues as you could do from the UI.

The issue here is your JQL. Apparently, it's not returning anything from Jira search API based on the parameters sent and/or the permission your user has.

What do you see when you run this https://team123.atlassian.net/issues/?jql=order%20by%20created%20DESC ?

Try to adjust the criteria of your JQL search, and you will be able to pull results from the API call.

I hope this helps.

Cheers,

Alex

Hi Alex,

 

Thanks.

 

I get a lot more data now but dont see the actual created issues, I would like to get the issues for created and resolved, is the better option to run in the UI and then export to csv? I was hoping to automate the GET with the API as I dont have the server version install at this time.

 

Do I need to add my logon creds to get the actual data as all I see is meta.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you