public void RefreshListings(ERPContext context, string accountName)
{
try
{
RequestReportRequest request = new RequestReportRequest();
request.MWSAuthToken = mwsAuthTokenDictionary[accountName];
request.Merchant = sellerIdDictionary[accountName];
request.ReportType = "_GET_FLAT_FILE_OPEN_LISTINGS_DATA_";
RequestReportResponse response = mwsClient.RequestReport(request);
string requestId = response.RequestReportResult.ReportRequestInfo.ReportRequestId;
int count = 0;
bool done = false;
while (count < 100 && !done)
{
Thread.Sleep(60000);
GetReportRequestListRequest reportListRequest = new GetReportRequestListRequest();
reportListRequest.MWSAuthToken = mwsAuthTokenDictionary[accountName];
reportListRequest.Merchant = sellerIdDictionary[accountName];
reportListRequest.ReportRequestIdList = new IdList();
reportListRequest.ReportRequestIdList.Id.Add(requestId);
GetReportRequestListResponse reportListResponse = mwsClient.GetReportRequestList(reportListRequest);
foreach (ReportRequestInfo info in reportListResponse.GetReportRequestListResult.ReportRequestInfo)
{
if (info.ReportRequestId == requestId)
{
if (info.ReportProcessingStatus == "_DONE_")
{
done = true;
GetInventoryReport(context, accountName, info.GeneratedReportId);
}
}
}
count++;
}
}
catch (Exception e)
{
m_logger.Error(e.Message);
}
}
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();
}
private void DownloadSalesData()
{
this.StatusDescription = string.Format("Creating MWS client");
// Set up MWS client
string accessKey = System.Configuration.ConfigurationManager.AppSettings["MwsAccK"];
string secretKey = System.Configuration.ConfigurationManager.AppSettings["MwsSecK"];
string sellerId = System.Configuration.ConfigurationManager.AppSettings["MwsSeller"];
string marketplaceId = System.Configuration.ConfigurationManager.AppSettings["MwsMktpl"];
MarketplaceWebServiceConfig config = new MarketplaceWebServiceConfig();
config.ServiceURL = "https://mws.amazonservices.com ";
config.SetUserAgentHeader("CMA", "1.0", "C#", new string[] { });
MarketplaceWebServiceClient client = new MarketplaceWebServiceClient(accessKey, secretKey, config);
// Submit the report request
MarketplaceWebService.Model.RequestReportRequest request = new MarketplaceWebService.Model.RequestReportRequest();
request.ReportType = "_GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_";
request.Merchant = sellerId;
request.StartDate = DateTime.Now.AddDays(-30).AddHours(-6);
request.EndDate = DateTime.Now.AddHours(-6);
this.StatusDescription = string.Format("Requesting Report Type {0} for {1} through {2}", request.ReportType, request.StartDate.ToShortDateString(), request.EndDate.ToShortDateString());
var responseToRequestReport = client.RequestReport(request);
Thread.Sleep(1000);
string reportRequestId = "";
if (responseToRequestReport.IsSetRequestReportResult())
{
if (responseToRequestReport.RequestReportResult.IsSetReportRequestInfo())
{
if (responseToRequestReport.RequestReportResult.ReportRequestInfo.IsSetReportRequestId())
{
reportRequestId = responseToRequestReport.RequestReportResult.ReportRequestInfo.ReportRequestId;
}
else
{
// Would be good to implement wait-and-retry here
throw new Exception("ReportRequestId was not returned from RequestReport()");
}
}
}
this.StatusDescription = string.Format("Report Request ID: {0}", reportRequestId);
Thread.Sleep(1000);
// Check for the report to have a _DONE_ status
string reportId = "";
bool reportDone = false;
do
{
this.StatusDescription = string.Format("Checking report status");
MarketplaceWebService.Model.GetReportRequestListRequest requestGetReportRequestList = new MarketplaceWebService.Model.GetReportRequestListRequest();
requestGetReportRequestList.ReportRequestIdList = new MarketplaceWebService.Model.IdList();
requestGetReportRequestList.ReportRequestIdList.Id = new List<string>();
requestGetReportRequestList.ReportRequestIdList.Id.Add(reportRequestId);
requestGetReportRequestList.Merchant = sellerId;
var responseToGetReportRequestList = client.GetReportRequestList(requestGetReportRequestList);
if (responseToGetReportRequestList.IsSetGetReportRequestListResult() && responseToGetReportRequestList.GetReportRequestListResult.IsSetReportRequestInfo() && responseToGetReportRequestList.GetReportRequestListResult.ReportRequestInfo.Count != 0)
{
this.StatusDescription = string.Format("Report status: {0}", responseToGetReportRequestList.GetReportRequestListResult.ReportRequestInfo[0].ReportProcessingStatus);
Thread.Sleep(500);
if (responseToGetReportRequestList.GetReportRequestListResult.ReportRequestInfo[0].ReportProcessingStatus.Equals("_DONE_"))
{
reportDone = true;
if (responseToGetReportRequestList.GetReportRequestListResult.ReportRequestInfo[0].IsSetGeneratedReportId())
{
reportId = responseToGetReportRequestList.GetReportRequestListResult.ReportRequestInfo[0].GeneratedReportId;
this.StatusDescription = string.Format("Report ID: {0}", reportId);
}
else
{
// ReportId was not returned, call GetReportList()
this.StatusDescription = string.Format("Report ID was not returned. Trying GetReportList()");
var requestGetReportList = new MarketplaceWebService.Model.GetReportListRequest();
requestGetReportList.ReportRequestIdList = new MarketplaceWebService.Model.IdList();
requestGetReportList.ReportRequestIdList.Id = new List<string>();
requestGetReportList.ReportRequestIdList.Id.Add(reportRequestId);
requestGetReportList.Merchant = sellerId;
var responseToGetReportList = client.GetReportList(requestGetReportList);
if (responseToGetReportList.IsSetGetReportListResult() && responseToGetReportList.GetReportListResult.IsSetReportInfo() && responseToGetReportList.GetReportListResult.ReportInfo.Count != 0)
{
reportId = responseToGetReportList.GetReportListResult.ReportInfo[0].ReportId;
this.StatusDescription = string.Format("Report ID: {0}", reportId);
}
else
{
throw new Exception("ReportId could not be retrieved.");
}
}
}
else if (responseToGetReportRequestList.GetReportRequestListResult.ReportRequestInfo[0].ReportProcessingStatus.Equals("_DONE_NO_DATA_"))
{
throw new Exception("Report returned with status _DONE_NO_DATA_");
}
else
{
for (int secondsTilRetry = 60; secondsTilRetry > 0; secondsTilRetry--)
{
this.StatusDescription = string.Format("Report status: {0} (Will check again in {1}s)", responseToGetReportRequestList.GetReportRequestListResult.ReportRequestInfo[0].ReportProcessingStatus, secondsTilRetry);
Thread.Sleep(1000);
}
}
}
} while (!reportDone);
Thread.Sleep(1000);
// Retrieve the report
string saveFileName = reportId + ".txt";
this.StatusDescription = string.Format("Downloading report to {0}", saveFileName);
MarketplaceWebService.Model.GetReportRequest requestGetReport = new MarketplaceWebService.Model.GetReportRequest();
requestGetReport.ReportId = reportId;
requestGetReport.Merchant = sellerId;
using (Stream file = File.Open(saveFileName, FileMode.OpenOrCreate, FileAccess.ReadWrite)) {
requestGetReport.Report = file;
var responseToGetReport = client.GetReport(requestGetReport);
}
}
private void DownloadSalesData()
{
this.StatusDescription = string.Format("Creating MWS client");
// Set up MWS client
string accessKey = System.Configuration.ConfigurationManager.AppSettings["MwsAccK"];
string secretKey = System.Configuration.ConfigurationManager.AppSettings["MwsSecK"];
string sellerId = System.Configuration.ConfigurationManager.AppSettings["MwsSeller"];
string marketplaceId = System.Configuration.ConfigurationManager.AppSettings["MwsMktpl"];
MarketplaceWebServiceConfig config = new MarketplaceWebServiceConfig();
config.ServiceURL = "https://mws.amazonservices.com ";
config.SetUserAgentHeader("CMA", "1.0", "C#", new string[] { });
MarketplaceWebServiceClient client = new MarketplaceWebServiceClient(accessKey, secretKey, config);
// Submit the report request
MarketplaceWebService.Model.RequestReportRequest request = new MarketplaceWebService.Model.RequestReportRequest();
request.ReportType = "_GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_";
request.Merchant = sellerId;
request.StartDate = DateTime.Now.AddDays(-30).AddHours(-6);
request.EndDate = DateTime.Now.AddHours(-6);
this.StatusDescription = string.Format("Requesting Report Type {0} for {1} through {2}", request.ReportType, request.StartDate.ToShortDateString(), request.EndDate.ToShortDateString());
var responseToRequestReport = client.RequestReport(request);
Thread.Sleep(1000);
string reportRequestId = "";
if (responseToRequestReport.IsSetRequestReportResult())
{
if (responseToRequestReport.RequestReportResult.IsSetReportRequestInfo())
{
if (responseToRequestReport.RequestReportResult.ReportRequestInfo.IsSetReportRequestId())
{
reportRequestId = responseToRequestReport.RequestReportResult.ReportRequestInfo.ReportRequestId;
}
else
{
// Would be good to implement wait-and-retry here
throw new Exception("ReportRequestId was not returned from RequestReport()");
}
}
}
this.StatusDescription = string.Format("Report Request ID: {0}", reportRequestId);
Thread.Sleep(1000);
// Check for the report to have a _DONE_ status
string reportId = "";
bool reportDone = false;
do
{
this.StatusDescription = string.Format("Checking report status");
MarketplaceWebService.Model.GetReportRequestListRequest requestGetReportRequestList = new MarketplaceWebService.Model.GetReportRequestListRequest();
requestGetReportRequestList.ReportRequestIdList = new MarketplaceWebService.Model.IdList();
requestGetReportRequestList.ReportRequestIdList.Id = new List <string>();
requestGetReportRequestList.ReportRequestIdList.Id.Add(reportRequestId);
requestGetReportRequestList.Merchant = sellerId;
var responseToGetReportRequestList = client.GetReportRequestList(requestGetReportRequestList);
if (responseToGetReportRequestList.IsSetGetReportRequestListResult() && responseToGetReportRequestList.GetReportRequestListResult.IsSetReportRequestInfo() && responseToGetReportRequestList.GetReportRequestListResult.ReportRequestInfo.Count != 0)
{
this.StatusDescription = string.Format("Report status: {0}", responseToGetReportRequestList.GetReportRequestListResult.ReportRequestInfo[0].ReportProcessingStatus);
Thread.Sleep(500);
if (responseToGetReportRequestList.GetReportRequestListResult.ReportRequestInfo[0].ReportProcessingStatus.Equals("_DONE_"))
{
reportDone = true;
if (responseToGetReportRequestList.GetReportRequestListResult.ReportRequestInfo[0].IsSetGeneratedReportId())
{
reportId = responseToGetReportRequestList.GetReportRequestListResult.ReportRequestInfo[0].GeneratedReportId;
this.StatusDescription = string.Format("Report ID: {0}", reportId);
}
else
{
// ReportId was not returned, call GetReportList()
this.StatusDescription = string.Format("Report ID was not returned. Trying GetReportList()");
var requestGetReportList = new MarketplaceWebService.Model.GetReportListRequest();
requestGetReportList.ReportRequestIdList = new MarketplaceWebService.Model.IdList();
requestGetReportList.ReportRequestIdList.Id = new List <string>();
requestGetReportList.ReportRequestIdList.Id.Add(reportRequestId);
requestGetReportList.Merchant = sellerId;
var responseToGetReportList = client.GetReportList(requestGetReportList);
if (responseToGetReportList.IsSetGetReportListResult() && responseToGetReportList.GetReportListResult.IsSetReportInfo() && responseToGetReportList.GetReportListResult.ReportInfo.Count != 0)
{
reportId = responseToGetReportList.GetReportListResult.ReportInfo[0].ReportId;
this.StatusDescription = string.Format("Report ID: {0}", reportId);
}
else
{
throw new Exception("ReportId could not be retrieved.");
}
}
}
else if (responseToGetReportRequestList.GetReportRequestListResult.ReportRequestInfo[0].ReportProcessingStatus.Equals("_DONE_NO_DATA_"))
{
throw new Exception("Report returned with status _DONE_NO_DATA_");
}
else
{
for (int secondsTilRetry = 60; secondsTilRetry > 0; secondsTilRetry--)
{
this.StatusDescription = string.Format("Report status: {0} (Will check again in {1}s)", responseToGetReportRequestList.GetReportRequestListResult.ReportRequestInfo[0].ReportProcessingStatus, secondsTilRetry);
Thread.Sleep(1000);
}
}
}
} while (!reportDone);
Thread.Sleep(1000);
// Retrieve the report
string saveFileName = reportId + ".txt";
this.StatusDescription = string.Format("Downloading report to {0}", saveFileName);
MarketplaceWebService.Model.GetReportRequest requestGetReport = new MarketplaceWebService.Model.GetReportRequest();
requestGetReport.ReportId = reportId;
requestGetReport.Merchant = sellerId;
using (Stream file = File.Open(saveFileName, FileMode.OpenOrCreate, FileAccess.ReadWrite)) {
requestGetReport.Report = file;
var responseToGetReport = client.GetReport(requestGetReport);
}
}
public static DataTable GetAmazonReportRequestList(string accountName, string merchantId, string marketplaceId, string accessKeyId, string secretAccessKey)
{
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"]);
DataTable GeneratedReportDt = new DataTable();
GeneratedReportDt.Columns.Add("ReportRequestId", typeof(System.String));
GeneratedReportDt.Columns.Add("ReportGenerateId", typeof(System.String));
GeneratedReportDt.Columns.Add("Status", typeof(System.String));
GetReportRequestListRequest request = new GetReportRequestListRequest();
request.Merchant = merchantId;
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>");
request.MaxCount = 3;
MarketplaceWebService.MarketplaceWebService service = new MarketplaceWebServiceClient(accessKeyId, secretAccessKey, config);
try
{
GetReportRequestListResponse response = service.GetReportRequestList(request);
Console.WriteLine("Service Response");
Console.WriteLine("=============================================================================");
Console.WriteLine();
Console.WriteLine(" GetReportRequestListResponse");
if (response.IsSetGetReportRequestListResult())
{
Console.WriteLine(" GetReportRequestListResult");
GetReportRequestListResult getReportRequestListResult = response.GetReportRequestListResult;
List <ReportRequestInfo> reportRequestInfoList = getReportRequestListResult.ReportRequestInfo;
foreach (ReportRequestInfo reportRequestInfo in reportRequestInfoList)
{
DataRow GeneratedReportDr = GeneratedReportDt.NewRow();
Console.WriteLine(" ReportRequestInfo");
if (reportRequestInfo.IsSetReportProcessingStatus())
{
Console.WriteLine(" ReportProcessingStatus");
Console.WriteLine(" {0}", reportRequestInfo.ReportProcessingStatus);
GeneratedReportDr["Status"] = reportRequestInfo.ReportProcessingStatus;
}
if (reportRequestInfo.IsSetReportRequestId())
{
Console.WriteLine(" ReportRequestId");
Console.WriteLine(" {0}", reportRequestInfo.ReportRequestId);
GeneratedReportDr["ReportRequestId"] = reportRequestInfo.ReportRequestId;
}
if (reportRequestInfo.IsSetGeneratedReportId())
{
Console.WriteLine(" GeneratedReportId");
Console.WriteLine(" {0}", reportRequestInfo.GeneratedReportId);
GeneratedReportDr["ReportGenerateId"] = reportRequestInfo.GeneratedReportId;
}
if (reportRequestInfo.IsSetReportType())
{
Console.WriteLine(" ReportType");
Console.WriteLine(" {0}", reportRequestInfo.ReportType);
}
if (reportRequestInfo.IsSetStartDate())
{
Console.WriteLine(" StartDate");
Console.WriteLine(" {0}", reportRequestInfo.StartDate);
}
if (reportRequestInfo.IsSetEndDate())
{
Console.WriteLine(" EndDate");
Console.WriteLine(" {0}", reportRequestInfo.EndDate);
}
if (reportRequestInfo.IsSetSubmittedDate())
{
Console.WriteLine(" SubmittedDate");
Console.WriteLine(" {0}", reportRequestInfo.SubmittedDate);
}
GeneratedReportDt.Rows.Add(GeneratedReportDr);
}
}
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, "GetAmazonReportRequestList ", accountName + " " + ex.Message.ToString(), senderEmail, messageFromPassword, messageToEmail, smtpClient, smtpPortNum);
}
return(GeneratedReportDt);
}
public void GetReports(string reportType)
{
try
{
MarketplaceWebServiceClient service = new MarketplaceWebServiceClient(accessKeyId, secretAccessKey, applicationName, applicationVersion, config);
RequestReportRequest reportRequestRequest = new RequestReportRequest();
reportRequestRequest.Merchant = sellerId;
reportRequestRequest.MWSAuthToken = mwsAuthToken;
reportRequestRequest.MarketplaceIdList = new IdList();
reportRequestRequest.MarketplaceIdList.Id.Add("ATVPDKIKX0DER");
reportRequestRequest.ReportType = "_GET_FLAT_FILE_OFFAMAZONPAYMENTS_SANDBOX_SETTLEMENT_DATA_";
// you can change ReportType here:
//http://docs.developer.amazonservices.com/en_IN/reports/Reports_ReportType.html
RequestReportResponse requestResponse = service.RequestReport(reportRequestRequest);
IdList lstRequestID = new IdList();
lstRequestID.Id.Add(requestResponse.RequestReportResult.ReportRequestInfo.ReportRequestId);
GetReportRequestListRequest reportRequestListRequest = new GetReportRequestListRequest();
reportRequestListRequest.Merchant = sellerId;
reportRequestListRequest.ReportRequestIdList = lstRequestID;
reportRequestListRequest.MWSAuthToken = mwsAuthToken;
List <ReportRequestInfo> myListzz = new List <ReportRequestInfo>();
GetReportRequestListResponse reportRequestListResponse = new GetReportRequestListResponse();
reportRequestListResponse = service.GetReportRequestList(reportRequestListRequest);
GetReportRequestListResult reportRequestListResult = new GetReportRequestListResult();
reportRequestListResult = reportRequestListResponse.GetReportRequestListResult;
myListzz = reportRequestListResult.ReportRequestInfo;
if (myListzz.Count > 0)
{
while (myListzz[0].ReportProcessingStatus.ToString() != "_DONE_")
{
Console.WriteLine("Waiting for Report");
Thread.Sleep(60000);
reportRequestListResponse =
service.GetReportRequestList(reportRequestListRequest);
reportRequestListResult =
reportRequestListResponse.GetReportRequestListResult;
myListzz = reportRequestListResult.ReportRequestInfo;
}
}
//if (myListzz[0].GeneratedReportId == null) {
// GetReportListRequest reportListRequest = new GetReportListRequest();
// reportListRequest.Merchant = sellerId;
// reportListRequest.MWSAuthToken = mwsAuthToken;
// reportListRequest.ReportRequestIdList = lstRequestID;
// reportListRequest.ReportTypeList = new TypeList();
// reportListRequest.ReportTypeList.Type = new List<string>() { "_GET_MERCHANT_LISTINGS_ALL_DATA_" };
// var reportList = service.GetReportList(reportListRequest);
// if (myListzz.Count > 0)
// {
// GetReportRequest reportRequest = new GetReportRequest();
// reportRequest.Merchant = sellerId;
// reportRequest.MWSAuthToken = mwsAuthToken;
// reportRequest.ReportId = myListzz[0].GeneratedReportId;
// var report = service.GetReport(reportRequest);
// }
//}
//if (myListzz.Count > 0)
//{
// while (myListzz[0].ReportProcessingStatus.ToString() != "_DONE_")
// {
// Console.WriteLine("Waiting for Report");
// //Thread.Sleep(61000);
// reportRequestListResponse =
// service.GetReportRequestList(reportRequestListRequest);
// reportRequestListResult =
// reportRequestListResponse.GetReportRequestListResult;
// myListzz = reportRequestListResult.ReportRequestInfo;
// }
// if (myListzz[0].GeneratedReportId != null)
// {
// GetReportRequest reportRequest = new GetReportRequest();
// reportRequest.Merchant = sellerId;
// String source = "C:\\myreport.txt";
// reportRequest.ReportId = myListzz[0].GeneratedReportId;
// // reportRequest.Report = File.Open(source, FileMode.Create, FileAccess.ReadWrite);
// service.GetReport(reportRequest);
// }
//}
}
catch (Exception ex)
{
var msg = ex.Message;
}
}
