{

public static class Data

{

internal static string user;

internal static string computerName;

internal static string dynamoVersion;

internal static string revitVersion;

internal static string ip;

internal static string latlng;

internal static string city;

internal static string country;

internal static string filename;

internal static string revit_build;

private static string date;

private static string ID;

/// <summary>

/// The general data collecting method

/// </summary>

/// <param name="vlp">View Loaded Parameters from Dynamo</param>

public static void Collect(ViewLoadedParams vlp)

{

// @todo if user does not consent, don't store..

// @todo provide a visual clue to the user that we are in the process of gathering data/geolocating IP which is delaying startup..

// Dynamo StartupParams

Data.dynamoVersion = vlp.StartupParams.DynamoVersion.ToString();

// @todo Determine whether the script is run from DynamoPlayer..

// Store the local environment data

Data.user = Environment.UserName;

Data.computerName = Environment.MachineName;

// @todo Define the revitVersion, leave blank or null if opened from any other environment (Sandbox, Civil3D etc)

Data.revitVersion = "2019.0.2";

// Request the IP and geolocation from ipinfo.io

WebClient client = new WebClient();

client.Headers.Set("Accept", "application/json");

var json = client.DownloadString("https://ipinfo.io");

// @todo We need to check the request was actually sent successfully and gracefully deal with cases where the API is unavailable

// Parse the JSON

JObject ipinfo = JObject.Parse(json);

// Store geolocation data

Data.ip = (string)ipinfo["ip"];

Data.latlng = (string)ipinfo["loc"];

Data.city = (string)ipinfo["city"];

Data.country = (string)ipinfo["country"];

}

/// <summary>

/// Record data from the Graph

/// </summary>

/// <param name="workspace">The Workspace - ie the Dynamo Graph</param>

public static void Record(WorkspaceModel workspace)

{

Data.filename = workspace.Name;

Data.ID = workspace.Guid.ToString();

// Data.filepath = workspace.FileName;

// Data.evaluationCount = workspace.EvaluationCount;

// Data.packages = workspace.Dependencies;

}

/// <summary>

/// Generate the export message to be recorded in Google Sheets

/// </summary>

/// <returns></returns>

internal static IList<IList<object>> Export()

{

IList<IList<object>> export = new List<IList<object>>();

// Set the date

// @todo "hh" is incorrectly returning values in the afternoon. It should be "14" not "2" etc for any hour after midday

date = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");

// Create and return a list of all the Data strings

var exportData = new List<object> { user, computerName, ip, latlng, city, country, dynamoVersion, revitVersion, filename, date, ID };

// Add Revit information if it exists

if (!string.IsNullOrEmpty(revit_build))

exportData.Add(revit_build);

export.Add(exportData);

return export;

}

}

/// <summary>

/// Exports the collected data to Google Sheets

/// </summary>

public static class ExportSheets

{

// If modifying these scopes, delete your previously saved credentials

// at ~/.credentials/sheets.googleapis.com-dotnet-quickstart.json

static string[] Scopes = { SheetsService.Scope.Spreadsheets };

static string ApplicationName = "Google Sheets API .NET Quickstart";

public static void Execute(IList<IList<object>> list)

{

//UserCredential credential;

string assembly = Utils.AssemblyDirectory;

string file = "dynamosheets.json";

//string file = "credentials.json";

string path = Path.GetFullPath(Path.Combine(assembly, @"..\", file));

string credPath = Path.GetFullPath(Path.Combine(assembly, @"..\", "token.json"));

//var certificate = new X509Certificate2(@"key.p12", "notasecret", X509KeyStorageFlags.Exportable);

ServiceAccountCredential credential;

string[] Scopes = { SheetsService.Scope.Spreadsheets };

string serviceAccountEmail = "binocularsserviceaccount@quickstart-1554479480474.iam.gserviceaccount.com";

using (Stream stream = new FileStream(path, FileMode.Open, FileAccess.Read, FileShare.Read))

{

credential = (ServiceAccountCredential)

GoogleCredential.FromStream(stream).UnderlyingCredential;

var initializer = new ServiceAccountCredential.Initializer(credential.Id)

{

User = serviceAccountEmail,

Key = credential.Key,

Scopes = Scopes

};

credential = new ServiceAccountCredential(initializer);

}

// Create Google Sheets API service.

var service = new SheetsService(new BaseClientService.Initializer()

{

HttpClientInitializer = credential,

ApplicationName = ApplicationName,

});

// Define request parameters.

// @todo Fetch these from a config.json file or environment variables?

String spreadsheetId = "1A7W8jXxCBpdluOqoOSpVATHcVtDlozI8WicGN1siYRc";

String spreadsheetTab = "Sheet1";

// Define the sheet range

var rng = string.Format("{0}!A1:A{1}", spreadsheetTab, list.Count);

var vRange = new ValueRange

{

Range = rng,

Values = list,

MajorDimension = "ROWS"

};

// Send the request to the Google Sheets API

var rqst = service.Spreadsheets.Values.Append(vRange, spreadsheetId, rng);

rqst.ValueInputOption = SpreadsheetsResource.ValuesResource.AppendRequest.ValueInputOptionEnum.USERENTERED;

rqst.Execute();

// @todo We need to check the request was actually sent successfully and gracefully deal with cases where the API is unavailable or a 403 forbidden occurs

}

}