[Dev] Investigate Persistent Connection for GDrive

[ryanrightmer]

Description

We need to see how we can have our server send data to a google drive without interactive login being required. We want to find out how we can be treated as a service principal, daemon, whatever.

Acceptance Criteria

• Prototype or really good documentation of how this can work.

Dev Notes

• We really don't want to hardcode secrets if we can avoid it. But using google secrets manager is probably acceptable

Who should I contact?

@ryanrightmer

Size of Ticket

S

[ryanrightmer]

Here's how we can access files with the the cloud run service account credential. We just need to share the desired folder with the service account compute email address

var credential = GoogleCredential.GetApplicationDefault();
var service = new DriveService(new BaseClientService.Initializer()
{
    HttpClientInitializer = credential,
    ApplicationName = "Drive API .NET Quickstart",
});
// Define parameters of request.
FilesResource.ListRequest listRequest = service.Files.List();
listRequest.PageSize = 10;
listRequest.Fields = "nextPageToken, files(id, name)";

// List files.
IList<Google.Apis.Drive.v3.Data.File> files = listRequest.Execute()
    .Files;
string returnString = "Files:\n";

if (files != null && files.Count > 0)
{
    foreach (var file in files)
    {
        returnString += $"{file.Name} ({file.Id})";
    }
}
else
{
    returnString = "No files found.";
}
Console.WriteLine(returnString);