public async Task <string> ClearSheet()
{
Response.Headers.Add("Cache-Control", "no-cache");
string response = string.Empty;
string imagesFolderId = null;
string accountName = this._httpContextAccessor.HttpContext.Request.Headers[DriveImportConstants.VTEX_ACCOUNT_HEADER_NAME];
FolderIds folderIds = await _driveImportRepository.LoadFolderIds(accountName);
if (folderIds != null)
{
imagesFolderId = folderIds.ImagesFolderId;
ListFilesResponse spreadsheets = await _googleDriveService.ListSheetsInFolder(imagesFolderId);
if (spreadsheets != null)
{
SheetRange sheetRange = new SheetRange();
sheetRange.Ranges = new List <string>();
sheetRange.Ranges.Add($"A2:Z{DriveImportConstants.DEFAULT_SHEET_SIZE}");
foreach (GoogleFile sheet in spreadsheets.Files)
{
response = response + " - " + _googleDriveService.ClearSpreadsheet(sheet.Id, sheetRange).Result;
}
}
else
{
response = "null sheet";
}
}
else
{
response = "null folderIds";
}
return(response);
}