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.

[Andrea Ho]

Hi @Albert Hristov I am a product manager in Jira working on a Google Shared drive integration to a Jira project. It's different to your scenario above, but I'm wondering if you'd be interested in taking a look before we release to give some feedback or input? If so, please feel free to book a time with me here: https://calendly.com/andreaho-atlassian/30mincall 

[Joe Buttigieg]

Hi Andrea,

Sorry to jump in on someone else's question but you mentioned that you are working on a Google Shared drive integration. Is that still the case.

I really like this add on https://marketplace.atlassian.com/apps/1223317/google-drive-and-docs-for-jira?hosting=cloud&tab=overview 

But we would need the ability to control all of this via API for what we need it for, and I can see API access has been on their request list for many years.

Our use case is:

• We have lots of client documents on Google Drive, broken up into sub folders by client and year
• We have a project set up per group of clients
• We have a Jira issue per client per year, and we want to display the GD documents for the client. 
• As there are thousands of clients, we want the ability to set the connect GD folder via API

As such, I was wondering how your project is going and whether it might be useful for our need.

[Andrea Ho]

Thank you for reaching out @Joe Buttigieg! We shipped a beta experience to a limited number of customers which was very limited in functionality - only allowing a whole shared drive to be connected to a whole Jira project.

This won't solve for your situation but we're still collecting insights on all the different use cases so this is very helpful for us as we hope to re-launch it with a much richer set of capabilities in the future.

If you're open to having a chat with us about how you use these products together we'd love to have a chat with you - you can send me an email to aho4@atlassian.com (I can't see your contact details via the community so I'll need you to reach out to me to initiate).

Many thanks,

Andrea

[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.