Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
code:google_drive_report_delivery [2024/12/10 03:17] – created optrixcode:google_drive_report_delivery [2025/12/18 22:50] (current) – external edit 127.0.0.1
Line 1: Line 1:
 +====Google Drive Report Delivery====
  
 +The code below delivers reports to a Google Drive folder.
 +
 +Note that you need to...
 +
 +   * Have created a Google Cloud application,
 +   * Created a **Service Account** under that application with a **JSON** key,
 +   * Enabled the **Google Drive API** for the application,
 +   * Installed the **pydrive2** package in Python on the ReportList server, and
 +   * Copied your JSON key into the [[report_list:reports_directory|Report Directory]] named //googlekey.json//.
 +    * Shared the target folder(s) - with at least Edit permissions - with the service account user.
 +
 +===Destination===
 +
 +The destination (specified in your subscription in the reporting addon) should be the unique ID of the destination Google Drive folder. 
 +
 +For example, **gdrive#28372dgjs_22831** would upload data to the folder '28372dgjs_22831'. You can find this unique ID in the address bar when you open the Google Drive folder in your browser.
 +
 +Note that //you must share this folder with the service account user in Google Drive to be permitted to write files//.
 +
 +<code python>
 +import time
 +import sys
 +import requests
 +import datetime
 +import os
 +import json
 +import traceback
 +import os
 +from pydrive2.auth import GoogleAuth
 +from pydrive2.drive import GoogleDrive
 +from oauth2client.service_account import ServiceAccountCredentials
 +
 +failedfiles = []
 +failreason = None
 +
 +f = open(sys.argv[1])
 +content = f.read()
 +f.close()
 +
 +details = json.loads(content)
 +
 +jsonfile=os.path.dirname(__file__) + "/googlekey.json"
 +
 +# Define the Google Drive API scopes and service account file path
 +
 +gauth = GoogleAuth()
 +
 +# NOTE: if you are getting storage quota exceeded error, create a new service account, and give that service account permission to access the folder and replace the google_credentials.
 +
 +gauth.credentials = ServiceAccountCredentials.from_json_keyfile_name(jsonfile, scopes=['https://www.googleapis.com/auth/drive'])
 +
 +drive = GoogleDrive(gauth)
 +
 +print("Setup Connection to Google Drive")
 +
 +# ID of channel that you want to upload file to
 +for d in details['destinations']:
 +    folder_id = d['name']        
 +
 +    for att in d['attachments']:
 +        try:
 +            # Uploading files requires the `files:write` scope
 +            file1 = drive.CreateFile( {'parents': [{"id": folder_id}], 'title': att[1]})
 +    
 +            file1.SetContentFile(att[0])
 +            file1.Upload()                                
 +                         
 +        except:                
 +            traceback.print_exc()  
 +            failedfiles.append(att[1])
 +            if failreason is not None:
 +                failreason += " / Could Not Upload"
 +            else:
 +                failreason = "Could Not Upload"
 +                
 +if len(failedfiles) > 0:
 +    print("-----")
 +    print(failreason)
 +else:
 +    print("-----")
 +    print("SUCCESS")
 +    
 +</code>

ARDI

Welcome Guides

User Guides

Administrative

Sever
Other

API / SDK

Scripting

Addons / Drivers

Other Media