public async Task <HttpResponseMessage> GetSpreadsheet([FromBody] RequestModel request) { Guid testOutput; if (string.IsNullOrWhiteSpace(request.guid) || !Guid.TryParse(request.guid.TrimStart('t'), out testOutput)) { throw new System.Exception("Invalid GUID"); } // authenticate with Forge dynamic oauth = await Get2LeggedTokenAsync(new Scope[] { Scope.DataRead }); // get object on the bucket, should be just 1 ObjectsApi objects = new ObjectsApi(); objects.Configuration.AccessToken = oauth.access_token; dynamic objectsInBucket = await objects.GetObjectsAsync(request.guid); string objectId = string.Empty; string objectKey = string.Empty; foreach (KeyValuePair <string, dynamic> objInfo in new DynamicDictionaryItems(objectsInBucket.items)) { objectId = objInfo.Value.objectId; objectKey = objInfo.Value.objectKey; } string xlsFileName = objectKey.Replace(".rvt", ".xls"); var xlsPath = Path.Combine(HttpContext.Current.Server.MapPath("~/App_Data"), request.guid, xlsFileName); if (File.Exists(xlsPath)) { return(SendFile(xlsPath));// if the Excel file was already generated } DerivativesApi derivative = new DerivativesApi(); derivative.Configuration.AccessToken = oauth.access_token; // get the derivative metadata dynamic metadata = await derivative.GetMetadataAsync(objectId.Base64Encode()); foreach (KeyValuePair <string, dynamic> metadataItem in new DynamicDictionaryItems(metadata.data.metadata)) { dynamic hierarchy = await derivative.GetModelviewMetadataAsync(objectId.Base64Encode(), metadataItem.Value.guid); dynamic properties = await derivative.GetModelviewPropertiesAsync(objectId.Base64Encode(), metadataItem.Value.guid); Workbook xls = new Workbook(); foreach (KeyValuePair <string, dynamic> categoryOfElements in new DynamicDictionaryItems(hierarchy.data.objects[0].objects)) { string name = categoryOfElements.Value.name; Worksheet sheet = new Worksheet(name); for (int i = 0; i < 100; i++) { sheet.Cells[i, 0] = new Cell(""); // unless we have at least 100 cells filled, Excel understand this file as corrupted } List <long> ids = GetAllElements(categoryOfElements.Value.objects); int row = 1; foreach (long id in ids) { Dictionary <string, object> props = GetProperties(id, properties); int collumn = 0; foreach (KeyValuePair <string, object> prop in props) { sheet.Cells[0, collumn] = new Cell(prop.Key.ToString()); sheet.Cells[row, collumn] = new Cell(prop.Value.ToString()); collumn++; } row++; } xls.Worksheets.Add(sheet); } xls.Save(xlsPath); } return(SendFile(xlsPath)); }
private async Task <dynamic> GetModelDetailGuid(DerivativesApi api, string urn) { return(await api.GetMetadataAsync(urn)); }