/// <summary>
/// Recursively searches OneDrive for Business.
/// </summary>
/// <returns>A view listing the workbooks in OneDrive for Business.</returns>
public async Task <ActionResult> OneDriveFiles()
{
// Get access token
var token = Data.GetUserSessionToken(Settings.GetUserAuthStateId(ControllerContext.HttpContext), Settings.AzureADAuthority);
// Get all the Excel files in OneDrive for Business by using the Microsoft Graph API. Select only properties needed.
var fullWorkbooksSearchUrl = GraphApiHelper.GetWorkbookSearchUrl("?$select=name,id");
var getFilesResult = await ODataHelper.GetItems <ExcelWorkbook>(fullWorkbooksSearchUrl, token.AccessToken);
return(View(getFilesResult));
}
/// <summary>
/// Recursively searches OneDrive for Business.
/// </summary>
/// <returns>The names of the first three workbooks in OneDrive for Business.</returns>
public async Task <JsonResult> OneDriveFiles()
{
// Get access token
var token = Data.GetUserSessionToken(Settings.GetUserAuthStateId(ControllerContext.HttpContext), Settings.AzureADAuthority);
// Get all the Excel files in OneDrive for Business by using the Microsoft Graph API. Select only properties needed.
var fullWorkbooksSearchUrl = GraphApiHelper.GetWorkbookSearchUrl("?$select=name,id&top=3");
var filesResult = await ODataHelper.GetItems <ExcelWorkbook>(fullWorkbooksSearchUrl, token.AccessToken);
List <string> fileNames = new List <string>();
foreach (ExcelWorkbook workbook in filesResult)
{
fileNames.Add(workbook.Name);
}
return(Json(fileNames, JsonRequestBehavior.AllowGet));
}