public GetReportResult GetReport(string reportId)
{
if (string.IsNullOrWhiteSpace(reportId))
{
throw new ArgumentNullException("reportId is empty");
}
nLogger.Info("GetReport for : " + reportId);
GetReportRequest req = new GetReportRequest();
req.MWSAuthToken = serviceContext.MwsAuthToken;
if (string.IsNullOrEmpty(req.MWSAuthToken))
{
req.MWSAuthToken = "MWSAuthToken";
}
req.Merchant = serviceContext.SellerId;
req.ReportId = reportId;
GetReportResponse response = null;
try
{
response = service.GetReport(req);
}
catch (Exception e)
{
nLogger.Error("GetReport Failed");
throw;
}
return(response.GetReportResult);
}
public void InvokeGetReport(Operations.Reports.MarketplaceWebService client, GetReportRequest requestReport)
{
try
{
GetReportResponse response = null;
response = client.GetReport(requestReport);
Console.WriteLine("Service Response");
Console.WriteLine("=============================================================================");
Console.WriteLine();
Console.WriteLine(" GetReportResponse");
if (response.IsSetGetReportResult())
{
Console.WriteLine(" GetReportResult");
GetReportResult getReportResult = response.GetReportResult;
if (getReportResult.IsSetContentMD5())
{
Console.WriteLine(" ContentMD5");
Console.WriteLine(" {0}", getReportResult.ContentMD5);
}
}
if (response.IsSetResponseMetadata())
{
Console.WriteLine(" ResponseMetadata");
ResponseMetadata responseMetadata = response.ResponseMetadata;
if (responseMetadata.IsSetRequestId())
{
Console.WriteLine(" RequestId");
Console.WriteLine(" {0}", responseMetadata.RequestId);
}
}
Console.WriteLine(" ResponseHeaderMetadata");
Console.WriteLine(" RequestId");
Console.WriteLine(" " + response.ResponseHeaderMetadata.RequestId);
Console.WriteLine(" ResponseContext");
Console.WriteLine(" " + response.ResponseHeaderMetadata.ResponseContext);
Console.WriteLine(" Timestamp");
Console.WriteLine(" " + response.ResponseHeaderMetadata.Timestamp);
}
catch (MarketplaceWebServiceException ex)
{
Console.WriteLine("Caught Exception: " + ex.Message);
Console.WriteLine("Response Status Code: " + ex.StatusCode);
Console.WriteLine("Error Code: " + ex.ErrorCode);
Console.WriteLine("Error Type: " + ex.ErrorType);
Console.WriteLine("Request ID: " + ex.RequestId);
Console.WriteLine("XML: " + ex.XML);
Console.WriteLine("ResponseHeaderMetadata: " + ex.ResponseHeaderMetadata);
}
}
private void GetInventoryReport(ERPContext context, string accountName, string reportId)
{
GetReportRequest request = new GetReportRequest();
request.MWSAuthToken = mwsAuthTokenDictionary[accountName];
request.Merchant = sellerIdDictionary[accountName];
request.ReportId = reportId;
MemoryStream stream = new MemoryStream();
request.Report = stream;
GetReportResponse response = mwsClient.GetReport(request);
ParseInventoryReport(context, accountName, stream);
}
/// <summary>
/// 日报 周报接口
/// </summary>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <param name="timeType"></param>
/// <returns></returns>
public GetReportResponse GetReport(string startTime, string endTime, string timeType)
{
GetReportResponse res = null;
try
{
res = handler.GetReport(startTime, endTime, timeType);
}
catch (Exception ex)
{
LogHelper.Error("OpenApi.GetReport", ex);
}
return(res);
}
/// <summary>
/// The GetReport operation returns the contents of a report. Reports can potentially be
/// very large (>100MB) which is why we only return one report at a time, and in a
/// streaming fashion.
///
/// </summary>
/// <param name="service">Instance of MarketplaceWebService service</param>
/// <param name="request">GetReportRequest request</param>
private static void invokeGetReport(MarketplaceWebService.MarketplaceWebService service, GetReportRequest request)
{
try
{
Console.WriteLine("Downloading report...");
GetReportResponse response = service.GetReport(request);
Console.WriteLine("Downloaded!");
}
catch (MarketplaceWebServiceException ex)
{
Console.WriteLine("Caught Exception: " + ex.Message);
Console.WriteLine("Please try again in a couple of minutes."); //Exception might be because of Amazon's limit of downloading a report once a minute. Try in a couple of min.
}
}
private void Setup_GetReport_Returns_ReportContentStream(string expectedGeneratedReportId, string reportContent)
{
var stream = StreamHelper.CreateMemoryStream(reportContent);
var validMd5Hash = MD5ChecksumHelper.ComputeHashForAmazon(stream);
var response = new GetReportResponse
{
ResponseHeaderMetadata = new ResponseHeaderMetadata("requestId", "responseContext", "timestamp"),
GetReportResult = new GetReportResult {
ContentMD5 = validMd5Hash
}
};
_mwsClientMock
.Setup(mws => mws.GetReport(It.Is <GetReportRequest>(grr => grr.ReportId == expectedGeneratedReportId && grr.Merchant == _merchantId)))
.Callback <GetReportRequest>(request => { stream.CopyTo(request.Report); })
.Returns(response);
}
/// <summary>
/// The GetReport operation returns the contents of a report. Reports can potentially be
/// very large (>100MB) which is why we only return one report at a time, and in a
/// streaming fashion.
///
/// </summary>
/// <param name="service">Instance of MarketplaceWebService service</param>
/// <param name="request">GetReportRequest request</param>
public static void InvokeGetReport(MarketplaceWebService service, GetReportRequest request)
{
try
{
GetReportResponse response = service.GetReport(request);
Console.WriteLine("Service Response");
Console.WriteLine("=============================================================================");
Console.WriteLine();
Console.WriteLine(" GetReportResponse");
if (response.IsSetGetReportResult())
{
Console.WriteLine(" GetReportResult");
GetReportResult getReportResult = response.GetReportResult;
if (getReportResult.IsSetContentMD5())
{
Console.WriteLine(" ContentMD5");
Console.WriteLine(" {0}", getReportResult.ContentMD5);
}
}
if (response.IsSetResponseMetadata())
{
Console.WriteLine(" ResponseMetadata");
ResponseMetadata responseMetadata = response.ResponseMetadata;
if (responseMetadata.IsSetRequestId())
{
Console.WriteLine(" RequestId");
Console.WriteLine(" {0}", responseMetadata.RequestId);
}
}
}
catch (MarketplaceWebServiceException ex)
{
Console.WriteLine("Caught Exception: " + ex.Message);
Console.WriteLine("Response Status Code: " + ex.StatusCode);
Console.WriteLine("Error Code: " + ex.ErrorCode);
Console.WriteLine("Error Type: " + ex.ErrorType);
Console.WriteLine("Request ID: " + ex.RequestId);
Console.WriteLine("XML: " + ex.XML);
}
}
public async Task <GetReportResponse> GetReport()
{
GetReportResponse result = null;
string path = $"/api/GetReport";
string absolutePath = $"{path}";
using (HttpResponseMessage response = await _httpClientWrapper.GetAsync(HttpClientConfigName.UserService, absolutePath, CancellationToken.None).ConfigureAwait(false))
{
response.EnsureSuccessStatusCode();
string content = await response.Content.ReadAsStringAsync();
var requestResponse = JsonConvert.DeserializeObject <ResponseWrapper <GetReportResponse, UserServiceErrorCode> >(content);
if (requestResponse.HasContent && requestResponse.IsSuccessful)
{
result = requestResponse.Content;
}
}
return(result);
}
private static void AssertGetReportRequest(GetReportResponse response)
{
// folderMaxFiles property
Assert.IsTrue(response.LargestFolderFiles >= 0);
// folderMaxMiB property
Assert.IsTrue(response.LargestFolderMebibyte >= 0);
// longVersion property
StringAssert.Contains(response.LongVersion, "syncthing");
// memorySize property
Assert.IsTrue(response.MemorySize > 0);
// memoryUsageMiB property
Assert.IsTrue(response.MemoryUsageMebibyte > 0);
// numDevices property
Assert.IsTrue(response.DeviceCount >= 0);
// numFolders property
Assert.IsTrue(response.FolderCount >= 0);
// platform property
Assert.IsFalse(string.IsNullOrWhiteSpace(response.Platform));
// sha256Perf property
Assert.IsTrue(response.CryptPerformance >= 0f);
// totFiles property
Assert.IsTrue(response.TotalFilesCount >= 0);
// totMiB property
Assert.IsTrue(response.TotalMebibyteCount >= 0);
// uniqueID property
Assert.IsFalse(string.IsNullOrWhiteSpace(response.UniqueIdentifier));
// version property
Assert.IsFalse(string.IsNullOrWhiteSpace(response.Version));
}
public async Task <IActionResult> Run(
[HttpTrigger(AuthorizationLevel.Function, "get", Route = null)]
GetReportRequest req,
ILogger log)
{
try
{
log.LogInformation("C# HTTP trigger function processed a request.");
GetReportResponse response = await _mediator.Send(req);
return(new OkObjectResult(ResponseWrapper <GetReportResponse, RequestServiceErrorCode> .CreateSuccessfulResponse(response)));
}
catch (Exception exc)
{
log.LogError("Exception occured in Log Request", exc);
return(new ObjectResult(ResponseWrapper <GetReportResponse, RequestServiceErrorCode> .CreateUnsuccessfulResponse(RequestServiceErrorCode.InternalServerError, "Internal Error"))
{
StatusCode = StatusCodes.Status500InternalServerError
});
}
}
public void GetReportTest()
{
MarketplaceWebServiceConfig config = new MarketplaceWebServiceConfig();
config.ServiceURL = serviceURL;
MarketplaceWebService.MarketplaceWebService service =
new MarketplaceWebServiceClient(
creds.AccessKey,
creds.SecretKey,
appName,
appVersion,
config);
GetReportRequest request = new GetReportRequest();
request.Merchant = sellerId;
request.MWSAuthToken = mWSAuthToken; // Optional
//@TODO: set additional request parameters here
request.ReportId = "123";
GetReportResponse response = service.GetReport(request);
}
public Stream GetReport(string ReportId)
{
this.Throttle();
AmazonCredential Credentials = this.GetCredential();
MarketplaceWebServiceClient Client = this.GetClient(Credentials);
MemoryStream ReportStream = new MemoryStream();
GetReportRequest Request = new GetReportRequest()
{
Merchant = Credentials.MerchantID,
ReportId = ReportId,
Report = ReportStream
};
GetReportResponse Response = Client.GetReport(Request);
if (Response.IsSetGetReportResult())
{
return(ReportStream);
}
else
{
return(null);
}
}
public async Task <IActionResult> Run(
[HttpTrigger(AuthorizationLevel.Function, "get", Route = null)]
GetReportRequest req,
ILogger log)
{
try
{
NewRelic.Api.Agent.NewRelic.SetTransactionName("UserService", "GetReport");
log.LogInformation("C# HTTP trigger function processed a request.");
GetReportResponse response = await _mediator.Send(req);
return(new OkObjectResult(ResponseWrapper <GetReportResponse, UserServiceErrorCode> .CreateSuccessfulResponse(response)));
}
catch (Exception exc)
{
LogError.Log(log, exc, req);
return(new ObjectResult(ResponseWrapper <GetReportResponse, UserServiceErrorCode> .CreateUnsuccessfulResponse(UserServiceErrorCode.UnhandledError, "Internal Error"))
{
StatusCode = StatusCodes.Status500InternalServerError
});
}
}
private static string AdlsAccountName = ""; // Name of the Azure Data Lake Store
static void Main(string[] args)
{
// Fetching Prerequisites Data from Azure SQL Server
using (SqlConnection con = new SqlConnection(connectionString))
{
// Fetching data from Report Config Table
SqlCommand cmd = new SqlCommand("USE CommerceLabsDW;OPEN SYMMETRIC KEY SymmetricKey1 DECRYPTION BY CERTIFICATE Certificate1; SELECT CONVERT(varchar(max), DECRYPTBYKEY(SellerCentral_LoginID)), CONVERT(varchar(max), DECRYPTBYKEY(SellerCentral_LoginPWD)), CONVERT(varchar(max), DECRYPTBYKEY(ADS_RefreshToken)), CONVERT(varchar(max), DECRYPTBYKEY(ADS_ClientID)), CONVERT(varchar(max), DECRYPTBYKEY(ADS_ClientSecret)), CONVERT(varchar(max), DECRYPTBYKEY(ADS_Scope)), CONVERT(varchar(max), DECRYPTBYKEY(WP_Authorization)), CONVERT(varchar(max), DECRYPTBYKEY(MWS_AccessID)), CONVERT(varchar(max), DECRYPTBYKEY(MWS_SecretKey)), CONVERT(varchar(max), DECRYPTBYKEY(MWS_MerchantID)), CONVERT(varchar(max), DECRYPTBYKEY(MWS_AuthToken)), CONVERT(varchar(max), DECRYPTBYKEY(Azure_ClientID)), CONVERT(varchar(max), DECRYPTBYKEY(Azure_ClientSecret)), CONVERT(varchar(max), DECRYPTBYKEY(Azure_TenantID)), CONVERT(varchar(max), DECRYPTBYKEY(Azure_DataLakeName)) FROM stage.rpt_ConfigTable WHERE ID = 1; ", con);
//Opening the Connection
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
SC_LoginID = reader.GetString(0);
SC_LoginPwd = reader.GetString(1);
ADS_RefreshToken = reader.GetString(2);
ADS_ClientID = reader.GetString(3);
ADS_ClientSecret = reader.GetString(4);
ADS_Scope = reader.GetString(5);
WP_Authorization = reader.GetString(6);
MWS_AccessID = reader.GetString(7);
MWS_SecretKey = reader.GetString(8);
MWS_MerchantID = reader.GetString(9);
MWS_AuthToken = reader.GetString(10);
AzureClientId = reader.GetString(11);
AzureClientSecret = reader.GetString(12);
AzureTenantId = reader.GetString(13);
AdlsAccountName = reader.GetString(14);
}
//Closing the Connection
con.Close();
}
// Azure Data Lake Initialisation
SynchronizationContext.SetSynchronizationContext(new SynchronizationContext());
var clientCredential = new ClientCredential(AzureClientId, AzureClientSecret);
var creds = ApplicationTokenProvider.LoginSilentAsync(AzureTenantId, clientCredential).Result;
adlsFileSystemClient = new DataLakeStoreFileSystemManagementClient(creds);
string Azuresource = "", Azuredestination = ""; // Azure Source and Destination Variable
// Creating a Folder in the App Path
var directoryFullPath = AppDomain.CurrentDomain.BaseDirectory + @"DownloadedReports\"; // Creating a Folder in Current Directory if not exists
Directory.CreateDirectory(directoryFullPath);
// Web Driver Object
IWebDriver driver;
// Setting the needed Chrome Options
ChromeOptions options = new ChromeOptions();
options.AddUserProfilePreference("download.default_directory", directoryFullPath); // Setting the default directory for the report to be downloaded
options.AddUserProfilePreference("intl.accept_languages", "en-us"); // Setting the language as English
// options.AddArgument("--headless"); // Setting headless browser option
driver = new ChromeDriver(options); // Assigning all the above options to Chrome Driver
Console.WriteLine("Started");
// Amazon Seller Central Login Page
driver.Navigate().GoToUrl("https://sellercentral.amazon.com/");
driver.FindElement(By.ClassName("secondary")).Click();
driver.FindElement(By.Id("ap_email")).SendKeys(SC_LoginID);
driver.FindElement(By.Id("ap_password")).SendKeys(SC_LoginPwd);
driver.FindElement(By.Id("signInSubmit")).Click();
/*// Generating OTP
* var otpKeyStr = "WGHSYZEE2RJOO6OFMCBMB6HKNHDZRADH4TK2FDJ77YWQ5YFRWDBQ"; // 2FA secret key.
* var otpKeyBytes = Base32Encoding.ToBytes(otpKeyStr);
* var totp = new Totp(otpKeyBytes);
* var twoFactorCode = totp.ComputeTotp(DateTime.UtcNow); // 2FA code at this time!
* Console.WriteLine(twoFactorCode);*/
// OTP
Console.WriteLine("Please enter the OTP : ");
var input = Console.ReadLine();
driver.FindElement(By.Id("auth-mfa-otpcode")).SendKeys(input);
driver.FindElement(By.Id("auth-mfa-remember-device")).Click();
driver.FindElement(By.Id("auth-signin-button")).Click();
// ------------------ REPORT 1 ------------------ // ---- Automating Scraping Method -----
// Downloading Business Report
driver.Navigate().GoToUrl("https://sellercentral.amazon.com/gp/site-metrics/report.html#reportID=102%3ADetailSalesTrafficBySKU&runDate=&fromDate=&toDate=");
driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(1000);
Thread.Sleep(1000);
// Downloading Past 3 Days' Reports by looping through dates
for (int i = -1; i > -4; i--)
{
// Looping through Dates and setting the Date Value
var DateValue = DateTime.Now.AddDays(i).ToString("MM/dd/yyyy").Replace("-", "/");
// Setting From Date
IWebElement FromDateBox = driver.FindElement(By.Id("fromDate2"));
FromDateBox.Clear();
FromDateBox.SendKeys(DateValue + Keys.Enter);
// Setting To Date
IWebElement ToDateBox = driver.FindElement(By.Id("toDate2"));
ToDateBox.Clear();
ToDateBox.SendKeys(DateValue + Keys.Enter);
// Downloading the Report
Thread.Sleep(1000);
driver.FindElement(By.Id("export")).Click();
Thread.Sleep(1000);
driver.FindElement(By.Id("downloadCSV")).Click();
Thread.Sleep(1000);
// Editing the Business Report CSV
string BusRepfilePath = directoryFullPath + "BusinessReport-" + DateTime.Now.AddDays(-1).ToString("MM/dd/yy") + ".csv";
Thread.Sleep(1000);
// Transaction Date
var Buscol1 = File.ReadLines(BusRepfilePath).Select((line, index) => index == 0 ? line + ", Transaction Date"
: line + "," + DateValue.Replace("/", "-")).ToList();
File.WriteAllLines(BusRepfilePath, Buscol1);
// Account
var Buscol2 = File.ReadLines(BusRepfilePath).Select((line, index) => index == 0 ? line + ",Account"
: line + ",Meal Prep Haven").ToList();
File.WriteAllLines(BusRepfilePath, Buscol2);
// Country
var Buscol3 = File.ReadLines(BusRepfilePath).Select((line, index) => index == 0 ? line + ",Country"
: line + ",US").ToList();
File.WriteAllLines(BusRepfilePath, Buscol3);
// Reference URL
var Buscol4 = File.ReadLines(BusRepfilePath).Select((line, index) => index == 0 ? line + ",Reference"
: line + "," + driver.Url).ToList();
File.WriteAllLines(BusRepfilePath, Buscol4);
// Renaming the Report File
File.Move(BusRepfilePath, directoryFullPath + "BusinessReport" + i + ".csv");
}
// Combining all the CSV Files into 1
string BussourceFolder = directoryFullPath;
string BusdestinationFile = directoryFullPath + "BusinessReport-" + DateTime.Now.ToString("dd/MM/yyyy") + ".csv";
// Matches the CSV files by searching the specified wildcard and combines them to single file
string[] filePaths = Directory.GetFiles(BussourceFolder, "BusinessReport-?.csv");
StreamWriter fileDest = new StreamWriter(BusdestinationFile, true);
for (int j = 0; j < filePaths.Length; j++)
{
string file = filePaths[j];
string[] lines = File.ReadAllLines(file);
if (j > 0)
{
lines = lines.Skip(1).ToArray(); // Skipping Header row for all except first file
}
foreach (string line in lines)
{
fileDest.WriteLine(line);
}
}
fileDest.Close();
// Uploading Business Report to Azure Data Lake
Azuresource = directoryFullPath + @"BusinessReport-" + DateTime.Now.ToString("dd/MM/yyyy") + ".csv";
Azuredestination = "Meal prep haven/CA_AO/Business Reports/" + "BusinessReport-" + DateTime.Now.ToString("dd/MM/yyyy") + ".csv";
adlsFileSystemClient.FileSystem.UploadFile(AdlsAccountName, Azuresource, Azuredestination, 1, false, true);
Console.WriteLine("Uploaded Business Report");
// Deleting the Business Report Files
Array.ForEach(Directory.GetFiles(directoryFullPath), File.Delete);
// ------------------ REPORT 2 ------------------ // ---- Automating Scraping Method ----
// Downloading Reserved Inventory Report
driver.Navigate().GoToUrl("https://sellercentral.amazon.com/gp/ssof/reports/search.html#orderAscending=&recordType=ReserveBreakdown&noResultType=&merchantSku=&fnSku=&FnSkuXORMSku=&reimbursementId=&orderId=&genericOrderId=&asin=&lpn=&shipmentId=&problemType=ALL_DEFECT_TYPES&hazmatStatus=&inventoryEventTransactionType=&fulfillmentCenterId=&transactionItemId=&inventoryAdjustmentReasonGroup=&eventDateOption=1&fromDate=mm%2Fdd%2Fyyyy&toDate=mm%2Fdd%2Fyyyy&startDate=&endDate=&fromMonth=1&fromYear=2019&toMonth=1&toYear=2019&startMonth=&startYear=&endMonth=&endYear=&specificMonth=1&specificYear=2019");
Thread.Sleep(1000);
driver.FindElement(By.XPath("//*[@id=\"requestCsvTsvDownload\"]/tr[1]/td[2]/button")).Click();
driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(1000);
Thread.Sleep(10000);
driver.FindElement(By.XPath("//*[@id=\"downloadArchive\"]/table/tbody/tr[1]/td[5]/a")).Click();
// Editing the Reserved Inventory CSV
// Appending Columns and Values in Existing CSV File
string ResRepfilePath = "";
foreach (string filename in Directory.GetFiles(directoryFullPath))
{
ResRepfilePath = directoryFullPath + Path.GetFileName(filename); // Getting the File Name
}
// Account
var Rescol1 = File.ReadLines(ResRepfilePath).Select((line, index) => index == 0 ? line + ",Account"
: line + ",Meal Prep Haven").ToList();
File.WriteAllLines(ResRepfilePath, Rescol1);
// Country
var Rescol2 = File.ReadLines(ResRepfilePath).Select((line, index) => index == 0 ? line + ",Country"
: line + ",US").ToList();
File.WriteAllLines(ResRepfilePath, Rescol2);
// Reference URL
var Rescol3 = File.ReadLines(ResRepfilePath).Select((line, index) => index == 0 ? line + ",Reference"
: line + "," + driver.Url).ToList();
File.WriteAllLines(ResRepfilePath, Rescol3);
// Transaction Date
var Rescol4 = File.ReadLines(ResRepfilePath).Select((line, index) => index == 0 ? line + ", Transaction Date"
: line + "," + DateTime.Now.ToString("MM/dd/yyyy")).ToList();
File.WriteAllLines(ResRepfilePath, Rescol4);
// Renaming the Report File
File.Move(ResRepfilePath, directoryFullPath + "ReservedInventoryReport.csv");
// Uploading Reserved Inventory Report to Azure Data Lake
Azuresource = directoryFullPath + "ReservedInventoryReport.csv";
Azuredestination = "Meal prep haven/CA_AO/Reserved Inventory Reports/" + "ReservedInventoryReport-" + DateTime.Now.ToString("dd/MM/yyyy") + ".csv";
adlsFileSystemClient.FileSystem.UploadFile(AdlsAccountName, Azuresource, Azuredestination, 1, false, true);
Console.WriteLine("Uploaded Reserved Inventory Report");
// Deleting the Reserved Inventory Report File
Array.ForEach(Directory.GetFiles(directoryFullPath), File.Delete);
// ------------------ REPORT 3 ------------------ // ---- Automating Scraping Method ----
// Downloading Managed Inventory Report
driver.Navigate().GoToUrl("https://sellercentral.amazon.com/gp/ssof/reports/search.html?#orderAscending=&recordType=FBA_MYI_UNSUPPRESSED_INVENTORY&noResultType=&merchantSku=&fnSku=&FnSkuXORMSku=&reimbursementId=&orderId=&genericOrderId=&asin=&lpn=&shipmentId=&problemType=ALL_DEFECT_TYPES&hazmatStatus=&inventoryEventTransactionType=&fulfillmentCenterId=&transactionItemId=&inventoryAdjustmentReasonGroup=&eventDateOption=1&fromDate=mm%2Fdd%2Fyyyy&toDate=mm%2Fdd%2Fyyyy&startDate=&endDate=&fromMonth=1&fromYear=2019&toMonth=1&toYear=2019&startMonth=&startYear=&endMonth=&endYear=&specificMonth=1&specificYear=2019");
Thread.Sleep(1000);
driver.FindElement(By.XPath("//*[@id=\"requestCsvTsvDownload\"]/tr[1]/td[2]/button")).Click();
driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(1000);
Thread.Sleep(10000);
driver.FindElement(By.XPath("//*[@id=\"downloadArchive\"]/table/tbody/tr[1]/td[5]/a")).Click();
// Editing the Managed Inventory CSV
// Appending Columns and Values in Existing CSV File
string ManRepfilePath = "";
foreach (string filename in Directory.GetFiles(directoryFullPath))
{
ManRepfilePath = directoryFullPath + Path.GetFileName(filename); // Getting the File Name
}
// Account
var Mancol1 = File.ReadLines(ManRepfilePath).Select((line, index) => index == 0 ? line + ",Account"
: line + ",Meal Prep Haven").ToList();
File.WriteAllLines(ManRepfilePath, Mancol1);
// Country
var Mancol2 = File.ReadLines(ManRepfilePath).Select((line, index) => index == 0 ? line + ",Country"
: line + ",US").ToList();
File.WriteAllLines(ManRepfilePath, Mancol2);
// Reference URL
var Mancol3 = File.ReadLines(ManRepfilePath).Select((line, index) => index == 0 ? line + ",Reference"
: line + "," + driver.Url).ToList();
File.WriteAllLines(ManRepfilePath, Mancol3);
// Transaction Date
var Mancol4 = File.ReadLines(ManRepfilePath).Select((line, index) => index == 0 ? line + ", Transaction Date"
: line + "," + DateTime.Now.ToString("MM/dd/yyyy")).ToList();
File.WriteAllLines(ManRepfilePath, Mancol4);
// Renaming the Report File
File.Move(ManRepfilePath, directoryFullPath + "ManagedInventoryReport.csv");
// Uploading Reserved Inventory Report to Azure Data Lake
Azuresource = directoryFullPath + "ManagedInventoryReport.csv";
Azuredestination = "Meal prep haven/CA_AO/Managed Inventory Reports/" + "ManagedInventoryReport-" + DateTime.Now.ToString("dd/MM/yyyy") + ".csv";
adlsFileSystemClient.FileSystem.UploadFile(AdlsAccountName, Azuresource, Azuredestination, 1, false, true);
Console.WriteLine("Uploaded Managed Inventory Report");
// Deleting the Managed Inventory Report File
Array.ForEach(Directory.GetFiles(directoryFullPath), File.Delete);
// ------------------ REPORT 4 ------------------ // ---- Automating Scraping Method ----
// Downloading Payment Report
driver.Navigate().GoToUrl("https://sellercentral.amazon.com/payments/reports/custom/request?tbla_daterangereportstable=sort:%7B%22sortOrder%22%3A%22DESCENDING%22%7D;search:undefined;pagination:1;");
Thread.Sleep(1000);
driver.FindElement(By.XPath("//*[@id=\"drrGenerateReportButton\"]/span/input")).Click();
driver.FindElement(By.XPath("//*[@id=\"drrReportTypeRadioTransaction\"]")).Click();
driver.FindElement(By.XPath("//*[@id=\"drrReportRangeTypeRadioCustom\"]")).Click();
driver.FindElement(By.XPath("//*[@id=\"drrFromDate\"]")).SendKeys(DateTime.Now.AddDays(-2).ToString("MM/dd/yyyy").Replace("-", "/") + Keys.Enter);
driver.FindElement(By.XPath("//*[@id=\"drrToDate\"]")).SendKeys(DateTime.Now.AddDays(-2).ToString("MM/dd/yyyy").Replace("-", "/") + Keys.Enter);
driver.FindElement(By.XPath("//*[@id=\"drrGenerateReportsGenerateButton\"]/span/input")).Click();
driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(1000);
driver.FindElement(By.ClassName("drrRefreshTable")).Click();
driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(1000);
Thread.Sleep(10000);
driver.FindElement(By.XPath("//*[@id=\"downloadButton\"]")).Click();
// Editing the Payment CSV
// Appending Columns and Values in Existing CSV File
string PayRepfilePath = "";
foreach (string filename in Directory.GetFiles(directoryFullPath))
{
PayRepfilePath = directoryFullPath + Path.GetFileName(filename); // Getting the File Name
}
// Account
var Paycol1 = File.ReadLines(PayRepfilePath).Select((line, index) => index == 0 ? line + ",Account"
: line + ",Meal Prep Haven").ToList();
File.WriteAllLines(PayRepfilePath, Paycol1);
// Country
var Paycol2 = File.ReadLines(PayRepfilePath).Select((line, index) => index == 0 ? line + ",Country"
: line + ",US").ToList();
File.WriteAllLines(PayRepfilePath, Paycol2);
// Reference URL
var Paycol3 = File.ReadLines(PayRepfilePath).Select((line, index) => index == 0 ? line + ",Reference"
: line + ",https://sellercentral.amazon.com/payments/reports/custom/request?tbla_daterangereportstable=sort:%7B%22sortOrder%22%3A%22DESCENDING%22%7D;search:undefined;pagination:1;").ToList(); //+ driver.Url).ToList();
File.WriteAllLines(PayRepfilePath, Paycol3);
// Renaming the Report File
File.Move(PayRepfilePath, directoryFullPath + "PaymentReport.csv");
// Uploading Payment Report to Azure Data Lake
Azuresource = directoryFullPath + "PaymentReport.csv";
Azuredestination = "Meal prep haven/CA_AO/Payment Reports/" + "PaymentReport-17-10-2019.csv"; //+ DateTime.Now.ToString("dd/MM/yyyy") + ".csv";
adlsFileSystemClient.FileSystem.UploadFile(AdlsAccountName, Azuresource, Azuredestination, 1, false, true);
Console.WriteLine("Uploaded Payment Report");
// Deleting the Payment Report File
Array.ForEach(Directory.GetFiles(directoryFullPath), File.Delete);
// ------------------ REPORT 5 ------------------ // ---- Automating Scraping Method ----
// Downloading Storage Fees Report
driver.Navigate().GoToUrl("https://sellercentral.amazon.com/gp/ssof/reports/search.html#orderAscending=&recordType=STORAGE_FEE_CHARGES&noResultType=&merchantSku=&fnSku=&FnSkuXORMSku=&reimbursementId=&orderId=&genericOrderId=&asin=&lpn=&shipmentId=&problemType=ALL_DEFECT_TYPES&hazmatStatus=&inventoryEventTransactionType=&fulfillmentCenterId=&transactionItemId=&inventoryAdjustmentReasonGroup=&eventDateOption=1&fromDate=mm%2Fdd%2Fyyyy&toDate=mm%2Fdd%2Fyyyy&startDate=&endDate=&fromMonth=1&fromYear=2019&toMonth=1&toYear=2019&startMonth=&startYear=&endMonth=&endYear=&specificMonth=1&specificYear=2019");
Thread.Sleep(1000);
driver.FindElement(By.XPath("//*[@id=\"specificMonthDownload\"]/option[9]")).Click();
driver.FindElement(By.XPath("//*[@id=\"specificYearDownload\"]/option[1]")).Click();
driver.FindElement(By.XPath("//*[@id=\"requestCsvTsvDownload\"]/tr[1]/td[2]/button")).Click();
driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(4000);
Thread.Sleep(10000);
driver.FindElement(By.XPath("//*[@id=\"downloadArchive\"]/table/tbody/tr[1]/td[5]/a")).Click();
// Editing the Storage Fees CSV
// Appending Columns and Values in Existing CSV File
string StoRepfilePath = "";
foreach (string filename in Directory.GetFiles(directoryFullPath))
{
StoRepfilePath = directoryFullPath + Path.GetFileName(filename); // Getting the File Name
}
// Account
var Stocol1 = File.ReadLines(StoRepfilePath).Select((line, index) => index == 0 ? line + ",Account"
: line + ",Meal Prep Haven").ToList();
File.WriteAllLines(StoRepfilePath, Stocol1);
// Country
var Stocol2 = File.ReadLines(StoRepfilePath).Select((line, index) => index == 0 ? line + ",Country"
: line + ",US").ToList();
File.WriteAllLines(StoRepfilePath, Stocol2);
// Reference URL
var Stocol3 = File.ReadLines(StoRepfilePath).Select((line, index) => index == 0 ? line + ",Reference"
: line + "," + driver.Url).ToList();
File.WriteAllLines(StoRepfilePath, Stocol3);
// Transaction Date
var Stocol4 = File.ReadLines(StoRepfilePath).Select((line, index) => index == 0 ? line + ", Transaction Date"
: line + "," + DateTime.Now.ToString("MM/dd/yyyy")).ToList();
File.WriteAllLines(StoRepfilePath, Stocol4);
// Renaming the Report File
File.Move(StoRepfilePath, directoryFullPath + "StorageFeesReport.csv");
// Uploading Storage Fees Report to Azure Data Lake
Azuresource = directoryFullPath + "StorageFeesReport.csv";
Azuredestination = "Meal prep haven/CA_AO/Storage Fees Reports/" + "StorageFeesReport-" + DateTime.Now.ToString("dd/MM/yyyy") + ".csv";
adlsFileSystemClient.FileSystem.UploadFile(AdlsAccountName, Azuresource, Azuredestination, 1, false, true);
Console.WriteLine("Uploaded Storage Fees Report");
// Deleting the Storage Fees Report File
Array.ForEach(Directory.GetFiles(directoryFullPath), File.Delete);
// ------------------ REPORT 6 ------------------ // ---- API Method ----
// Downloading Amazon ADS Product Report through API
// Refreshing Access Token
var client1 = new RestClient("https://api.amazon.com/auth/o2/token");
var request1 = new RestRequest(Method.POST);
request1.AddHeader("Content-Type", "application/x-www-form-urlencoded");
request1.AddParameter("grant_type", "refresh_token");
request1.AddParameter("refresh_token", ADS_RefreshToken);
request1.AddParameter("client_id", ADS_ClientID);
request1.AddParameter("client_secret", ADS_ClientSecret);
IRestResponse response1 = client1.Execute(request1);
dynamic result1 = JsonConvert.DeserializeObject(response1.Content);
string ADS_AccessToken = result1.access_token;
// Getting the Report ID
var client2 = new RestClient("https://advertising-api.amazon.com/v2/sp/productAds/report");
var request2 = new RestRequest(Method.POST);
request2.AddHeader("Content-Type", "application/json");
request2.AddHeader("Authorization", "Bearer " + ADS_AccessToken);
request2.AddHeader("Amazon-Advertising-API-ClientId", ADS_ClientID);
request2.AddHeader("Amazon-Advertising-API-Scope", ADS_Scope);
request2.AddParameter("undefined", "{\"reportDate\":\"20190930\", \"metrics\":\"campaignName,campaignId,adGroupName,adGroupId,currency,asin,sku,impressions,clicks,cost,attributedConversions1d,attributedConversions7d,attributedConversions14d,attributedConversions30d,attributedConversions1dSameSKU,attributedConversions7dSameSKU,attributedConversions14dSameSKU,attributedConversions30dSameSKU,attributedUnitsOrdered1d,attributedUnitsOrdered7d,attributedUnitsOrdered14d,attributedUnitsOrdered30d,attributedSales1d,attributedSales7d,attributedSales14d,attributedSales30d,attributedSales1dSameSKU,attributedSales7dSameSKU,attributedSales14dSameSKU,attributedSales30dSameSKU\"}", ParameterType.RequestBody);
IRestResponse response2 = client2.Execute(request2);
dynamic result2 = JsonConvert.DeserializeObject(response2.Content);
string ReportID = result2.reportId;
Thread.Sleep(3000);
// Retrieving the Report Status
var client3 = new RestClient("https://advertising-api.amazon.com/v2/reports/" + ReportID);
var request3 = new RestRequest(Method.GET);
request3.AddHeader("Content-Type", "application/json");
request3.AddHeader("Authorization", "Bearer " + ADS_AccessToken);
request3.AddHeader("Amazon-Advertising-API-ClientId", ADS_ClientID);
request3.AddHeader("Amazon-Advertising-API-Scope", ADS_Scope);
IRestResponse response3 = client3.Execute(request3);
dynamic result3 = JsonConvert.DeserializeObject(response3.Content);
string DownloadLocation = result3.location;
if (result3.status == "SUCCESS")
{
// Retrieving Report Download URL
var client4 = new RestClient(DownloadLocation);
var request4 = new RestRequest(Method.GET);
request4.AddHeader("Authorization", "Bearer " + ADS_AccessToken);
request4.AddHeader("Amazon-Advertising-API-Scope", ADS_Scope);
IRestResponse response4 = client4.Execute(request4);
string DownloadURL = response4.ResponseUri.ToString();
// Downloading the Report
driver.Navigate().GoToUrl(DownloadURL);
}
// Extracting .gz Zip file
DirectoryInfo directorySelected = new DirectoryInfo(directoryFullPath);
foreach (FileInfo fileToDecompress in directorySelected.GetFiles("*.gz"))
{
Decompress(fileToDecompress);
}
// Uploading Amazon ADS Product Report to Azure Data Lake
Azuresource = directoryFullPath + "ADSProductReport.json";
Azuredestination = "Meal prep haven/CA_AO/Advertised Product Reports/" + "AmazonADSProductReport-" + DateTime.Now.ToString("dd/MM/yyyy") + ".json";
adlsFileSystemClient.FileSystem.UploadFile(AdlsAccountName, Azuresource, Azuredestination, 1, false, true);
Console.WriteLine("Uploaded Amazon ADS Product Report");
// Deleting the Amazon ADS Product Report File
Array.ForEach(Directory.GetFiles(directoryFullPath), File.Delete);
// ------------------ REPORT 7 ------------------ // ---- API Method ----
// Downloading WorldPack Report through API
// Getting the Access Token
var clientw1 = new RestClient("http://secure-wms.com/AuthServer/api/Token");
var requestw1 = new RestRequest(Method.POST);
requestw1.AddHeader("Content-Type", "application/json; charset=utf-8");
requestw1.AddHeader("Accept", "application/json");
requestw1.AddHeader("Authorization", "Basic " + WP_Authorization);
requestw1.AddParameter("undefined", "{\"grant_type\": \"client_credentials\",\"tpl\": \"{1ddbea91-a4ff-4b42-a25d-81a25b8cb727}\",\"user_login_id\": \"759\"}", ParameterType.RequestBody);
IRestResponse responsew1 = clientw1.Execute(requestw1);
dynamic resultw1 = JsonConvert.DeserializeObject(responsew1.Content);
string WP_AccessToken = resultw1.access_token;
// Getting the Inventory Details
var clientw2 = new RestClient("https://secure-wms.com/inventory/stockdetails?customerid=194&facilityid=4");
var requestw2 = new RestRequest(Method.GET);
requestw2.AddHeader("Content-Type", "application/hal+json; charset=utf-8");
requestw2.AddHeader("Accept", "application/hal+json");
requestw2.AddHeader("Authorization", "Bearer " + WP_AccessToken);
IRestResponse responsew2 = clientw2.Execute(requestw2);
dynamic resultw2 = JsonConvert.DeserializeObject(responsew2.Content);
string jsonstr = resultw2._embedded.ToString();
// Uploading WorldPack Report to Azure Data Lake
Azuresource = directoryFullPath + "WorldPackReport.json";
Azuredestination = "Third Party Reports/WorldPack Reports/" + "WorldPackReport-" + DateTime.Now.ToString("dd/MM/yyyy") + ".json";
adlsFileSystemClient.FileSystem.UploadFile(AdlsAccountName, Azuresource, Azuredestination, 1, false, true);
Console.WriteLine("Uploaded World Pack Report");
// Deleting the Amazon ADS Product Report File
Array.ForEach(Directory.GetFiles(directoryFullPath), File.Delete);
// ------------------ REPORT 8 ------------------ // ---- API Method ----
// Downloading Amazon MWS Reports - FBA_StorageFees Report through API
string accessKeyId = MWS_AccessID;
string secretAccessKey = MWS_SecretKey;
MarketplaceWebServiceConfig config = new MarketplaceWebServiceConfig();
config.ServiceURL = "https://mws.amazonservices.com";
const string applicationName = "ApplicationName";
const string applicationVersion = "0.1a";
MarketplaceWebServiceClient service =
new MarketplaceWebServiceClient(
accessKeyId,
secretAccessKey,
applicationName,
applicationVersion,
config);
string merchantID = MWS_MerchantID;
string mwsauthtoken = MWS_AuthToken;
// Requesting the Report
RequestReportRequest reportRequest = new RequestReportRequest();
reportRequest.Merchant = merchantID;
reportRequest.MWSAuthToken = mwsauthtoken;
reportRequest.ReportType = "_GET_FBA_STORAGE_FEE_CHARGES_DATA_";
reportRequest.StartDate = DateTime.Parse(DateTime.Now.AddMonths(-1).ToString("dd/MM/yyyy"));
reportRequest.EndDate = DateTime.Now;
reportRequest.ReportOptions = "true"; //shows sales channel to certain reports
// Handling the Response of RequestReport
RequestReportResponse reportResponse = service.RequestReport(reportRequest);
Thread.Sleep(30000); //sleep for 30 seconds to allow report request to generate prior to requesting the reportRequestID
string requestID = reportResponse.RequestReportResult.ReportRequestInfo.ReportRequestId;
string reportStatus = ""; // holds the status of the report
// Getting the Report Request List
GetReportRequestListRequest reportRequestList = new GetReportRequestListRequest();
reportRequestList.Merchant = merchantID;
reportRequestList.MWSAuthToken = mwsauthtoken;
// Handling the Response of Report Request List
GetReportRequestListResponse reportRequestListReponse = service.GetReportRequestList(reportRequestList);
foreach (ReportRequestInfo info in reportRequestListReponse.GetReportRequestListResult.ReportRequestInfo)
{
if (info.ReportRequestId.Equals(requestID))
{
reportStatus = info.ReportProcessingStatus;
if (reportStatus == "_DONE_")
{
// Getting the Report using Report ID
GetReportRequest getReport = new GetReportRequest();
getReport.ReportId = info.GeneratedReportId;
getReport.Merchant = merchantID;
getReport.MWSAuthToken = mwsauthtoken;
// Writting the Report as a File
string filename = Path.Combine(directoryFullPath, "FBA_StorageFeesReport-" + DateTime.Now.ToString("dd/MM/yyyy") + ".csv");
getReport.Report = File.Open(filename, FileMode.OpenOrCreate, FileAccess.ReadWrite);
GetReportResponse report_response = service.GetReport(getReport);
Console.WriteLine("Sleeping for 1 minute to allow processes to settle. ");
Thread.Sleep(60000);
getReport.Report.Close();
// Uploading FBA Storage Fees to Azure Data Lake
Azuresource = filename;
Azuredestination = "Amazon MWS Reports/" + "FBA_StorageFeesReport-" + System.DateTime.Now.ToString("dd/MM/yyyy") + ".csv";
adlsFileSystemClient.FileSystem.UploadFile(AdlsAccountName, Azuresource, Azuredestination, 1, false, true);
Console.WriteLine("Uploaded Amazon MWS FBA_StorageFees Report");
break;
}
}
else
{
continue; // Only concerning about the requested report, not all the reports being generated
}
}
// Closing the Browser
driver.Quit();
}
public static void GetAmazonReport(string accountName, string merchantId, string marketplaceId, string accessKeyId, string secretAccessKey, string reportGenerateId)
{
string senderEmail = ConfigurationManager.AppSettings["senderEmail"];
string messageFromPassword = ConfigurationManager.AppSettings["messageFromPassword"];
string messageToEmail = ConfigurationManager.AppSettings["messageToEmail"];
string smtpClient = ConfigurationManager.AppSettings["smtpClient"];
int smtpPortNum = ConvertUtility.ToInt(ConfigurationManager.AppSettings["smtpPortNum"]);
GetReportRequest request = new GetReportRequest();
request.Merchant = merchantId;
request.ReportId = reportGenerateId;
//request.Report = File.Open(ConfigurationManager.AppSettings["filePath"], FileMode.OpenOrCreate, FileAccess.ReadWrite);
request.Report = new FileStream(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) + "\\" + accountName + "_AmazonInventoryReport.xml", FileMode.Truncate, FileAccess.ReadWrite);
const string applicationName = "<Your Application Name>";
const string applicationVersion = "<Your Application Version>";
MarketplaceWebServiceConfig config = new MarketplaceWebServiceConfig();
config.ServiceURL = "https://mws.amazonservices.com";
config.SetUserAgentHeader(
applicationName,
applicationVersion,
"C#",
"<Parameter 1>", "<Parameter 2>");
MarketplaceWebService.MarketplaceWebService service = new MarketplaceWebServiceClient(accessKeyId, secretAccessKey, config);
try
{
GetReportResponse response = service.GetReport(request);
Console.WriteLine("Service Response");
Console.WriteLine("=============================================================================");
Console.WriteLine();
Console.WriteLine(" GetReportResponse");
if (response.IsSetGetReportResult())
{
Console.WriteLine(" GetReportResult");
GetReportResult getReportResult = response.GetReportResult;
if (getReportResult.IsSetContentMD5())
{
Console.WriteLine(" ContentMD5");
Console.WriteLine(" {0}", getReportResult.ContentMD5);
}
}
if (response.IsSetResponseMetadata())
{
Console.WriteLine(" ResponseMetadata");
ResponseMetadata responseMetadata = response.ResponseMetadata;
if (responseMetadata.IsSetRequestId())
{
Console.WriteLine(" RequestId");
Console.WriteLine(" {0}", responseMetadata.RequestId);
}
}
Console.WriteLine(" ResponseHeaderMetadata");
Console.WriteLine(" RequestId");
Console.WriteLine(" " + response.ResponseHeaderMetadata.RequestId);
Console.WriteLine(" ResponseContext");
Console.WriteLine(" " + response.ResponseHeaderMetadata.ResponseContext);
Console.WriteLine(" Timestamp");
Console.WriteLine(" " + response.ResponseHeaderMetadata.Timestamp);
}
catch (MarketplaceWebServiceException ex)
{
ExceptionUtility exceptionUtility = new ExceptionUtility();
exceptionUtility.CatchMethod(ex, "GetAmazonReport ", accountName + " " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum);
}
request.Report.Close();
request.Report.Dispose();
}
public MemoryStream GetReportData(ReportType reportType, DateTime?startDate = null, DateTime?endDate = null)
{
RequestReportRequest requestReportRequest = new RequestReportRequest()
.WithMarketplaceIdList(new IdList {
Id = new List <string> {
m_marketPlaceId
}
})
.WithReportType(reportType.ToString())
.WithMerchant(m_sellerId)
.WithReportOptions("true");
if (startDate.HasValue)
{
requestReportRequest.WithStartDate(startDate.Value);
}
if (endDate.HasValue)
{
requestReportRequest.WithEndDate(endDate.Value);
}
Func <MemoryStream> getMemoryStream = () =>
{
RequestReportResponse requestReportResponse = m_service.RequestReport(requestReportRequest);
Func <string> getReportRequestId = () =>
{
ReportRequestInfo reportRequestInfo = requestReportResponse.RequestReportResult.ReportRequestInfo;
if (reportRequestInfo.ReportRequestId == null)
{
throw new RetryException("Need to wait for ReportRequestId to become not null in the getReportRequestId");
}
return(reportRequestInfo.ReportRequestId);
};
string reportRequestId = getReportRequestId.Retry(12, 5000);
if (reportRequestId == null)
{
throw new QuitException("reportRequestId is null after getReportRequestId");
}
GetReportRequestListRequest reportRequestList = new GetReportRequestListRequest()
.WithMerchant(m_sellerId)
.WithReportRequestIdList(new IdList {
Id = new List <string> {
reportRequestId
}
});
Func <string> getGeneratedReportId = () =>
{
string generatedReportId;
try
{
GetReportRequestListResponse reportRequestListResponse = m_service.GetReportRequestList(reportRequestList);
ReportRequestInfo reportRequestInfo = reportRequestListResponse.GetReportRequestListResult.ReportRequestInfo
.FirstOrDefault(w => w.ReportRequestId == reportRequestId);
if (reportRequestInfo == null)
{
throw new RetryException("reportRequestInfo is null in getReport");
}
if (reportRequestInfo.ReportProcessingStatus != "_SUBMITTED_" && reportRequestInfo.ReportProcessingStatus != "_IN_PROGRESS_")
{
if (reportRequestInfo.GeneratedReportId != null)
{
generatedReportId = reportRequestInfo.GeneratedReportId;
}
else
{
throw new QuitException("generatedReportId was null in waitForReportToProcess");
}
}
else
{
throw new RetryException("Had to wait for report to finish processing in waitForReportToProcess");
}
}
catch (MarketplaceWebServiceException)
{
// Caused by throttling, lets wait longer.
Thread.Sleep(60000);
throw new RetryException("Throttled due to MarketplaceWebServiceException.");
}
return(generatedReportId);
};
string returnedGeneratedReportId = getGeneratedReportId.Retry(30, 30000);
if (returnedGeneratedReportId == null)
{
throw new QuitException("reportId was null, from getReport");
}
MemoryStream returnedMemoryStream = null;
try
{
MemoryStream memoryStream = new MemoryStream();
GetReportRequest reportRequest = new GetReportRequest {
Merchant = m_sellerId, ReportId = returnedGeneratedReportId, Report = memoryStream
};
GetReportResponse response = m_service.GetReport(reportRequest);
string md5String = response.GetReportResult.ContentMD5;
if (!md5String.Equals(memoryStream.ComputeMd5(), StringComparison.InvariantCulture))
{
throw new QuitException("contentMd5 did not match!");
}
returnedMemoryStream = memoryStream;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
if (returnedMemoryStream == null)
{
throw new QuitException("returnedMemoryStream was null.");
}
return(returnedMemoryStream);
};
return(getMemoryStream.Retry(30, 180000, true));
}
