Integration with Google Drive

[Albert Hristov]

Hello, All,

We have a requirement to store files from certain issues on Google Drive. We can easily detect these issues with JQL and I think we can send these attachments via Automation Rule and sending a Web Request.

I am unsure what the body of that request should contain though.

Does anyone have experience with such a task and can give me some tips on how to achieve the upload of all files from JQL selected issues to Google Drive?

Thank you in advance.

[Aron Gombas _Midori_]

I don't think that it can be done with Automation for Jira, because uploading large files to Google Drive would require a long-running "upload request" sent from AFJ to Google, which I think is not doable.

Solution if you can write code

You would need to write a script in Python or your favorite programming language that:

1. Runs the JQL 
2. Iterates over the result
   1. Downloads the attachments of the current issue
   2. Uploads those to Google Drive

I'm quite sure you will find a Python client library for GDrive which should make it fairly easy.

[CHINNAMUTHEVISAI_SATYANARAYANASHARMA]

Hi , One way you can do this as like ,

Export the Jql issue's to Excel sheet and save that Excel to your Google Drive .

when ever require, you can import those issues to the required project using inbuild Jira importing feauture.

i hope this may solve your issue . but automating this process is not possible i think.

Sorry for the wrong answer. i havent seen the word Attachments there.

for Attachments i dont know how we can do this . I'm following this request to know how we can do that.

Sorry again

[Alex Koxaras _Relational_]

Hi @Albert Hristov 

JQL provides only a list of issues which meet certain criteria. I'm not sure that you can use it, as is, to upload anything anywhere. I would suggest that you use an app from the marketplace https://marketplace.atlassian.com/search?product=jira&query=google%20drive to connect your instance to your google drive. Especially this app, can sync your files as well.

[Alex Koxaras _Relational_]

But feel free to look on your own for apps that suit your needs.

[Albert Hristov]

The app does not really offer what we need. We are storing a lot of files in a lot of issues and we need an Automation to go through all files and all issues of certain type which we can easily distinct via JQL. 

[Alex Koxaras _Relational_]

@Albert Hristov I've read your post twice, and yes I misunderstood what you wanted to achieve. So basically, you have in place your JQL and you have your issues which have all the attachments that you want to send to google drive. In order to upload them to google drive, for sure you have to look at this specific API.

For Jira I would use the:

GET /rest/api/3/attachment/content/{id}

from https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-attachments/#api-rest-api-3-attachment-content-id-get to get the attachment, but just to be honest, I haven't try it since there was no need.