Can jira API return the URL of an image in attachments ?

[Liviu Florea]

I want to use curl to download the images I have on an issue (as attachments).  The problem is the API doesn't return the URL that leads to these images. 

"content" : "https://INSERTCOMPANY.atlassian.net/secure/attachment/10013/image-20201217-080137.png"

The content field URL returned by the API is not what I'm looking for. When entered in the browser this url downloads the correct image, but since it doesn't actually point towards the image I can't use the curl function on it.

[Quoc Duan Thoi Ngoc]

Try use this: https://xxxxx.atlassian.net/rest/api/2/attachment/{attachment_id}

The attachment id can get from this:

https://xxxxx.atlassian.net/rest/api/latest/issue/{issue_id}

the above image url actually not a direct one to the image, but redirect with some additional validate behind the sence

[Prince Nyeche]

Hi @Liviu Florea 

Welcome to Community! You will need to parse the url in the API to get the right link for you to be able to download attachments.

[Liviu Florea]

Hi, 
I'm afraid I'm a bit lost. Can you elaborate on your last answer, maybe provide an example ?

[Prince Nyeche]

Hi @Liviu Florea 

What endpoint did you use? I would use the GET Issue endpoint if I want to get the full url for an attachment  from an issue then output the result. I can show an example but it's in python would that be preferable?

[Liviu Florea]

I have tried using the GET issue and GET attachments endpoints so far. I would appreciate seeing the python example.

[Prince Nyeche]

Hi @Liviu Florea 

I actually have a library where i'm trying to make extracting data from Jira Cloud easier via REST API. Here's an example code to extract attachment information using python and searching with JQL. You can see how I implemented the method here on Github on line 265.

from jiraone import LOGIN, PROJECT

user = "email"
password = "token"
link = "https://yourinstance.atlassian.net"
LOGIN(user=user, password=password, url=link)


if __name__ == '__main__':
# the output of the file would be absolute to the directory where this python file is being executed from
# you can use any valid jql query
jql = "project%20in%20(COM%2C%20PYT)%20order%20by%20created%20DESC"
PROJECT.get_attachments_on_projects(query=jql)

[susu_san]

Hi,

Please let me reply here as I am also having the same issue.

@Prince Nyeche  , I tried the above code of jiraone.

However, the "attachment_file.csv" is created with header only. There is no data inside.  there is no other response in the debugger also.

what could be a problem here? Did I miss anything?

[Prince Nyeche]

Do you have access to the project or are you able to view the project issues? Let me know what type of errors or output you're getting?

[susu_san]

@Prince Nyeche  Thanks for your response.

Yes I have access to the project and am able to view the project issues also.

when I run PROJECT.get_attachments_on_projects(query=jql) in Debug Console, below message appear.

There was no error in Terminal and no response.

[Prince Nyeche]

It seems this is caused by another dependency that I'm not familiar with. Please can you confirm that the above request is done with the example given in the above post?

[susu_san]

Yes, it's the same code. Please see the below screenshot.

I am trying to transfer attachments from bluecom to slsbearings. 

Manually importing CSV doesn't show the attachment files. then, I tried this code.

[Prince Nyeche]

Hi @susu_san 

I think on your device there might be something wrong with the Threading, I'm not so sure what it is based on the response you showed. So I think a better way for you to do this is to use this script instead. It has a config.ini file which you will need to add your login credentials there. Since this is a cloud-to-cloud transfer, add the same credential for the source and target section. Then add your JQL query on the script on line 36 as mentioned on the README file.